recreation_defined_campsite

-1 rows


Description

A defined campsite is a camping area within a project designated by the Recreation officer. This may contain recreation structures.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rec_resource_id varchar 10 null
recreation_resource.rec_resource_id recreation_defined_campsite_rec_resource_id_fkey R

File identification assigned to Provincial Forest Use files. Assigned file number. Usually the Licence, Tenure or Private Mark number.
campsite_number int4 10 null

The number assigned to a defined campsite by Recreation staff.
estimated_repair_cost numeric 10,2 √ null

Identifies the estimated remedial repair cost for a campsite.
recreation_remed_repair_code varchar 2 √ null
recreation_remed_repair_code.recreation_remed_repair_code recreation_defined_campsite_recreation_remed_repair_code_fkey R

Indicates the type of remedial repair applicable to the defined campsite.
repair_complete_date date 13 √ null

Identifies the completion date for the campsite repair.
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_defined_campsite_rec_resource_id_campsite_number_key Must be unique Asc/Asc rec_resource_id + campsite_number

Relationships

Close relationships within degrees of separation