Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| IDENTIFIER | BIGINT | 19 | null |
|
|
|||||
| REV | BIGINT | 19 | null |
|
|
|||||
| REVTYPE | TINYINT | 3 | √ | null |
|
|
||||
| NAME | VARCHAR | 255 | √ | null |
|
|
||||
| name_MOD | BIT | 1 | √ | null |
|
|
||||
| ACTIVITY_STATUS | VARCHAR | 255 | √ | null |
|
|
||||
| activityStatus_MOD | BIT | 1 | √ | null |
|
|
||||
| departments_MOD | BIT | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc | IDENTIFIER + REV |
| FK_c4n30y077ycht0hl58ri6fko7 | Performance | Asc | REV |

