recreation_resource_document

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
doc_id uuid 2147483647 gen_random_uuid()
recreation_image_consent_form.doc_id recreation_image_consent_form_doc_id_fkey R
recreation_image_consent_form_history.doc_id Implied Constraint R
recreation_resource_document_history.doc_id Implied Constraint R

Unique UUID identifier for the document
rec_resource_id varchar 10 null
recreation_resource.rec_resource_id recreation_resource_document_rec_resource_id_fkey R

Recreation Resource ID
doc_code varchar 2147483647 null
recreation_resource_doc_code.doc_code recreation_resource_document_doc_code_fkey R

Foreign key reference to document code type
file_name varchar 2147483647 null

File name of the document
extension varchar 2147483647 null

File extension (e.g., pdf)
file_size int8 19 √ null

File size in bytes
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_resource_document_pkey Primary key Asc doc_id
idx_recreation_resource_document_rec_resource_id Performance Asc rec_resource_id

Relationships

Close relationships within degrees of separation