api_fieldreport

16710 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_fieldreport_id_seq'::regclass)
api_actionstaken.field_report_id api_actionstaken_field_report_id_9ad6f351_fk_api_fieldreport_idR
api_erpguid.field_report_id api_erpguid_field_report_id_565d8924_fk_api_fieldreport_idR
api_fieldreport_countries.fieldreport_id api_fieldreport_coun_fieldreport_id_18b58939_fk_api_fieldR
api_fieldreport_districts.fieldreport_id api_fieldreport_dist_fieldreport_id_6ab10a1b_fk_api_fieldR
api_fieldreport_external_partners.fieldreport_id api_fieldreport_exte_fieldreport_id_e3d41bb2_fk_api_fieldR
api_fieldreport_regions.fieldreport_id api_fieldreport_regi_fieldreport_id_57a78f70_fk_api_fieldR
api_fieldreport_supported_activities.fieldreport_id api_fieldreport_supp_fieldreport_id_9971a515_fk_api_fieldR
api_fieldreportcontact.field_report_id api_fieldreportconta_field_report_id_f7a3506b_fk_api_fieldR
api_source.field_report_id api_source_field_report_id_6791d70d_fk_api_fieldreport_idR
dref_dref.field_report_id dref_dref_field_report_id_8be7005f_fk_api_fieldreport_idR
rid varchar 100 √ null
summary text 2147483647 null
description text 2147483647 null
status int4 10 null
request_assistance bool 1 √ null
num_injured int4 10 √ null
num_dead int4 10 √ null
num_missing int4 10 √ null
num_affected int4 10 √ null
num_displaced int4 10 √ null
num_assisted int4 10 √ null
num_localstaff int4 10 √ null
num_volunteers int4 10 √ null
num_expats_delegates int4 10 √ null
gov_num_injured int4 10 √ null
gov_num_dead int4 10 √ null
gov_num_missing int4 10 √ null
gov_num_affected int4 10 √ null
gov_num_displaced int4 10 √ null
gov_num_assisted int4 10 √ null
actions_others text 2147483647 √ null
visibility int4 10 null
bulletin int4 10 √ null
dref int4 10 √ null
dref_amount int4 10 √ null
appeal int4 10 √ null
appeal_amount int4 10 √ null
rdrt int4 10 null
num_rdrt int4 10 √ null
fact int4 10 √ null
num_fact int4 10 √ null
emergency_response_unit int4 10 √ null
num_emergency_response_unit int4 10 √ null
eru_base_camp int4 10 null
eru_base_camp_units int4 10 √ null
eru_basic_health_care int4 10 null
eru_basic_health_care_units int4 10 √ null
eru_it_telecom int4 10 null
eru_it_telecom_units int4 10 √ null
eru_logistics int4 10 null
eru_logistics_units int4 10 √ null
eru_deployment_hospital int4 10 null
eru_deployment_hospital_units int4 10 √ null
eru_referral_hospital int4 10 null
eru_referral_hospital_units int4 10 √ null
eru_relief int4 10 null
eru_relief_units int4 10 √ null
eru_water_sanitation_15 int4 10 null
eru_water_sanitation_15_units int4 10 √ null
eru_water_sanitation_40 int4 10 null
eru_water_sanitation_40_units int4 10 √ null
eru_water_sanitation_20 int4 10 null
eru_water_sanitation_20_units int4 10 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
dtype_id int4 10 null
api_disastertype.id api_fieldreport_dtype_id_7a02da73_fk_api_disastertype_idR
event_id int4 10 √ null
api_event.id api_fieldreport_event_id_3c489514_fk_api_event_idR
user_id int4 10 √ null
auth_user.id api_fieldreport_user_id_26b289ae_fk_auth_user_idR
report_date timestamptz 35,6 √ null
previous_update timestamptz 35,6 √ null
other_num_affected int4 10 √ null
other_num_assisted int4 10 √ null
other_num_dead int4 10 √ null
other_num_displaced int4 10 √ null
other_num_injured int4 10 √ null
other_num_missing int4 10 √ null
start_date timestamptz 35,6 √ null
affected_pop_centres varchar 512 √ null
gov_affected_pop_centres varchar 512 √ null
gov_num_highest_risk int4 10 √ null
gov_num_potentially_affected int4 10 √ null
num_highest_risk int4 10 √ null
num_potentially_affected int4 10 √ null
other_affected_pop_centres varchar 512 √ null
other_num_highest_risk int4 10 √ null
other_num_potentially_affected int4 10 √ null
forecast_based_action int4 10 √ null
forecast_based_action_amount int4 10 √ null
imminent_dref int4 10 √ null
imminent_dref_amount int4 10 √ null
other_sources text 2147483647 null
ns_request_assistance bool 1 √ null
health_min_num_assisted int4 10 √ null
who_num_assisted int4 10 √ null
sit_fields_date timestamptz 35,6 √ null
is_covid_report bool 1 null
epi_cases int4 10 √ null
epi_confirmed_cases int4 10 √ null
epi_num_dead int4 10 √ null
epi_probable_cases int4 10 √ null
epi_suspected_cases int4 10 √ null
epi_figures_source int4 10 √ null
actions_others_ar text 2147483647 √ null
actions_others_en text 2147483647 √ null
actions_others_es text 2147483647 √ null
actions_others_fr text 2147483647 √ null
description_ar text 2147483647 √ null
description_en text 2147483647 √ null
description_es text 2147483647 √ null
description_fr text 2147483647 √ null
other_sources_ar text 2147483647 √ null
other_sources_en text 2147483647 √ null
other_sources_es text 2147483647 √ null
other_sources_fr text 2147483647 √ null
summary_ar text 2147483647 √ null
summary_en text 2147483647 √ null
summary_es text 2147483647 √ null
summary_fr text 2147483647 √ null
epi_cases_since_last_fr int4 10 √ null
epi_deaths_since_last_fr int4 10 √ null
epi_notes_since_last_fr text 2147483647 √ null
notes_health text 2147483647 √ null
notes_ns text 2147483647 √ null
notes_socioeco text 2147483647 √ null
recent_affected int4 10 null
translation_module_original_language varchar 2 null
translation_module_skip_auto_translation bool 1 null
fr_num int4 10 √ null
title varchar 256 null
title_ar varchar 256 √ null
title_en varchar 256 √ null
title_es varchar 256 √ null
title_fr varchar 256 √ null

Indexes

Constraint Name Type Sort Column(s)
api_fieldreport_pkey Primary key Asc id
api_fieldreport_dtype_id_7a02da73 Performance Asc dtype_id
api_fieldreport_event_id_3c489514 Performance Asc event_id
api_fieldreport_user_id_26b289ae Performance Asc user_id

Relationships

Close relationships within degrees of separation