TABLES
57
VIEWS
3
COLUMNS
455
Constraints
69
Anomalies
10
Routines
801
Database Properties
Database Type: PostgreSQL - 14.9 (Debian 14.9-1.pgdg110+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| space_meta | 0 | 1 | 4 | -1 | Table | |
| _mesoregiao | 0 | 0 | 5 | -1 | Table | |
| evaluationmethodconfiguration_meta | 0 | 1 | 4 | -1 | Table | |
| entity_revision_revision_data | 0 | 2 | 2 | 10 | Table | |
| event | 3 | 4 | 13 | -1 | Table | |
| evaluation_method_configuration | 1 | 2 | 6 | -1 | Table | |
| event_occurrence_cancellation | 0 | 1 | 3 | -1 | Table | |
| opportunity_meta | 0 | 1 | 4 | -1 | Table | |
| system_role | 0 | 1 | 8 | -1 | Table | |
| db_update | 10 | 0 | 2 | 149 | Table | |
| project_event | 0 | 0 | 5 | -1 | Table | |
| registration | 3 | 3 | 17 | -1 | Table | |
| job | 0 | 0 | 10 | -1 | Table | |
| subsite | 9 | 2 | 9 | -1 | Table | |
| geo_division | 0 | 0 | 6 | -1 | Table | |
| project | 3 | 4 | 14 | -1 | Table | |
| _municipios | 0 | 0 | 5 | -1 | Table | |
| event_attendance | 0 | 4 | 10 | -1 | Table | |
| registration_field_configuration | 0 | 1 | 16 | -1 | Table | |
| permission_cache_pending | 0 | 0 | 5 | -1 | Table | |
| space_relation | 0 | 2 | 6 | -1 | Table | |
| _microregiao | 0 | 0 | 5 | -1 | Table | |
| chat_message | 1 | 3 | 6 | -1 | Table | |
| agent_meta | 0 | 1 | 4 | -1 | Table | |
| pcache | 0 | 1 | 6 | -1 | Table | |
| seal_relation | 0 | 3 | 10 | -1 | Table | |
| spatial_ref_sys | 2 | 0 | 5 | 8500 | Table | |
| entity_revision | 1 | 1 | 7 | 1 | Table | |
| term | 1 | 0 | 4 | -1 | Table | |
| registration_evaluation | 0 | 2 | 8 | -1 | Table | |
| agent | 13 | 4 | 15 | 1 | Table | |
| role | 0 | 2 | 4 | 1 | Table | |
| space | 5 | 4 | 15 | -1 | Table | |
| event_occurrence | 3 | 2 | 17 | -1 | Table | |
| project_meta | 0 | 1 | 4 | -1 | Table | |
| subsite_meta | 0 | 1 | 4 | -1 | Table | |
| term_relation | 0 | 1 | 4 | -1 | Table | |
| agent_relation | 0 | 1 | 9 | -1 | Table | |
| user_app | 0 | 2 | 7 | -1 | Table | |
| seal | 2 | 3 | 12 | 1 | Table | |
| file | 1 | 2 | 12 | -1 | Table | |
| seal_meta | 0 | 1 | 4 | -1 | Table | |
| registration_meta | 0 | 1 | 4 | -1 | Table | |
| procuration | 0 | 2 | 6 | -1 | Table | |
| registration_file_configuration | 0 | 1 | 12 | -1 | Table | |
| user_meta | 0 | 1 | 4 | 2 | Table | |
| notification | 1 | 2 | 7 | -1 | Table | |
| metalist | 0 | 0 | 9 | -1 | Table | |
| request | 1 | 1 | 12 | -1 | Table | |
| usr | 13 | 1 | 8 | 1 | Table | |
| notification_meta | 0 | 1 | 4 | -1 | Table | |
| chat_thread | 1 | 0 | 9 | -1 | Table | |
| metadata | 0 | 0 | 4 | -1 | Table | |
| entity_revision_data | 1 | 0 | 4 | 10 | Table | |
| event_occurrence_recurrence | 0 | 1 | 5 | -1 | Table | |
| opportunity | 6 | 3 | 22 | -1 | Table | |
| event_meta | 0 | 1 | 4 | -1 | Table | |
| geography_columns | 0 | 1 | 7 | 0 | View | |
| geometry_columns | 0 | 1 | 7 | 0 | View | |
| evaluations | 0 | 0 | 11 | 0 | View |