Database Properties
Database Type: PostgreSQL - 14.4
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| spatial_ref_sys | 2 | 0 | 5 | 8500 | Table | |
| system_owners | 4 | 0 | 7 | 0 | Table | Entity responsible for definition, publication and upkeep of areas system standard. |
| licenses | 1 | 0 | 2 | 0 | Table | Options for the license_terms in the systems table: Public domain, Copyleft- Attribution only, Copyleft- ShareAlike, Copyleft- No derivatives, Copyleft- Non commercial, Copyright, Not explicit/unknown |
| systems | 1 | 4 | 18 | 0 | Table | Area or multiple areas defined, published and upkept by an Owner as a single set. Areas within a single system will be non-overlapping except for hierarchies, e.g. FAO 34.1.11 is a subset of FAO 34.1. |
| areas | 0 | 2 | 10 | 0 | Table | Individual polygons defined within a system. All hierarchies should be captured, e.g. both FAO 34.1 and FAO 34.1.11 are areas. |
| system_types | 1 | 1 | 3 | 0 | Table | System type as defined by the system owner. Multiple systems may share the same system type. For example, the New Zealand Hake Quota Management Area is the system type Quota Management Area. |
| categories | 0 | 0 | 2 | 0 | Table | Options for use in the category field of the systems table: management area, statistical area, assessment area, biological stock area, species distribution area |
| geography_columns | 0 | 1 | 7 | 0 | View | |
| geometry_columns | 0 | 1 | 7 | 0 | View |