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 200 null
recreation_activity.rec_resource_id recreation_activity_rec_resource_id_fkey R
recreation_status.rec_resource_id recreation_status_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
site_location 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

Indexes

Constraint Name Type Sort Column(s)
recreation_resource_pkey Primary key Asc rec_resource_id

Relationships

Close relationships within degrees of separation