TABLES
6
VIEWS
0
COLUMNS
25
Constraints
4
Anomalies
0
Routines
0
Database Properties
Database Type: PostgreSQL - 16.4 (Debian 16.4-1.pgdg110+2)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| recreation_resource | 2 | 0 | 5 | -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_activity | 0 | 2 | 3 | -1 | Table | The types of available activities for a given project. |
| recreation_status_code | 1 | 0 | 2 | -1 | Table | |
| flyway_schema_history | 0 | 0 | 10 | -1 | Table | |
| recreation_status | 0 | 2 | 3 | -1 | Table | |
| recreation_activity_code | 1 | 0 | 2 | -1 | Table | Activity code types for recreation projects. |