Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| IDENTIFIER | BIGINT | 19 | null |
|
|
|||||
| REV | BIGINT | 19 | null |
|
|
|||||
| REVTYPE | SMALLINT | 5 | √ | null |
|
|
||||
| CP_ID | BIGINT | 19 | √ | null |
|
|
||||
| collectionProtocol_MOD | BIT | 1 | √ | null |
|
|
||||
| SENDING_SITE_ID | BIGINT | 19 | √ | null |
|
|
||||
| sendingSite_MOD | BIT | 1 | √ | null |
|
|
||||
| RECEIVING_SITE_ID | BIGINT | 19 | √ | null |
|
|
||||
| receivingSite_MOD | BIT | 1 | √ | null |
|
|
||||
| SENDER_ID | BIGINT | 19 | √ | null |
|
|
||||
| sender_MOD | BIT | 1 | √ | null |
|
|
||||
| SENDING_DATE | TIMESTAMP | 19 | √ | null |
|
|
||||
| sendingDate_MOD | BIT | 1 | √ | null |
|
|
||||
| COMMENTS | VARCHAR | 255 | √ | null |
|
|
||||
| comments_MOD | BIT | 1 | √ | null |
|
|
||||
| ACTIVITY_STATUS | VARCHAR | 16 | √ | null |
|
|
||||
| activityStatus_MOD | BIT | 1 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
