flash_update_flashupdate

305 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('flash_update_flashupdate_id_seq'::regclass)
flash_update_flashactionstaken.flash_update_id flash_update_flashac_flash_update_id_b59d0112_fk_flash_updR
flash_update_flashcountrydistrict.flash_update_id flash_update_flashco_flash_update_id_d3608af1_fk_flash_updR
flash_update_flashupdate_graphics.flashupdate_id flash_update_flashup_flashupdate_id_2a3ed39e_fk_flash_updR
flash_update_flashupdate_map.flashupdate_id flash_update_flashup_flashupdate_id_1cec54ca_fk_flash_updR
flash_update_flashupdate_references.flashupdate_id flash_update_flashup_flashupdate_id_502160f7_fk_flash_updR
flash_update_flashupdateshare.flash_update_id flash_update_flashup_flash_update_id_35608868_fk_flash_updR
created_at timestamptz 35,6 null
modified_at timestamptz 35,6 null
title varchar 300 null
title_en varchar 300 √ null
title_es varchar 300 √ null
title_fr varchar 300 √ null
title_ar varchar 300 √ null
situational_overview text 2147483647 null
situational_overview_en text 2147483647 √ null
situational_overview_es text 2147483647 √ null
situational_overview_fr text 2147483647 √ null
situational_overview_ar text 2147483647 √ null
originator_name varchar 100 √ null
originator_title varchar 300 √ null
originator_email varchar 300 √ null
originator_phone varchar 50 √ null
ifrc_name varchar 100 √ null
ifrc_title varchar 300 √ null
ifrc_email varchar 300 √ null
ifrc_phone varchar 50 √ null
share_with varchar 50 √ null
created_by_id int4 10 √ null
auth_user.id flash_update_flashupdate_created_by_id_b0d145a9_fk_auth_user_idR
hazard_type_id int4 10 √ null
api_disastertype.id flash_update_flashup_hazard_type_id_3f89baab_fk_api_disasR
modified_by_id int4 10 √ null
auth_user.id flash_update_flashup_modified_by_id_3daa995b_fk_auth_userR
extracted_at timestamptz 35,6 √ null
extracted_file varchar 100 √ null
translation_module_original_language varchar 2 null
translation_module_skip_auto_translation bool 1 null

Indexes

Constraint Name Type Sort Column(s)
flash_update_flashupdate_pkey Primary key Asc id
flash_update_flashupdate_created_by_id_b0d145a9 Performance Asc created_by_id
flash_update_flashupdate_hazard_type_id_3f89baab Performance Asc hazard_type_id
flash_update_flashupdate_modified_by_id_3daa995b Performance Asc modified_by_id

Relationships

Close relationships within degrees of separation