recreation_activity_code_trails

-1 rows


Description

Table linking recreational resources to detailed information about recreation activity codes, including trail types and descriptions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
recreation_activity_code_trails_id serial 10 √ nextval('rst.recreation_activity_code_trails_id_seq'::regclass)
recreation_activity_code int4 10 null
recreation_activity_code.recreation_activity_code recreation_activity_code_trails_recreation_activity_code_fkey R

Foreign key referencing the type of recreational activity (e.g. hiking, biking).
rec_resource_id varchar 20 null
recreation_resource.rec_resource_id recreation_activity_code_trails_rec_resource_id_fkey R

Identifier for the recreational resource (e.g. a specific trail or facility).
trail_type "rst"."trail_types" 2147483647 √ null

Classification of the trail based on difficulty (Green, Blue, Black). Nullable — may be unset while difficulty ratings are pending policy confirmation.
name varchar 120 null

Name of the accessible activity or trail.
description text 2147483647 √ null

Detailed description of the accessible activity, including any specific accommodations or features that enhance accessibility.
updated_at timestamp 29,6 √ now()
sys_period tstzrange 2147483647 tstzrange(CURRENT_TIMESTAMP, NULL::timestamp with time zone)

Indexes

Constraint Name Type Sort Column(s)
recreation_activity_code_trails_pkey Primary key Asc recreation_activity_code_trails_id

Relationships

Close relationships within degrees of separation