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_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 | 4 | -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 | 17 | 2 | 12 | -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_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_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_status_code | 3 | 0 | 4 | -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 | 17 | 0 | View | Provides a list of recreation resources and related data for use in the public site search page |
| recreation_resource_type_view | 0 | 1 | 3 | 0 | View | Provides a list of resource type codes and descriptions for recreation resources to be used as the source of truth for getting the recreation resource type code for a recreation resource for display on the public site. This was needed to mitigate bugs from junk data in the recreation map feature table as well as the request to show some recreation reserves as sites on the public site. |
| 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. |