TABLES
60
VIEWS
3
COLUMNS
594
Constraints
73
Anomalies
2
Routines
0
Database Properties
Database Type: PostgreSQL - 15.4
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| harvest_source | 2 | 0 | 12 | 2 | Table | |
| tracking_summary | 0 | 0 | 7 | -1 | Table | |
| user_following_group | 0 | 2 | 3 | -1 | Table | |
| alembic_version | 0 | 0 | 1 | 1 | Table | |
| user_following_dataset | 0 | 2 | 3 | -1 | Table | |
| api_token | 0 | 1 | 6 | -1 | Table | |
| group_revision | 0 | 1 | 16 | -1 | Table | |
| package | 12 | 0 | 18 | 3 | Table | |
| dcpr_error_report | 1 | 3 | 12 | -1 | Table | |
| user_following_user | 0 | 2 | 3 | -1 | Table | |
| alembic_dalrrd_emc_dcpr_version | 0 | 0 | 1 | 1 | Table | |
| harvest_job | 2 | 1 | 7 | 7 | Table | |
| dcpr_geospatial_request | 1 | 3 | 21 | -1 | Table | |
| package_relationship | 1 | 2 | 6 | -1 | Table | |
| harvest_log | 0 | 0 | 4 | 131504 | Table | |
| saved_searches | 0 | 1 | 5 | -1 | Table | |
| system_info | 1 | 0 | 4 | -1 | Table | |
| resource_revision | 0 | 1 | 27 | -1 | Table | |
| rating | 0 | 2 | 6 | -1 | Table | |
| package_tag_revision | 0 | 2 | 10 | -1 | Table | |
| harvest_object | 2 | 3 | 16 | -1 | Table | |
| system_info_revision | 0 | 2 | 10 | -1 | Table | |
| package_relationship_revision | 0 | 4 | 12 | -1 | Table | |
| ckanext_pages | 0 | 0 | 14 | -1 | Table | |
| error_report_notification | 0 | 3 | 4 | -1 | Table | |
| revision | 9 | 0 | 6 | -1 | Table | |
| harvest_gather_error | 0 | 1 | 4 | 3 | Table | |
| term_translation | 0 | 0 | 3 | -1 | Table | |
| spatial_ref_sys | 2 | 0 | 5 | 8500 | Table | |
| task_status | 0 | 0 | 9 | 1 | Table | |
| member_revision | 0 | 1 | 12 | -1 | Table | |
| package_extra | 0 | 1 | 5 | 35 | Table | |
| harvest_object_extra | 0 | 1 | 4 | -1 | Table | |
| group_extra | 0 | 1 | 5 | -1 | Table | |
| package_extra_revision | 0 | 1 | 11 | -1 | Table | |
| group_extra_revision | 0 | 2 | 11 | -1 | Table | |
| member | 0 | 1 | 6 | 10 | Table | |
| group | 9 | 0 | 10 | 2 | Table | |
| resource_view | 0 | 1 | 7 | 7 | Table | |
| activity_detail | 0 | 1 | 6 | -1 | Table | |
| dashboard | 0 | 1 | 3 | 5 | Table | |
| package_revision | 0 | 1 | 24 | -1 | Table | |
| error_report | 1 | 3 | 12 | -1 | Table | |
| resource | 1 | 0 | 22 | 7 | Table | |
| dcpr_request_notification | 0 | 3 | 4 | -1 | Table | |
| dcpr_request | 2 | 4 | 32 | -1 | Table | |
| tracking_raw | 0 | 0 | 4 | 1997 | Table | |
| user_extra_fields | 0 | 1 | 4 | 3 | Table | |
| user | 25 | 0 | 14 | 6 | Table | |
| package_extent | 0 | 0 | 2 | 6 | Table | |
| dcpr_geospatial_request_notification | 0 | 3 | 4 | -1 | Table | |
| harvest_object_error | 0 | 1 | 6 | -1 | Table | |
| dcpr_request_dataset | 0 | 1 | 16 | -1 | Table | |
| dcpr_error_report_notification | 0 | 3 | 4 | -1 | Table | |
| package_tag | 0 | 2 | 4 | -1 | Table | |
| vocabulary | 1 | 0 | 2 | -1 | Table | |
| package_member | 0 | 2 | 4 | -1 | Table | |
| reporting_tool | 0 | 1 | 5 | 1388 | Table | |
| tag | 2 | 1 | 3 | -1 | Table | |
| activity | 1 | 0 | 7 | 46 | Table | |
| saeoss_pycsw_view | 0 | 0 | 72 | 0 | View | |
| geography_columns | 0 | 1 | 7 | 0 | View | |
| geometry_columns | 0 | 1 | 7 | 0 | View |