recreation_exhibit_a_doc

-1 rows


Description

Exhibit A documents for a recreation resource, stored in a dedicated S3 bucket

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.rec_resource_id recreation_exhibit_a_doc_rec_resource_id_fkey R

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
recreation_establishment_order_docs.s3_key Implied Constraint R

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)

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
recreation_exhibit_a_doc_s3_key_key Must be unique Asc s3_key

Relationships

Close relationships within degrees of separation