api_emergencyoperationsdataset

295 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_emergencyoperationsdataset_id_seq'::regclass)
is_validated bool 1 null
created_at timestamptz 35,6 null
modified_at timestamptz 35,6 null
raw_file_name text 2147483647 √ null
raw_file_url text 2147483647 √ null
raw_appeal_launch_date text 2147483647 √ null
raw_appeal_number text 2147483647 √ null
raw_category_allocated text 2147483647 √ null
raw_date_of_issue text 2147483647 √ null
raw_dref_allocated text 2147483647 √ null
raw_expected_end_date text 2147483647 √ null
raw_expected_time_frame text 2147483647 √ null
raw_glide_number text 2147483647 √ null
raw_num_of_people_affected text 2147483647 √ null
raw_num_of_people_to_be_assisted text 2147483647 √ null
raw_disaster_risk_reduction_female text 2147483647 √ null
raw_disaster_risk_reduction_male text 2147483647 √ null
raw_disaster_risk_reduction_people_reached text 2147483647 √ null
raw_disaster_risk_reduction_people_targeted text 2147483647 √ null
raw_disaster_risk_reduction_requirements text 2147483647 √ null
raw_health_female text 2147483647 √ null
raw_health_male text 2147483647 √ null
raw_health_people_reached text 2147483647 √ null
raw_health_people_targeted text 2147483647 √ null
raw_health_requirements text 2147483647 √ null
raw_livelihoods_and_basic_needs_female text 2147483647 √ null
raw_livelihoods_and_basic_needs_male text 2147483647 √ null
raw_livelihoods_and_basic_needs_people_reached text 2147483647 √ null
raw_livelihoods_and_basic_needs_people_targeted text 2147483647 √ null
raw_livelihoods_and_basic_needs_requirements text 2147483647 √ null
raw_migration_female text 2147483647 √ null
raw_migration_male text 2147483647 √ null
raw_migration_people_reached text 2147483647 √ null
raw_migration_people_targeted text 2147483647 √ null
raw_migration_requirements text 2147483647 √ null
raw_protection_gender_and_inclusion_female text 2147483647 √ null
raw_protection_gender_and_inclusion_male text 2147483647 √ null
raw_protection_gender_and_inclusion_people_reached text 2147483647 √ null
raw_protection_gender_and_inclusion_people_targeted text 2147483647 √ null
raw_protection_gender_and_inclusion_requirements text 2147483647 √ null
raw_shelter_female text 2147483647 √ null
raw_shelter_male text 2147483647 √ null
raw_shelter_people_reached text 2147483647 √ null
raw_shelter_people_targeted text 2147483647 √ null
raw_shelter_requirements text 2147483647 √ null
raw_water_sanitation_and_hygiene_female text 2147483647 √ null
raw_water_sanitation_and_hygiene_male text 2147483647 √ null
raw_water_sanitation_and_hygiene_people_reached text 2147483647 √ null
raw_water_sanitation_and_hygiene_people_targeted text 2147483647 √ null
raw_water_sanitation_and_hygiene_requirements text 2147483647 √ null
raw_education_female text 2147483647 √ null
raw_education_male text 2147483647 √ null
raw_education_people_reached text 2147483647 √ null
raw_education_people_targeted text 2147483647 √ null
raw_education_requirements text 2147483647 √ null
file_name varchar 200 √ null
appeal_launch_date date 13 √ null
appeal_number varchar 20 √ null
category_allocated varchar 100 √ null
date_of_issue date 13 √ null
dref_allocated int4 10 √ null
expected_end_date date 13 √ null
expected_time_frame int4 10 √ null
glide_number varchar 18 √ null
num_of_people_affected int4 10 √ null
num_of_people_to_be_assisted int4 10 √ null
disaster_risk_reduction_female int4 10 √ null
disaster_risk_reduction_male int4 10 √ null
disaster_risk_reduction_people_reached int4 10 √ null
disaster_risk_reduction_people_targeted int4 10 √ null
disaster_risk_reduction_requirements int4 10 √ null
health_female int4 10 √ null
health_male int4 10 √ null
health_people_reached int4 10 √ null
health_people_targeted int4 10 √ null
health_requirements int4 10 √ null
livelihoods_and_basic_needs_female int4 10 √ null
livelihoods_and_basic_needs_male int4 10 √ null
livelihoods_and_basic_needs_people_reached int4 10 √ null
livelihoods_and_basic_needs_people_targeted int4 10 √ null
livelihoods_and_basic_needs_requirements int4 10 √ null
migration_female int4 10 √ null
migration_male int4 10 √ null
migration_people_reached int4 10 √ null
migration_people_targeted int4 10 √ null
migration_requirements int4 10 √ null
protection_gender_and_inclusion_female int4 10 √ null
protection_gender_and_inclusion_male int4 10 √ null
protection_gender_and_inclusion_people_reached int4 10 √ null
protection_gender_and_inclusion_people_targeted int4 10 √ null
protection_gender_and_inclusion_requirements int4 10 √ null
shelter_female int4 10 √ null
shelter_male int4 10 √ null
shelter_people_reached int4 10 √ null
shelter_people_targeted int4 10 √ null
shelter_requirements int4 10 √ null
water_sanitation_and_hygiene_female int4 10 √ null
water_sanitation_and_hygiene_male int4 10 √ null
water_sanitation_and_hygiene_people_reached int4 10 √ null
water_sanitation_and_hygiene_people_targeted int4 10 √ null
water_sanitation_and_hygiene_requirements int4 10 √ null
education_female int4 10 √ null
education_male int4 10 √ null
education_people_reached int4 10 √ null
education_people_targeted int4 10 √ null
education_requirements int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
api_emergencyoperationsdataset_pkey Primary key Asc id

Diagram producer might be missing

No diagrams were produced please see application output for any errors