api_event

6258 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_event_id_seq'::regclass)
api_appeal.event_id api_appeal_event_id_97067607_fk_api_event_idR
api_crisiscategorisationbycountry.event_id api_crisiscategorisa_event_id_a114529c_fk_api_eventR
api_event.parent_event_id api_event_parent_event_id_69348215_fk_api_event_idR
api_event_countries.event_id api_event_countries_event_id_191f576b_fk_api_event_idR
api_event_countries_for_preview.event_id api_event_countries__event_id_32a0793c_fk_api_eventR
api_event_districts.event_id api_event_districts_event_id_819faff1_fk_api_event_idR
api_event_regions.event_id api_event_regions_event_id_50fb114e_fk_api_event_idR
api_eventcontact.event_id api_eventcontact_event_id_96995e43_fk_api_event_idR
api_eventfeatureddocument.event_id api_eventfeatureddocument_event_id_b14cb0e8_fk_api_event_idR
api_eventlink.event_id api_eventlink_event_id_bf92a77e_fk_api_event_idR
api_eventseveritylevelhistory.event_id api_eventseveritylevelhistory_event_id_e8e165d5_fk_api_event_idR
api_fieldreport.event_id api_fieldreport_event_id_3c489514_fk_api_event_idR
api_keyfigure.event_id api_keyfigure_event_id_7804cc0d_fk_api_event_idR
api_situationreport.event_id api_situationreport_event_id_fbcc2910_fk_api_event_idR
api_snippet.event_id api_snippet_event_id_069dcf16_fk_api_event_idR
deployments_emergencyproject.event_id deployments_emergencyproject_event_id_10bc370f_fk_api_event_idR
deployments_eru.event_id deployments_eru_event_id_58780f12_fk_api_event_idR
deployments_fact.event_id deployments_fact_event_id_6953280a_fk_api_event_idR
deployments_heop.event_id deployments_heop_event_id_1d298c17_fk_api_event_idR
deployments_personneldeployment.event_deployed_to_id deployments_personne_event_deployed_to_id_4ca35a75_fk_api_eventR
deployments_project.event_id deployments_project_event_id_2ae511a6_fk_api_event_idR
deployments_rdrt.event_id deployments_rdrt_event_id_e40e282d_fk_api_event_idR
notifications_subscription.event_id notifications_subscription_event_id_10113d80_fk_api_event_idR
notifications_surgealert.event_id notifications_surgealert_event_id_9120f436_fk_api_event_idR
name varchar 256 null
summary text 2147483647 null
num_affected int4 10 √ null
ifrc_severity_level int4 10 null
glide varchar 18 null
disaster_start_date timestamptz 35,6 null
created_at timestamptz 35,6 null
auto_generated bool 1 null
dtype_id int4 10 √ null
api_disastertype.id api_event_dtype_id_af630553_fk_api_disastertype_idR
auto_generated_source varchar 50 √ null
is_featured bool 1 null
updated_at timestamptz 35,6 null
hide_attached_field_reports bool 1 null
num_dead int4 10 √ null
num_displaced int4 10 √ null
num_injured int4 10 √ null
num_missing int4 10 √ null
previous_update timestamptz 35,6 √ null
is_featured_region bool 1 null
slug varchar 50 √ null
parent_event_id int4 10 √ null
api_event.id api_event_parent_event_id_69348215_fk_api_event_idR
tab_one_title varchar 50 null
tab_three_title varchar 50 √ null
tab_two_title varchar 50 √ null
name_ar varchar 256 √ null
name_en varchar 256 √ null
name_es varchar 256 √ null
name_fr varchar 256 √ null
hide_field_report_map bool 1 null
visibility int4 10 null
emergency_response_contact_email varchar 255 √ null
image varchar 100 √ null
summary_ar text 2147483647 √ null
summary_en text 2147483647 √ null
summary_es text 2147483647 √ null
summary_fr text 2147483647 √ null
translation_module_original_language varchar 2 null
translation_module_skip_auto_translation bool 1 null
ifrc_severity_level_update_date timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
api_event_pkey Primary key Asc id
api_event_dtype_id_af630553 Performance Asc dtype_id
api_event_parent_event_id_69348215 Performance Asc parent_event_id
api_event_slug_ca5f12b7_like Performance Asc slug
api_event_slug_key Must be unique Asc slug

Relationships

Close relationships within degrees of separation