recreation_structure

-1 rows


Description

Information relating to a recreation site improvement in a recreational tenure. All improvements are human-made.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rec_resource_id varchar 20 null
recreation_resource.rec_resource_id recreation_structure_rec_resource_id_fkey R

Identification manually assigned to a Recreation Resource
structure_code int4 10 null
recreation_structure_code.structure_code recreation_structure_structure_code_fkey R

Indicates the type of structure (human-made improvement)
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)
idx_recreation_structure_rec_resource_id Performance Asc rec_resource_id
recreation_structure_rec_resource_id_structure_code_key Must be unique Asc/Asc rec_resource_id + structure_code

Relationships

Close relationships within degrees of separation