| Name | Description | Data type | Constraints |
|---|---|---|---|
| calnetuid | student's CalNet LDAP UID number | NUMBER(9) | |
| div | student's division (ee or cs) | CHAR(2) | |
| lname | student's last name | VARCHAR2(25) | |
| fnames | student's first name(s) | VARCHAR2(25) | |
| student's email address | VARCHAR2(100) | ||
| homepage | student's homepage URL | VARCHAR2(200) | |
| researcharea | student's current or most recent research area (full name, not code) | VARCHAR2(70) | |
| advisoruids | CalNet UIDs of student's advisor(s) | VARCHAR2(4000) | |
| advisors | names of student's advisor(s) | VARCHAR2(4000) |