Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| firstname | VARCHAR | 40 |
|
|
||||
| lastname | VARCHAR | 40 |
|
|
||||
| ntid | VARCHAR | 20 |
|
|
||||
| emailid | VARCHAR | 80 |
|
|
||||
| pnumber | VARCHAR | 20 |
|
|
||||
| cid | VARCHAR | 20 |
|
|
||||
| title | VARCHAR | 150 | √ | null |
|
|
||
| status | VARCHAR | 20 |
|
|
||||
| terminationdate | VARCHAR | 30 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| emailid | Performance | Asc/Asc | emailid + cid |
Relationships
Close relationships within degrees of separation
