Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| site_id | INT | 10 | 0 |
|
|
||||||
| sap | VARCHAR | 4 | √ | null |
|
|
|||||
| site_name | VARCHAR | 50 | √ | null |
|
|
|||||
| status_code | CHAR | 4 | √ | null |
|
|
|||||
| role_id | INT | 10 | √ | null |
|
|
|||||
| role_name | VARCHAR | 80 | √ | null |
|
|
|||||
| user_id | INT | 10 | √ | null |
|
|
|||||
| first_name | VARCHAR | 20 |
|
|
|||||||
| last_name | VARCHAR | 20 | √ | null |
|
|
|||||
| site_contact_table | VARCHAR | 23 |
|
|


