Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| application_guid | uuid | 2147483647 | null |
|
|
||||||
| submission_id | varchar | 50 | null |
|
|
||||||
| tenure_id | varchar | 20 | null |
|
|
||||||
| status_request_guid | varchar | 50 | √ | null |
|
|
|||||
| status_request_type_code | varchar | 3 | null |
|
|
||||||
| status | varchar | 3 | null |
|
|
||||||
| purpose_code | varchar | 1 | null |
|
|
||||||
| recreation_resource_type | varchar | 3 | √ | null |
|
|
|||||
| submission_date | date | 13 | null |
|
|
||||||
| org_unit_code | varchar | 6 | null |
|
|
||||||
| adjudication_ind | bool | 1 | null |
|
|
||||||
| adjudicated_by | varchar | 30 | √ | null |
|
|
|||||
| adjudication_date | timestamp | 29,6 | √ | null |
|
|
|||||
| adjudication_comment | text | 2147483647 | √ | null |
|
|
|||||
| adjudication_report_document_uri | varchar | 2048 | √ | null |
|
|
|||||
| decision | varchar | 7 | √ | null |
|
|
|||||
| updated_at | timestamp | 29,6 | √ | null |
|
|
|||||
| updated_by | text | 2147483647 | √ | null |
|
|
|||||
| created_at | timestamp | 29,6 | √ | null |
|
|
|||||
| created_by | text | 2147483647 | √ | null |
|
|
|||||
| sys_period | tstzrange | 2147483647 | null |
|
|
Relationships
Close relationships within degrees of separation
