recreation_resource

-1 rows


Description

Resource information relating to a recreational file. A recreation file can have only one resource. A recreation resource must be of type Site, Reserve, Trail, or Interpretive Forest.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rec_resource_id varchar 20 null
recreation_access.rec_resource_id recreation_access_rec_resource_id_fkey R
recreation_activity.rec_resource_id recreation_activity_rec_resource_id_fkey R
recreation_campsite.rec_resource_id recreation_campsite_rec_resource_id_fkey R
recreation_fee.rec_resource_id recreation_fee_rec_resource_id_fkey R
recreation_map_feature.rec_resource_id recreation_map_feature_rec_resource_id_fkey R
recreation_resource_docs.rec_resource_id recreation_resource_docs_rec_resource_id_fkey R
recreation_resource_images.rec_resource_id recreation_resource_images_rec_resource_id_fkey R
recreation_status.rec_resource_id recreation_status_rec_resource_id_fkey R
recreation_structure.rec_resource_id recreation_structure_rec_resource_id_fkey R

Identification manually assigned to a Recreation Resource.
name varchar 200 √ null

Name of the Recreation Project.
description varchar 5000 √ null
closest_community varchar 200 √ null

A text description generally describing the closest community or, for more isolated sites and trails, it could be a geographic feature to a recreation site or trail. e.g. VERNON, KELOWNA, PRINCE GEORGE.
display_on_public_site bool 1 √ false
district_code varchar 4 √ null
recreation_district_code.district_code recreation_resource_district_code_fkey R

A code indicating a recreation district boundary. EG Cascades, Chilliwack, Discovery Coast. Note: There are 17 Recreation District Boundaries, most of which have different geographical boundaries than Forest District Boundaries. Because of this, Rec District Boundary Codes are different from Forest District Boundary Codes.
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_pkey Primary key Asc rec_resource_id

Relationships

Close relationships within degrees of separation