Tables


SchemaSpy Analysis of GO

Generated on H nov. 11 13:14 CET 2024

XML Representation
Insertion Order Deletion Order
TABLES 298
VIEWS 3
COLUMNS 3433
Constraints 449
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 16533 Table
deployments_emergencyproject_districts 0 2 3 786 Table
databank_acapsseasonalcalender 0 1 9 1526 Table
api_usercountry 0 2 3 2 Table
dref_drefoperationalupdate_district 0 2 3 908 Table
per_opslearning_organization_validated 0 2 3 13682 Table
api_fieldreportcontact 0 1 7 40388 Table
flash_update_donors 2 0 6 19 Table
dref_dreffinalreport 9 10 172 166 Table
flash_update_flashcountrydistrict_district 0 2 3 833 Table
registrations_domainwhitelist 0 0 4 274 Table
local_units_healthdata_professional_training_facilities 0 2 3 76 Table
local_units_professionaltrainingfacility 1 0 3 3 Table
dref_dref_source_information 0 2 3 285 Table
deployments_molnixtag_groups 0 2 3 763 Table
api_admincontact 2 0 5 44 Table
eap_action 0 1 3 0 Table
dref_dreffile 20 1 11 7907 Table
per_perassessment_area_responses 0 2 3 560 Table
eap_eap 3 5 34 0 Table
deployments_rdrtperson 0 2 3 2 Table
django_session 0 0 3 3 Table
per_overview 6 4 36 112 Table
per_opslearning_sector 0 2 3 10027 Table
api_countrysnippet 0 1 12 61 Table
local_units_primaryhcc 1 0 3 3 Table
api_eventlink 0 1 15 83 Table
per_opslearning_sector_validated 0 2 3 10989 Table
databank_socialevent 0 1 4 0 Table
django_celery_beat_crontabschedule 1 0 7 0 Table
dref_dreffinalreport_photos 0 2 3 110 Table
api_countrykeyfigure 0 2 2 10 Table
local_units_localunit 0 6 29 7583 Table
per_formcomponent_question_responses 0 2 3 0 Table
dref_dreffinalreport_source_information 0 2 3 157 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 16396 Table
deployments_emergencyprojectactivityactionsupply 0 1 4 0 Table
deployments_personnel_molnix_tags 0 2 3 18087 Table
api_event_countries 0 2 3 6146 Table
dref_dref_national_society_actions 0 2 3 1788 Table
api_region 18 0 15 5 Table
dref_dreffinalreport_risk_security 0 2 3 608 Table
per_formanswer 3 0 8 8 Table
per_formprioritizationcomponent 1 1 10 811 Table
deployments_annualsplit 0 1 12 0 Table
country_plan_countryplan 2 3 12 191 Table
per_perworkplan_additional_action_responses 0 2 3 1 Table
flash_update_flashupdateshare 2 1 3 62 Table
us_gaz 0 0 6 1074 Table
flash_update_donorgroup 2 0 2 5 Table
deployments_emergencyproject_admin2 0 2 3 0 Table
per_formcomponentquestionandanswer 2 2 10 96899 Table
per_workplan 0 2 14 0 Table
deployments_personneldeployment 1 4 21 496 Table
dref_identifiedneed 3 0 13 170149 Table
per_arearesponse_component_response 0 2 3 21821 Table
eap_eapreference 0 1 4 0 Table
api_authlog 0 0 4 11 Table
notifications_surgealert 2 2 26 1456 Table
api_countrysupportingpartner 0 1 7 0 Table
flash_update_donors_groups 0 2 3 19 Table
per_formcomponentresponse 2 2 25 21821 Table
api_regionsnippet 0 1 12 7 Table
guardian_userobjectpermission 0 3 5 0 Table
per_formcomponent 9 1 34 51 Table
dref_drefoperationalupdate_users 0 2 3 1396 Table
dref_plannedinterventionindicators 1 0 10 605492 Table
local_units_healthdata_specialized_medical_beyond_primary_level 0 2 3 3808 Table
api_event_countries_for_preview 0 2 3 98 Table
per_opslearning_per_component 0 2 3 12573 Table
eap_earlyaction_indicators 0 2 3 0 Table
dref_dreffinalreport_users 0 2 3 1279 Table
api_event 22 2 39 6207 Table
per_overview_orientation_documents 0 2 3 4 Table
registrations_pending 0 1 14 2150 Table
dref_drefoperationalupdate_source_information 0 2 3 162 Table
flash_update_flashupdate 6 3 29 305 Table
flash_update_flashgraphicmap 3 1 5 551 Table
api_generaldocument 1 0 11 145 Table
databank_keydocument 0 2 6 0 Table
databank_fdrsindicator 1 0 3 14 Table
registrations_userexternaltoken 0 1 6 115 Table
api_emergencyoperationsfr 0 0 85 241 Table
api_nsdinitiatives 0 1 8 79 Table
deployments_emergencyprojectactivity_points 0 2 3 23 Table
api_erpguid 0 1 4 754 Table
dref_drefoperationalupdate_needs_identified 0 2 3 795 Table
deployments_eruowner 1 1 4 19 Table
per_opslearningcacheresponse_used_ops_learning 0 2 3 0 Table
flash_update_flashupdateshare_donors 0 2 3 54 Table
per_opslearningcomponentcacheresponse 1 2 10 0 Table
per_perfile 1 1 5 7 Table
api_regionemergencysnippet 0 1 15 0 Table
registrations_recovery 0 1 4 671 Table
per_formarea 3 0 9 5 Table
api_countrycapacitystrengthening 0 1 8 713 Table
local_units_delegationoffice 0 2 22 71 Table
dref_dref_needs_identified 0 2 3 1277 Table
per_opslearning_organization 0 2 3 13638 Table
databank_countrykeyclimate 0 1 8 2700 Table
api_event_regions 0 2 3 5926 Table
deployments_sector 1 0 5 10 Table
databank_countryoverview 9 1 108 285 Table
api_gdacsevent 1 1 35 284 Table
auth_user_groups 0 2 3 5157 Table
local_units_facilitytype 1 0 3 9 Table
api_sourcetype 1 0 2 14 Table
api_snippet 0 1 13 652 Table
flash_update_flashupdate_graphics 0 2 3 134 Table
api_situationreport 0 2 9 4572 Table
deployments_project_project_admin2 0 2 3 0 Table
flash_update_flashcountrydistrict 1 2 4 345 Table
dref_drefoperationalupdate_risk_security 0 2 3 710 Table
dref_plannedintervention 4 0 38 231170 Table
api_fieldreport_countries 0 2 3 16531 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 59 Table
api_country 62 2 72 285 Table
api_cronjob 0 0 8 717 Table
deployments_sectortag 4 0 11 14 Table
api_source 0 2 10 22840 Table
api_adminkeyfigure 2 0 11 17 Table
dref_dref_risk_security 0 2 3 1042 Table
per_perworkplan_prioritized_action_responses 0 2 3 27 Table
django_migrations 0 0 4 729 Table
api_fieldreport_external_partners 0 2 3 342 Table
deployments_erureadiness 0 1 6 0 Table
auth_user_user_permissions 0 2 3 18120 Table
deployments_eru 1 4 14 48 Table
auth_user 50 0 11 11854 Table
per_organizationtypes 2 0 4 2 Table
per_opslearningcomponentcacheresponse_used_ops_learning 0 2 3 0 Table
deployments_molnixtag 3 0 7 576 Table
dref_dref_users 0 2 3 2048 Table
api_export 0 1 11 5553 Table
per_perassessment 1 2 6 112 Table
dref_dref_district 0 2 3 1242 Table
flash_update_flashemailsubscriptions 0 1 3 2 Table
deployments_emergencyprojectactivitylocation 1 0 4 72 Table
flash_update_flashactionstaken 1 1 5 1220 Table
per_formquestion_answers 0 2 3 1065 Table
local_units_generalmedicalservice 1 0 3 6 Table
api_countrylink 0 2 2 14 Table
per_opslearning 9 1 20 13580 Table
databank_keyclimateevent 0 1 7 0 Table
local_units_localunitlevel 1 0 3 4 Table
api_appealdocument 0 3 15 12355 Table
dref_plannedintervention_indicators 0 2 3 605492 Table
api_countrydirectory 0 1 5 1628 Table
databank_externalsource 0 1 4 0 Table
deployments_partnersocietydeployment 1 4 4 0 Table
flash_update_flashactionstaken_actions 0 2 3 769 Table
api_regioncontact 0 2 2 17 Table
eap_eap_early_actions 0 2 3 0 Table
api_adminlink 2 0 3 49 Table
dref_nationalsocietyaction 3 0 9 202399 Table
deployments_heop 0 4 10 2 Table
dref_dref 10 13 224 315 Table
per_formprioritization 1 1 3 106 Table
us_lex 0 0 6 2940 Table
deployments_emergencyproject 3 6 18 169 Table
per_opslearning_per_component_validated 0 2 3 16332 Table
deployments_project 5 9 42 2592 Table
per_nicedocument 0 1 7 0 Table
deployments_factperson 0 2 3 3 Table
databank_seasonalcalender 0 1 7 0 Table
per_opslearningpromptresponsecache 0 0 5 0 Table
api_emergencyoperationsdataset 0 0 107 295 Table
tastypie_apiaccess 0 0 5 0 Table
api_fieldreport_districts 0 2 3 18436 Table
django_celery_beat_periodictasks 0 0 2 0 Table
auth_group 4 0 2 608 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 5393 Table
dref_sourceinformation 3 0 4 27676 Table
lang_string 0 0 6 36798 Table
dref_drefoperationalupdate 9 10 211 182 Table
api_profile 0 2 11 11850 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 1152 Table
django_celery_beat_periodictask 0 4 23 0 Table
api_userregion 0 2 3 16 Table
local_units_healthdata_general_medical_services 0 2 3 3017 Table
flash_update_flashupdateshare_donor_groups 0 2 3 11 Table
per_perworkplan 2 1 3 101 Table
api_emergencyoperationsea 0 0 91 246 Table
per_assessmenttype 2 0 8 4 Table
api_districtgeoms 0 1 2 3531 Table
api_regionlink 0 2 3 35 Table
reversion_version 0 2 8 278 Table
dref_dref_images 0 2 3 452 Table
dref_dreffinalreport_planned_interventions 0 2 3 1079 Table
api_appeal 5 4 28 3929 Table
api_eventcontact 0 1 7 652 Table
deployments_project_project_districts 0 2 3 22130 Table
dref_dreffinalreport_district 0 2 3 755 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 47 Table
deployments_projectimport_projects_created 0 2 3 763 Table
eap_eappartner 0 1 4 0 Table
api_reversiondifferencelog 0 0 9 1887717 Table
per_formquestion 3 2 16 355 Table
api_appealhistory 0 4 18 39111 Table
api_event_districts 0 2 3 6227 Table
deployments_personnel 1 5 12 3604 Table
per_formquestiongroup 1 1 14 5 Table
api_action 1 0 17 80 Table
deployments_project_secondary_sectors 0 2 3 2602 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 96899 Table
auth_group_permissions 0 2 3 20685 Table
deployments_emergencyprojectactivitysector 2 0 3 11 Table
deployments_rdrt 1 4 7 1 Table
per_nsphase 0 1 4 7 Table
per_perworkplancomponent 1 2 13 383 Table
api_appealfilter 0 0 4 1 Table
api_keyfigure 0 1 11 428 Table
eap_earlyaction 3 0 7 0 Table
deployments_deployedperson 4 0 11 3609 Table
dref_dreffinalreport_national_society_actions 0 2 3 1154 Table
api_situationreporttype 1 0 9 7 Table
notifications_subscription 0 5 9 20495 Table
per_perdocumentupload 0 3 6 0 Table
per_opslearningcacheresponse 3 0 45 0 Table
authtoken_token 0 1 3 7650 Table
per_formdata 0 3 11 33015 Table
local_units_healthdata 5 7 38 5607 Table
flash_update_flashreferences 1 1 6 813 Table
api_gdacsevent_countries 0 2 3 415 Table
api_countrykeydocument 0 1 9 3540 Table
per_arearesponse 2 1 4 2269 Table
tmpad 0 0 15 3 Table
local_units_healthdata_blood_services 0 2 3 1776 Table
per_opslearningsectorcacheresponse_used_ops_learning 0 2 3 0 Table
deployments_projectimport 1 1 6 13 Table
tastypie_apikey 0 1 4 189 Table
per_opslearningsectorcacheresponse 1 2 10 0 Table
deployments_partnersocietyactivities 1 0 8 2 Table
django_content_type 5 0 3 215 Table
dref_drefoperationalupdate_planned_interventions 0 2 3 1140 Table
local_units_delegationofficetype 1 0 3 7 Table
per_percomponentrating 1 0 9 6 Table
api_admin2 3 1 12 1400 Table
api_countrycontact 0 2 2 27 Table
notifications_surgealert_molnix_tags 0 2 3 11095 Table
dref_dref_planned_interventions 0 2 3 1835 Table
api_regionprofilesnippet 0 1 15 1 Table
django_celery_beat_solarschedule 1 0 4 0 Table
deployments_fact 1 4 7 1 Table
spatial_ref_sys 2 0 5 8500 Table
api_actionstaken_actions 0 2 3 57175 Table
dref_dreffinalreport_needs_identified 0 2 3 753 Table
api_countryoffieldreporttoreview 0 1 1 8 Table
api_appealdocumenttype 1 0 3 55 Table
local_units_affiliation 1 0 3 6 Table
api_geccode 0 1 3 39 Table
dref_drefoperationalupdate_photos 0 2 3 202 Table
api_fieldreport 10 3 118 16709 Table
country_plan_strategicpriority 0 1 5 870 Table
country_plan_dataimport 0 2 7 4 Table
api_admin2geoms 0 1 2 1400 Table
dref_drefoperationalupdate_images 0 2 3 302 Table
api_regionkeyfigure 0 2 2 7 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 740 Table
dref_drefoperationalupdate_national_society_actions 0 2 3 1182 Table
flash_update_flashupdate_map 0 2 3 172 Table
dref_risksecurity 3 0 14 126399 Table
local_units_localunittype 1 0 4 6 Table
api_countryicrcpresence 0 1 6 183 Table
deployments_emergencyprojectactivity 1 3 62 707 Table
flash_update_flashupdate_references 0 2 3 454 Table
flash_update_flashaction 1 0 8 15 Table
api_eventfeatureddocument 0 1 6 111 Table
django_celery_beat_clockedschedule 1 0 3 0 Table
auth_permission 4 1 4 1447 Table
api_district 12 1 10 3759 Table
per_customperworkplancomponent 1 1 12 6 Table
local_units_functionality 1 0 3 4 Table
reversion_revision 1 1 4 68 Table
dref_dreffinalreport_images 0 2 3 307 Table
geography_columns 0 1 7 0 View
auth_usr 0 0 10 0 View
geometry_columns 0 1 7 0 View