Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| doc_id | uuid | 2147483647 | gen_random_uuid() |
|
|
Unique UUID identifier for the Exhibit A document |
|||||
| rec_resource_id | varchar | 10 | null |
|
|
Recreation Resource ID this document belongs to |
|||||
| file_name | varchar | 2147483647 | null |
|
|
Display file name of the document (without extension) |
|||||
| extension | varchar | 2147483647 | null |
|
|
File extension (e.g. pdf) |
|||||
| file_size | int8 | 19 | √ | null |
|
|
File size in bytes |
||||
| s3_key | varchar | 2147483647 | null |
|
|
S3 object key (path) in the Exhibit A bucket |
|||||
| updated_at | timestamp | 29,6 | √ | now() |
|
|
|||||
| updated_by | text | 2147483647 | √ | null |
|
|
|||||
| created_at | timestamp | 29,6 | √ | now() |
|
|
|||||
| created_by | text | 2147483647 | √ | null |
|
|
|||||
| sys_period | tstzrange | 2147483647 | tstzrange(CURRENT_TIMESTAMP, NULL::timestamp with time zone) |
|
|
||||||
| submission_id | varchar | 50 | √ | null |
|
|
Spatial submission identifier linked to this Exhibit A output. |
||||
| page_size | varchar | 1 | √ | null |
|
|
Selected Exhibit A page size (A-E). |
||||
| page_orientation | varchar | 20 | √ | null |
|
|
Selected Exhibit A orientation (Portrait or Landscape). |
||||
| scale | int4 | 10 | √ | null |
|
|
Selected Exhibit A map scale. |
||||
| generation_method | varchar | 20 | √ | null |
|
|
How Exhibit A was produced: upload, regenerate, or migrated from FTA. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| recreation_exhibit_a_doc_pkey | Primary key | Asc | doc_id |
| idx_recreation_exhibit_a_doc_rec_resource_id | Performance | Asc | rec_resource_id |
| idx_recreation_exhibit_a_doc_submission_id | Performance | Asc | submission_id |
| recreation_exhibit_a_doc_s3_key_key | Must be unique | Asc | s3_key |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| chk_recreation_exhibit_a_doc_page_size | (((page_size)::text = ANY ((ARRAY['A'::character varying, 'B'::character varying, 'C'::character varying, 'D'::character varying, 'E'::character varying])::text[])) OR (page_size IS NULL)) |
| chk_recreation_exhibit_a_doc_generation_method | (((generation_method)::text = ANY ((ARRAY['upload'::character varying, 'regenerate'::character varying, 'migrated from FTA'::character varying])::text[])) OR (generation_method IS NULL)) |
| chk_recreation_exhibit_a_doc_page_orientation | (((page_orientation)::text = ANY ((ARRAY['Portrait'::character varying, 'Landscape'::character varying])::text[])) OR (page_orientation IS NULL)) |
Relationships
Close relationships within degrees of separation
