Database Properties
Database Type: PostgreSQL - 16.4 (Debian 16.4-1.pgdg110+2)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| recreation_map_feature_geom_history | 0 | 1 | 13 | -1 | Table | |
| recreation_structure_history | 0 | 2 | 7 | -1 | Table | |
| recreation_access_code_history | 0 | 1 | 5 | -1 | Table | |
| recreation_resource_doc_code_history | 0 | 1 | 7 | -1 | Table | |
| recreation_control_access_code | 2 | 0 | 10 | -1 | Table | Describes the Controlled Access Code for a rec resource. E.g. “Gated”, “Restricted Use”. |
| recreation_agreement_holder | 0 | 1 | 10 | -1 | Table | Identifies the Agreement Holder responsible for maintaining a project for a given time frame. |
| flyway_schema_history | 0 | 0 | 10 | -1 | Table | |
| recreation_activity_code_history | 0 | 1 | 4 | -1 | Table | |
| recreation_fee_code | 3 | 0 | 4 | -1 | Table | Recreation fee codes for classification of fees within a project |
| recreation_district_code | 5 | 0 | 5 | -1 | Table | Recreation district codes for classification of areas within a project |
| recreation_site_description_history | 0 | 0 | 7 | -1 | Table | |
| recreation_map_feature_history | 0 | 1 | 15 | -1 | Table | |
| recreation_resource_type_code_history | 0 | 1 | 4 | -1 | Table | |
| recreation_access_code | 5 | 0 | 5 | -1 | Table | Codes describing types of access to Recreation Resources |
| recreation_site_point | 0 | 0 | 8 | -1 | Table | Stores the location of a Recreation Site as a point geometry. The data is used to provide the public a map location of the Recreation Site. |
| recreation_status | 3 | 2 | 8 | -1 | Table | |
| recreation_structure | 0 | 2 | 7 | -1 | Table | Information relating to a recreation site improvement in a recreational tenure. All improvements are human-made. |
| recreation_fee_code_history | 0 | 1 | 4 | -1 | Table | |
| recreation_remed_repair_code | 3 | 0 | 4 | -1 | Table | Codes describing types of remedial repairs for recreation structures. |
| recreation_site_description | 0 | 1 | 7 | -1 | Table | Description of a recreation resource for public display |
| recreation_driving_direction | 0 | 1 | 7 | -1 | Table | Driving directions to a recreation resource for public display |
| recreation_resource_images | 1 | 1 | 8 | -1 | Table | |
| recreation_resource_doc_code | 3 | 0 | 7 | -1 | Table | |
| recreation_status_code_history | 0 | 1 | 4 | -1 | Table | |
| recreation_fee | 0 | 2 | 17 | -1 | Table | |
| recreation_structure_code_history | 0 | 1 | 4 | -1 | Table | |
| recreation_sub_access_code_history | 0 | 0 | 4 | -1 | Table | |
| recreation_resource_type_code | 2 | 0 | 4 | -1 | Table | Codes describing types of Recreation Resources |
| recreation_activity_history | 0 | 2 | 7 | -1 | Table | |
| recreation_defined_campsite | 0 | 2 | 10 | -1 | Table | A defined campsite is a camping area within a project designated by the Recreation officer. This may contain recreation structures. |
| recreation_site_point_history | 0 | 0 | 8 | -1 | Table | |
| recreation_resource | 20 | 3 | 14 | -1 | Table | 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. |
| recreation_establishment_order_docs | 1 | 1 | 10 | -1 | Table | |
| recreation_resource_docs | 3 | 2 | 11 | -1 | Table | |
| recreation_access | 5 | 3 | 9 | -1 | Table | Recreation Resource Access types |
| recreation_district_code_history | 0 | 1 | 4 | -1 | Table | |
| recreation_access_history | 0 | 3 | 9 | -1 | Table | |
| recreation_resource_history | 0 | 3 | 12 | -1 | Table | |
| recreation_maintenance_standard_code | 3 | 0 | 4 | -1 | Table | Codes describing the maintenance standards for recreation projects. |
| recreation_defined_campsite_history | 0 | 1 | 10 | -1 | Table | |
| recreation_resource_image_variants_history | 0 | 1 | 11 | -1 | Table | |
| recreation_resource_docs_history | 0 | 2 | 11 | -1 | Table | |
| recreation_maintenance_standard_code_history | 0 | 1 | 4 | -1 | Table | |
| recreation_resource_image_variants | 0 | 1 | 11 | -1 | Table | |
| recreation_activity_code | 3 | 0 | 4 | -1 | Table | Activity code types for recreation projects. |
| recreation_map_feature | 1 | 3 | 15 | -1 | Table | Captures both current and historical attributes for Recreation Map Features. |
| recreation_control_access_code_history | 0 | 1 | 10 | -1 | Table | |
| recreation_activity | 0 | 2 | 7 | -1 | Table | The types of available activities for a given project. |
| recreation_agreement_holder_history | 0 | 0 | 10 | -1 | Table | |
| recreation_fee_history | 0 | 2 | 17 | -1 | Table | |
| recreation_remed_repair_code_history | 0 | 1 | 4 | -1 | Table | |
| recreation_driving_direction_history | 0 | 0 | 7 | -1 | Table | |
| recreation_map_feature_geom | 0 | 2 | 13 | -1 | Table | Captures amendments to spatial geometry for recreation applications received via the electronic submission process. |
| recreation_structure_code | 3 | 0 | 4 | -1 | Table | Codes describing the type of structure (human-made improvement) within a recreation project |
| recreation_resource_images_history | 0 | 1 | 8 | -1 | Table | |
| recreation_resource_reservation_info_history | 0 | 0 | 11 | -1 | Table | |
| recreation_resource_reservation_info | 0 | 1 | 11 | -1 | Table | Identifies the reservation information on the specific recreation resource. |
| recreation_status_code | 3 | 0 | 4 | -1 | Table | |
| recreation_establishment_order_docs_history | 0 | 1 | 10 | -1 | Table | |
| recreation_sub_access_code | 1 | 0 | 4 | -1 | Table | Codes describing the Recreation Sub Access types within a project. |
| recreation_status_history | 0 | 2 | 8 | -1 | Table | |
| recreation_resource_search_view | 0 | 3 | 19 | 0 | View | Provides a list of recreation resources and related data for use in the public site search page |
| recreation_resource_type_count_view | 0 | 0 | 3 | 0 | View | Provides a list of resource type codes and counts of their associated recreation resources for use in the search filter menu. |
| recreation_resource_access_count_view | 0 | 1 | 3 | 0 | View | Provides a list of access codes and counts of their associated recreation resources for use in the search filter menu. |
| recreation_resource_district_count_view | 0 | 1 | 3 | 0 | View | provides a list of district codes and counts of their associated recreation resources for use in the search filter menu. |
| recreation_resource_type_view_admin | 0 | 1 | 3 | 0 | View | Provides resource type codes and descriptions for admin interface. Shows actual resource types without conversion (including RR). Gets the most recent recreation_resource_type from recreation_map_feature table. |
| recreation_resource_type_view_public | 0 | 1 | 3 | 0 | View | Provides resource type codes and descriptions for public site. Converts RR (Recreation Reserve) to SIT (Site) for public display. Gets the most recent recreation_resource_type from recreation_map_feature table. |