| Name | Description | Data type | Constraints |
|---|---|---|---|
| empid | faculty member's employee ID number | NUMBER(9) | |
| islead | is faculty member the coordinator for this research area? (y or n) | CHAR(1) | |
| area | research area (code) | VARCHAR2(6) | |
| areadiv | research area division (ee or cs) | CHAR(2) | |
| researcharea | research area (full name) | VARCHAR2(100) |