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 | 0 | 13 | -1 | Table | |
| recreation_structure_history | 0 | 1 | 7 | -1 | Table | |
| recreation_access_code_history | 0 | 1 | 5 | -1 | Table | |
| recreation_resource | 9 | 1 | 11 | -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_doc_code_history | 0 | 1 | 7 | -1 | Table | |
| recreation_campsite | 0 | 1 | 7 | -1 | Table | Stores the number of campsites associated with each recreation resource. |
| recreation_resource_docs | 3 | 2 | 11 | -1 | Table | |
| flyway_schema_history | 0 | 0 | 10 | -1 | Table | |
| recreation_access | 0 | 3 | 9 | -1 | Table | Recreation Resource Access types |
| 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_history | 0 | 1 | 4 | -1 | Table | |
| recreation_access_history | 0 | 1 | 9 | -1 | Table | |
| recreation_resource_history | 0 | 1 | 11 | -1 | Table | |
| recreation_district_code | 5 | 0 | 4 | -1 | Table | Recreation district codes for classification of areas within a project |
| 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_resource_image_variants_history | 0 | 1 | 11 | -1 | Table | |
| recreation_resource_docs_history | 0 | 3 | 11 | -1 | Table | |
| recreation_site_point | 4 | 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_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 | 2 | 15 | -1 | Table | Captures both current and historical attributes for Recreation Map Features. |
| recreation_campsite_history | 0 | 0 | 7 | -1 | Table | |
| recreation_activity | 0 | 2 | 7 | -1 | Table | The types of available activities for a given project. |
| recreation_fee_history | 0 | 2 | 18 | -1 | Table | |
| recreation_resource_images | 1 | 1 | 8 | -1 | Table | |
| recreation_resource_doc_code | 3 | 0 | 7 | -1 | Table | |
| recreation_map_feature_geom | 0 | 1 | 13 | -1 | Table | Captures amendments to spatial geometry for recreation applications received via the electronic submission process. |
| recreation_status_code_history | 0 | 1 | 4 | -1 | Table | |
| recreation_fee | 0 | 2 | 18 | -1 | Table | |
| recreation_structure_code_history | 0 | 1 | 4 | -1 | Table | |
| 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 | 2 | 8 | -1 | Table | |
| recreation_sub_access_code_history | 0 | 0 | 4 | -1 | Table | |
| recreation_resource_type_code | 3 | 0 | 4 | -1 | Table | Codes describing types of Recreation Resources |
| recreation_status_code | 3 | 0 | 4 | -1 | Table | |
| recreation_activity_history | 0 | 2 | 7 | -1 | Table | |
| recreation_sub_access_code | 1 | 0 | 4 | -1 | Table | Codes describing the Recreation Sub Access types within a project. |
| recreation_site_point_history | 0 | 1 | 8 | -1 | Table | |
| recreation_status_history | 0 | 2 | 8 | -1 | Table | |
| recreation_resource_search_view | 0 | 2 | 16 | 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 | 1 | 4 | 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 | 4 | 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 | 4 | 0 | View | Provides a list of district codes and counts of their associated recreation resources for use in the search filter menu. |