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_access_history.rec_resource_id Implied Constraint R
recreation_activity.rec_resource_id recreation_activity_rec_resource_id_fkey R
recreation_agreement_holder.rec_resource_id recreation_agreement_holder_rec_resource_id_fkey R
recreation_defined_campsite.rec_resource_id recreation_defined_campsite_rec_resource_id_fkey R
recreation_driving_direction.rec_resource_id recreation_driving_direction_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_history.rec_resource_id Implied Constraint R
recreation_resource_images.rec_resource_id recreation_resource_images_rec_resource_id_fkey R
recreation_resource_search_view.rec_resource_id Implied Constraint R
recreation_resource_type_view.rec_resource_id Implied Constraint R
recreation_site_description.rec_resource_id recreation_site_description_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
recreation_structure_history.rec_resource_id Implied Constraint R

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

Name of the Recreation Project.
description text 2147483647 √ null

Field notes related to a recreation site. e.g. A managed, 11 unit site with 2WD access, gravel beach launch and a small float. Watch for hazards on the lake. This column is for internal use and is not a description for public use.
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.
maintenance_standard_code varchar 1 √ null
recreation_maintenance_standard_code.maintenance_standard_code recreation_resource_maintenance_standard_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_resource_pkey Primary key Asc rec_resource_id

Relationships

Close relationships within degrees of separation