Tables


SchemaSpy Analysis of GO

Generated on K nov. 11 15:03 CET 2025

XML Representation
Insertion Order Deletion Order
TABLES 316
VIEWS 3
COLUMNS 3696
Constraints 487
Anomalies 4
Routines 593

Database Properties

Database Type: PostgreSQL - 15.8

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
api_actionstaken 1 1 10 16561 Table
deployments_emergencyproject_districts 0 2 3 787 Table
databank_acapsseasonalcalender 0 1 9 1536 Table
api_usercountry 0 2 3 2 Table
dref_drefoperationalupdate_district 0 2 3 1051 Table
per_opslearning_organization_validated 0 2 3 12771 Table
api_fieldreportcontact 0 1 7 40331 Table
flash_update_donors 2 0 6 9 Table
dref_dreffinalreport 10 10 202 192 Table
flash_update_flashcountrydistrict_district 0 2 3 401 Table
registrations_domainwhitelist 0 0 4 226 Table
local_units_healthdata_professional_training_facilities 0 2 3 99 Table
dref_proposedactionactivities 1 1 3 82 Table
local_units_professionaltrainingfacility 1 0 3 3 Table
dref_dref_source_information 0 2 3 308 Table
deployments_molnixtag_groups 0 2 3 961 Table
api_admincontact 2 0 5 43 Table
eap_action 0 1 3 0 Table
dref_dreffile 22 1 11 3222 Table
per_perassessment_area_responses 0 2 3 548 Table
eap_eap 3 5 34 0 Table
deployments_rdrtperson 0 2 3 2 Table
django_session 0 0 3 1 Table
per_overview 6 4 37 141 Table
per_opslearning_sector 0 2 3 9183 Table
api_countrysnippet 0 1 12 43 Table
local_units_primaryhcc 1 0 3 3 Table
api_eventlink 0 1 15 80 Table
per_opslearning_sector_validated 0 2 3 10102 Table
databank_socialevent 0 1 4 0 Table
django_celery_beat_crontabschedule 1 0 7 0 Table
dref_dreffinalreport_photos 0 2 3 105 Table
api_countrykeyfigure 0 2 2 10 Table
local_units_localunit 1 7 35 9335 Table
per_formcomponent_question_responses 0 2 3 0 Table
dref_dreffinalreport_source_information 0 2 3 170 Table
django_celery_beat_intervalschedule 1 0 3 0 Table
api_maincontact 0 0 10 5 Table
deployments_regionalproject 1 0 10 0 Table
api_fieldreport_regions 0 2 3 16463 Table
deployments_emergencyprojectactivityactionsupply 0 1 4 0 Table
deployments_personnel_molnix_tags 0 2 3 18742 Table
api_event_countries 0 2 3 6194 Table
dref_dref_national_society_actions 0 2 3 1890 Table
api_region 18 0 15 5 Table
dref_dreffinalreport_risk_security 0 2 3 602 Table
per_formanswer 3 0 8 8 Table
per_formprioritizationcomponent 1 1 10 215 Table
deployments_annualsplit 0 1 12 0 Table
country_plan_countryplan 2 3 14 191 Table
per_perworkplan_additional_action_responses 0 2 3 30 Table
flash_update_flashupdateshare 2 1 3 51 Table
us_gaz 0 0 6 1074 Table
flash_update_donorgroup 2 0 2 4 Table
deployments_emergencyproject_admin2 0 2 3 0 Table
per_formcomponentquestionandanswer 2 2 10 23200 Table
per_workplan 0 2 14 0 Table
deployments_personneldeployment 1 4 21 511 Table
dref_identifiedneed 3 0 13 2812 Table
per_arearesponse_component_response 0 2 3 5822 Table
eap_eapreference 0 1 4 0 Table
api_authlog 0 0 4 3 Table
notifications_surgealert 2 2 26 1696 Table
api_countrysupportingpartner 0 1 7 0 Table
flash_update_donors_groups 0 2 3 9 Table
per_formcomponentresponse 2 2 30 5822 Table
api_regionsnippet 0 1 12 7 Table
guardian_userobjectpermission 0 3 5 0 Table
per_formcomponent 9 1 39 51 Table
dref_drefoperationalupdate_users 0 2 3 1294 Table
dref_plannedinterventionindicators 1 0 10 573552 Table
local_units_healthdata_specialized_medical_beyond_primary_level 0 2 3 3901 Table
oauth2_provider_refreshtoken 1 3 9 95 Table
api_event_countries_for_preview 0 2 3 98 Table
per_opslearning_per_component 0 2 3 11760 Table
eap_earlyaction_indicators 0 2 3 0 Table
dref_dreffinalreport_users 0 2 3 1174 Table
api_event 23 2 40 6258 Table
per_overview_orientation_documents 0 2 3 9 Table
registrations_pending 0 1 14 1826 Table
dref_drefoperationalupdate_source_information 0 2 3 195 Table
flash_update_flashupdate 6 3 29 118 Table
flash_update_flashgraphicmap 3 1 5 167 Table
api_generaldocument 1 0 11 112 Table
databank_fdrsindicator 1 0 3 14 Table
databank_keydocument 0 2 6 0 Table
registrations_userexternaltoken 0 1 7 43 Table
api_emergencyoperationsfr 0 0 85 241 Table
api_nsdinitiatives 1 1 19 169 Table
deployments_emergencyprojectactivity_points 0 2 3 23 Table
api_erpguid 0 1 4 1036 Table
dref_drefoperationalupdate_needs_identified 0 2 3 866 Table
deployments_eruowner 2 1 4 18 Table
per_opslearningcacheresponse_used_ops_learning 0 2 3 2155 Table
flash_update_flashupdateshare_donors 0 2 3 48 Table
per_opslearningcomponentcacheresponse 1 2 10 96 Table
per_perfile 1 1 5 14 Table
api_regionemergencysnippet 0 1 15 1 Table
registrations_recovery 0 1 4 559 Table
per_formarea 3 0 9 5 Table
api_countrycapacitystrengthening 0 1 8 789 Table
local_units_delegationoffice 0 2 22 141 Table
dref_dref_needs_identified 0 2 3 1369 Table
lang_translationcache 0 0 11 1246 Table
per_opslearning_organization 0 2 3 12728 Table
databank_countrykeyclimate 0 1 8 2700 Table
api_event_regions 0 2 3 5977 Table
deployments_sector 2 0 5 10 Table
databank_countryoverview 9 1 108 286 Table
api_gdacsevent 1 1 35 822 Table
auth_user_groups 0 2 3 9823 Table
dref_proposedaction 3 0 4 61 Table
local_units_facilitytype 1 0 3 9 Table
api_sourcetype 1 0 2 14 Table
api_snippet 0 1 13 657 Table
flash_update_flashupdate_graphics 0 2 3 37 Table
api_situationreport 0 2 9 4519 Table
deployments_project_project_admin2 0 2 3 0 Table
flash_update_flashcountrydistrict 1 2 4 142 Table
dref_plannedintervention 4 0 38 203134 Table
dref_drefoperationalupdate_risk_security 0 2 3 722 Table
api_fieldreport_countries 0 2 3 16598 Table
api_disastertype 15 0 13 24 Table
deployments_partnersocietydeployment_district_deployed_to 0 2 3 0 Table
notifications_notificationguid 0 0 5 0 Table
us_rules 0 0 3 4369 Table
django_admin_log 0 2 8 2 Table
api_country 63 2 72 286 Table
api_cronjob 0 0 8 361 Table
deployments_sectortag 4 0 11 14 Table
api_source 0 2 10 22840 Table
api_adminkeyfigure 2 0 11 18 Table
dref_dref_risk_security 0 2 3 1054 Table
per_perworkplan_prioritized_action_responses 0 2 3 103 Table
django_migrations 0 0 4 775 Table
api_fieldreport_external_partners 0 2 3 342 Table
deployments_erureadiness 1 1 3 4 Table
auth_user_user_permissions 0 2 3 17078 Table
deployments_eru 1 4 14 47 Table
auth_user 61 0 11 11687 Table
per_organizationtypes 2 0 4 2 Table
per_opslearningcomponentcacheresponse_used_ops_learning 0 2 3 626 Table
deployments_molnixtag 3 0 7 661 Table
dref_dref_users 0 2 3 1910 Table
api_export 0 1 11 1644 Table
per_perassessment 1 2 6 140 Table
dref_dref_district 0 2 3 1470 Table
flash_update_flashemailsubscriptions 0 1 3 2 Table
deployments_emergencyprojectactivitylocation 1 0 4 72 Table
flash_update_flashactionstaken 1 1 5 472 Table
per_formquestion_answers 0 2 3 1065 Table
local_units_generalmedicalservice 1 0 3 6 Table
api_countrylink 0 2 2 13 Table
per_opslearning 9 1 20 12670 Table
databank_keyclimateevent 0 1 7 0 Table
local_units_localunitlevel 1 0 3 4 Table
api_appealdocument 0 3 15 14004 Table
dref_plannedintervention_indicators 0 2 3 573552 Table
api_countrydirectory 0 1 5 1595 Table
databank_externalsource 0 1 4 0 Table
deployments_partnersocietydeployment 1 4 4 0 Table
flash_update_flashactionstaken_actions 0 2 3 284 Table
api_regioncontact 0 2 2 16 Table
eap_eap_early_actions 0 2 3 0 Table
api_adminlink 2 0 3 48 Table
dref_nationalsocietyaction 3 0 9 3003 Table
deployments_heop 0 4 10 2 Table
dref_dref 11 15 273 398 Table
per_formprioritization 1 1 3 34 Table
us_lex 0 0 6 2940 Table
deployments_emergencyproject 3 6 18 170 Table
per_opslearning_per_component_validated 0 2 3 14726 Table
deployments_project 5 9 42 2592 Table
per_nicedocument 0 1 7 1 Table
deployments_factperson 0 2 3 3 Table
databank_seasonalcalender 0 1 7 0 Table
per_opslearningpromptresponsecache 0 0 5 101 Table
api_emergencyoperationsdataset 0 0 107 295 Table
tastypie_apiaccess 0 0 5 0 Table
api_fieldreport_districts 0 2 3 18383 Table
django_celery_beat_periodictasks 0 0 2 0 Table
auth_group 4 0 2 1834 Table
api_regionpreparednesssnippet 0 1 15 1 Table
local_units_hospitaltype 1 0 3 3 Table
databank_keydocumentgroup 1 0 2 0 Table
databank_fdrsincome 0 2 5 5520 Table
dref_sourceinformation 3 0 4 600 Table
lang_string 0 0 6 13118 Table
dref_drefoperationalupdate 9 10 230 230 Table
api_profile 0 2 11 9930 Table
api_externalpartner 1 0 8 6 Table
api_countryorganizationalcapacity 0 1 6 33 Table
api_emergencyoperationspeoplereached 0 0 77 395 Table
databank_fdrsannualincome 0 1 4 1206 Table
django_celery_beat_periodictask 0 4 23 0 Table
oauth2_provider_grant 0 2 13 0 Table
api_userregion 0 2 3 15 Table
local_units_healthdata_general_medical_services 0 2 3 3067 Table
flash_update_flashupdateshare_donor_groups 0 2 3 13 Table
per_perworkplan 2 1 3 28 Table
api_emergencyoperationsea 0 0 91 246 Table
per_assessmenttype 2 0 8 4 Table
api_districtgeoms 0 1 2 3754 Table
api_regionlink 0 2 3 35 Table
reversion_version 0 2 8 3 Table
dref_dref_images 0 2 3 459 Table
dref_dreffinalreport_planned_interventions 0 2 3 1066 Table
api_appeal 5 4 28 4104 Table
api_eventcontact 0 1 7 645 Table
deployments_project_project_districts 0 2 3 22118 Table
dref_dreffinalreport_district 0 2 3 839 Table
oauth2_provider_application 4 1 15 1 Table
eap_earlyactionindicator 1 0 3 0 Table
local_units_bloodservice 1 0 3 7 Table
api_countrygeoms 0 1 2 247 Table
api_supportedactivity 1 0 8 26 Table
deployments_molnixtaggroup 1 0 6 73 Table
deployments_projectimport_projects_created 0 2 3 763 Table
api_nsdinitiatives_categories 0 2 3 243 Table
eap_eappartner 0 1 4 0 Table
api_reversiondifferencelog 0 0 9 1346004 Table
per_formquestion 3 2 16 355 Table
api_appealhistory 0 4 18 49089 Table
api_event_districts 0 2 3 6256 Table
deployments_personnel 1 5 12 3671 Table
per_formquestiongroup 1 1 14 5 Table
api_action 1 0 17 80 Table
deployments_project_secondary_sectors 0 2 3 2601 Table
local_units_localunitbulkupload 1 3 12 120 Table
country_plan_membershipcoordination 0 2 5 1080 Table
guardian_groupobjectpermission 0 3 5 0 Table
per_form 1 3 7 465 Table
deployments_emergencyprojectactivityaction 2 1 7 49 Table
per_formcomponentresponse_question_responses 0 2 3 23200 Table
auth_group_permissions 0 2 3 22100 Table
deployments_emergencyprojectactivitysector 2 0 3 11 Table
deployments_rdrt 1 4 7 1 Table
oauth2_provider_idtoken 1 2 8 95 Table
per_nsphase 0 1 4 7 Table
per_perworkplancomponent 1 2 13 139 Table
api_appealfilter 0 0 4 1 Table
api_keyfigure 0 1 11 425 Table
eap_earlyaction 3 0 7 0 Table
oauth2_provider_accesstoken 1 4 11 95 Table
deployments_deployedperson 4 0 11 3676 Table
dref_dreffinalreport_national_society_actions 0 2 3 1144 Table
api_situationreporttype 1 0 9 7 Table
notifications_subscription 0 5 9 7 Table
per_perdocumentupload 0 3 6 37 Table
per_opslearningcacheresponse 3 0 45 52 Table
authtoken_token 0 1 3 6390 Table
per_formdata 0 3 11 33015 Table
local_units_healthdata 5 7 38 5314 Table
flash_update_flashreferences 1 1 6 179 Table
api_gdacsevent_countries 0 2 3 842 Table
api_countrykeydocument 0 1 9 4230 Table
per_arearesponse 2 1 4 587 Table
local_units_healthdata_blood_services 0 2 3 1640 Table
per_opslearningsectorcacheresponse_used_ops_learning 0 2 3 408 Table
deployments_projectimport 1 1 6 14 Table
tastypie_apikey 0 1 4 189 Table
deployments_erureadinesstype 1 0 6 7 Table
per_opslearningsectorcacheresponse 1 2 10 95 Table
deployments_partnersocietyactivities 1 0 8 2 Table
django_content_type 5 0 3 229 Table
dref_drefoperationalupdate_planned_interventions 0 2 3 1224 Table
deployments_erureadiness_eru_types 0 2 3 7 Table
local_units_delegationofficetype 1 0 3 7 Table
per_percomponentrating 1 0 9 6 Table
api_admin2 3 1 12 23453 Table
api_countrycontact 0 2 2 27 Table
notifications_surgealert_molnix_tags 0 2 3 13001 Table
dref_dref_planned_interventions 0 2 3 1914 Table
api_regionprofilesnippet 0 1 15 1 Table
django_celery_beat_solarschedule 1 0 4 0 Table
dref_proposedaction_activities 0 2 3 77 Table
deployments_fact 1 4 7 1 Table
spatial_ref_sys 2 0 5 8500 Table
api_actionstaken_actions 0 2 3 57213 Table
dref_dreffinalreport_needs_identified 0 2 3 757 Table
api_countryoffieldreporttoreview 0 1 1 3 Table
api_appealdocumenttype 1 0 3 55 Table
local_units_affiliation 1 0 3 6 Table
local_units_localunitchangerequest 0 3 11 210 Table
api_geccode 0 1 3 39 Table
dref_dref_proposed_action 0 2 3 61 Table
dref_drefoperationalupdate_photos 0 2 3 180 Table
api_fieldreport 10 3 124 16776 Table
country_plan_strategicpriority 0 1 5 870 Table
country_plan_dataimport 0 2 7 6 Table
api_admin2geoms 0 1 2 23453 Table
api_nsdinitiativescategory 1 0 8 16 Table
dref_drefoperationalupdate_images 0 2 3 303 Table
api_regionkeyfigure 0 2 2 8 Table
api_fieldreport_supported_activities 0 2 3 648 Table
local_units_specializedmedicalservice 1 0 3 25 Table
per_formprioritization_prioritized_action_responses 0 2 3 210 Table
api_eventseveritylevelhistory 0 2 6 2 Table
dref_drefoperationalupdate_national_society_actions 0 2 3 1213 Table
dref_dreffinalreport_proposed_action 0 2 3 14 Table
flash_update_flashupdate_map 0 2 3 55 Table
dref_risksecurity 3 0 14 2239 Table
local_units_localunittype 3 0 4 6 Table
api_countryicrcpresence 0 1 6 94 Table
deployments_emergencyprojectactivity 1 3 62 707 Table
flash_update_flashupdate_references 0 2 3 108 Table
flash_update_flashaction 1 0 8 15 Table
api_eventfeatureddocument 0 1 6 107 Table
django_celery_beat_clockedschedule 1 0 3 0 Table
auth_permission 4 1 4 2727 Table
local_units_externallymanagedlocalunit 0 4 8 59 Table
api_district 12 1 15 3762 Table
per_customperworkplancomponent 1 1 12 43 Table
local_units_functionality 1 0 3 4 Table
reversion_revision 1 1 4 3 Table
dref_dreffinalreport_images 0 2 3 305 Table
geography_columns 0 1 7 0 View
auth_usr 0 0 10 0 View
geometry_columns 0 1 7 0 View