recreation_access

-1 rows


Description

Recreation Resource Access types

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('rst.recreation_access_id_seq'::regclass)
recreation_access_history.id Implied Constraint R
recreation_map_feature.amendment_id Implied Constraint R
recreation_map_feature_geom.map_feature_id Implied Constraint R
recreation_map_feature_geom_history.map_feature_id Implied Constraint R
recreation_map_feature_history.amendment_id Implied Constraint R
rec_resource_id varchar 20 null
recreation_resource.rec_resource_id recreation_access_rec_resource_id_fkey R

Identification manually assigned to a Recreation Resource
access_code varchar 3 null
recreation_access_code.access_code recreation_access_access_code_fkey R

Code identifying the type of access
sub_access_code varchar 3 √ null
recreation_sub_access_code.sub_access_code recreation_access_sub_access_code_fkey R
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_access_pkey Primary key Asc id
idx_recreation_access_rec_resource_id Performance Asc rec_resource_id
recreation_access_rec_resource_id_access_code_sub_access_co_key Must be unique Asc/Asc/Asc rec_resource_id + access_code + sub_access_code

Relationships

Close relationships within degrees of separation