Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| site_type | VARCHAR | 30 |
|
|
||||
| region | VARCHAR | 20 |
|
|
||||
| crem_id | VARCHAR | 20 |
|
|
||||
| document_id | BIGINT | 19 | 0 |
|
|
|||
| document_type | VARCHAR | 50 |
|
|
||||
| use | VARCHAR | 30 |
|
|
||||
| project | VARCHAR | 30 |
|
|
||||
| document_date | DATE | 10 | 0000-00-00 |
|
|
|||
| last_event | VARCHAR | 60 |
|
|
||||
| last_user | VARCHAR | 30 |
|
|
||||
| receive_complete | VARCHAR | 110 |
|
|
||||
| file_complete | TEXT | 65535 | √ | null |
|
|
||
| goal_days_to_complete | INT | 10 | 0 |
|
|
|||
| audit_user | VARCHAR | 30 |
|
|
||||
| earliest_abstract_complete_user | VARCHAR | 30 |
|
|
||||
| earliest_validation_complete_user | VARCHAR | 30 |
|
|
||||
| days_at_cbre | INT | 10 | 0 |
|
|
|||
| accuracy | INT | 10 | 0 |
|
|
|||
| corrected_in_validation_ | VARCHAR | 10 |
|
|
||||
| num_of_returns | INT | 10 | 0 |
|
|
|||
| return_note | TEXT | 65535 | √ | null |
|
|
||
| abstract_pending | VARCHAR | 130 |
|
|
||||
| abstract_in_progress | TEXT | 65535 | √ | null |
|
|
||
| abstract_complete | VARCHAR | 90 |
|
|
||||
| operations_pending | TEXT | 65535 | √ | null |
|
|
||
| operations_in_progress | TEXT | 65535 | √ | null |
|
|
||
| operations_complete | TEXT | 65535 | √ | null |
|
|
||
| validation_pending | TEXT | 65535 | √ | null |
|
|
||
| validation_in_progress | TEXT | 65535 | √ | null |
|
|
||
| validation_complete | VARCHAR | 130 |
|
|
||||
| audit_pending | VARCHAR | 170 |
|
|
||||
| audit_in_progress | TEXT | 65535 | √ | null |
|
|
||
| audit_complete | VARCHAR | 70 |
|
|
||||
| signature_pending | VARCHAR | 70 |
|
|
||||
| signature_in_progress | VARCHAR | 70 |
|
|
||||
| signature_complete | VARCHAR | 70 |
|
|
||||
| awaiting_pending | VARCHAR | 230 |
|
|
||||
| awaiting_in_progress | TEXT | 65535 | √ | null |
|
|
||
| awaiting_complete | VARCHAR | 90 |
|
|
||||
| awaiting_pending_seconds | BIGINT | 19 | 0 |
|
|
|||
| awaiting_in_procress_seconds | BIGINT | 19 | 0 |
|
|
|||
| default_review_pending_seconds | BIGINT | 19 | 0 |
|
|
|||
| default_review_in_progress_seconds | BIGINT | 19 | 0 |
|
|
|||
| savings | VARCHAR | 50 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ix_commercial_tracker_crem_id | Performance | Asc | crem_id |
Relationships
Close relationships within degrees of separation
