recreation_resource_docs

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ref_id varchar 2147483647 null
recreation_resource_docs_history.ref_id Implied Constraint R
recreation_resource_image_variants_history.ref_id Implied Constraint R
recreation_resource_images_history.ref_id Implied Constraint R

Unique reference identifier for the document
rec_resource_id varchar 10 √ null
recreation_resource.rec_resource_id recreation_resource_docs_rec_resource_id_fkey R

Recreation Resource ID
title varchar 2147483647 √ null

Title of the document
url varchar 2147483647 √ null

URL where the document can be accessed
doc_code varchar 2147483647 √ null
recreation_resource_doc_code.doc_code recreation_resource_docs_doc_code_fkey R

Foreign key reference to document code type
extension varchar 2147483647 √ null
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_docs_pkey Primary key Asc ref_id
recreation_resource_docs_rec_resource_id_ref_id_key Must be unique Asc/Asc rec_resource_id + ref_id

Relationships

Close relationships within degrees of separation