dref_dref

315 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('dref_dref_id_seq'::regclass)
dref_dref_district.dref_id dref_dref_district_dref_id_ab9c5d7e_fk_dref_dref_idR
dref_dref_images.dref_id dref_dref_images_dref_id_dd2a314f_fk_dref_dref_idR
dref_dref_national_society_actions.dref_id dref_dref_national_s_dref_id_a420a43c_fk_dref_drefR
dref_dref_needs_identified.dref_id dref_dref_needs_identified_dref_id_4641c72b_fk_dref_dref_idR
dref_dref_planned_interventions.dref_id dref_dref_planned_in_dref_id_f90e9fce_fk_dref_drefR
dref_dref_proposed_action.dref_id dref_dref_proposed_action_dref_id_4fa3e633_fk_dref_dref_idR
dref_dref_risk_security.dref_id dref_dref_risk_security_dref_id_9018b932_fk_dref_dref_idR
dref_dref_source_information.dref_id dref_dref_source_information_dref_id_67c7c51b_fk_dref_dref_idR
dref_dref_users.dref_id dref_dref_users_dref_id_b14c7935_fk_dref_dref_idR
dref_dreffinalreport.dref_id dref_dreffinalreport_dref_id_3400e1e8_fk_dref_dref_idR
dref_drefoperationalupdate.dref_id dref_drefoperationalupdate_dref_id_4e3f8c7e_fk_dref_dref_idR
created_at timestamptz 35,6 null
modified_at timestamptz 35,6 √ null
title varchar 255 null
title_en varchar 255 √ null
title_es varchar 255 √ null
title_fr varchar 255 √ null
title_ar varchar 255 √ null
type_of_onset int4 10 √ null
disaster_category int4 10 √ null
status int4 10 √ null
num_assisted int4 10 √ null
num_affected int4 10 √ null
amount_requested int4 10 √ null
emergency_appeal_planned bool 1 √ null
event_date date 13 √ null
event_text text 2147483647 √ null
ns_respond_date date 13 √ null
did_it_affect_same_area bool 1 √ null
did_it_affect_same_population bool 1 √ null
affect_same_population_text text 2147483647 √ null
did_ns_respond bool 1 √ null
did_ns_request_fund bool 1 √ null
ns_request_text text 2147483647 √ null
dref_recurrent_text text 2147483647 √ null
lessons_learned text 2147483647 √ null
event_description text 2147483647 √ null
anticipatory_actions text 2147483647 √ null
event_scope text 2147483647 √ null
government_requested_assistance bool 1 √ null
government_requested_assistance_date date 13 √ null
national_authorities text 2147483647 √ null
ifrc text 2147483647 √ null
icrc text 2147483647 √ null
partner_national_society text 2147483647 √ null
un_or_other_actor text 2147483647 √ null
major_coordination_mechanism text 2147483647 √ null
identified_gaps text 2147483647 √ null
people_assisted text 2147483647 √ null
selection_criteria text 2147483647 √ null
entity_affected text 2147483647 √ null
community_involved text 2147483647 √ null
women int4 10 √ null
men int4 10 √ null
girls int4 10 √ null
boys int4 10 √ null
disability_people_per float8 17,17 √ null
people_per_urban float8 17,17 √ null
people_per_local float8 17,17 √ null
people_targeted_with_early_actions int4 10 √ null
displaced_people int4 10 √ null
operation_objective text 2147483647 √ null
response_strategy text 2147483647 √ null
ns_request_date date 13 √ null
submission_to_geneva date 13 √ null
date_of_approval date 13 √ null
end_date date 13 √ null
publishing_date date 13 √ null
operation_timeframe int4 10 √ null
appeal_code varchar 255 √ null
glide_code varchar 255 √ null
ifrc_appeal_manager_name varchar 255 √ null
ifrc_appeal_manager_email varchar 255 √ null
ifrc_appeal_manager_title varchar 255 √ null
ifrc_appeal_manager_phone_number varchar 100 √ null
ifrc_project_manager_name varchar 255 √ null
ifrc_project_manager_email varchar 255 √ null
ifrc_project_manager_title varchar 255 √ null
ifrc_project_manager_phone_number varchar 100 √ null
national_society_contact_name varchar 255 √ null
national_society_contact_email varchar 255 √ null
national_society_contact_title varchar 255 √ null
national_society_contact_phone_number varchar 100 √ null
media_contact_name varchar 255 √ null
media_contact_email varchar 255 √ null
media_contact_title varchar 255 √ null
media_contact_phone_number varchar 100 √ null
ifrc_emergency_name varchar 255 √ null
ifrc_emergency_email varchar 255 √ null
ifrc_emergency_title varchar 255 √ null
ifrc_emergency_phone_number varchar 100 √ null
originator_name varchar 255 √ null
originator_email varchar 255 √ null
originator_title varchar 255 √ null
originator_phone_number varchar 100 √ null
human_resource text 2147483647 √ null
surge_personnel_deployed text 2147483647 √ null
logistic_capacity_of_ns text 2147483647 √ null
safety_concerns text 2147483647 √ null
pmer text 2147483647 √ null
communication text 2147483647 √ null
budget_file_preview varchar 100 √ null
budget_file_id int4 10 √ null
dref_dreffile.id dref_dref_budget_file_id_3f1fe5b7_fk_dref_dreffile_idR
cover_image_id int4 10 √ null
dref_dreffile.id dref_dref_cover_image_id_1bb89e28_fk_dref_dreffile_idR
created_by_id int4 10 √ null
auth_user.id dref_dref_created_by_id_83dc6168_fk_auth_user_idR
disaster_type_id int4 10 √ null
api_disastertype.id dref_dref_disaster_type_id_ae36f0c8_fk_api_disastertype_idR
event_map_id int4 10 √ null
dref_dreffile.id dref_dref_event_map_id_6ae73808_fk_dref_dreffile_idR
field_report_id int4 10 √ null
api_fieldreport.id dref_dref_field_report_id_8be7005f_fk_api_fieldreport_idR
modified_by_id int4 10 √ null
auth_user.id dref_dref_modified_by_id_f9e55707_fk_auth_user_idR
national_society_id int4 10 null
api_country.id dref_dref_national_society_id_4cd1766d_fk_api_country_idR
total_targeted_population int4 10 √ null
is_published bool 1 null
is_final_report_created bool 1 null
assessment_report_id int4 10 √ null
dref_dreffile.id dref_dref_assessment_report_id_dcea7432_fk_dref_dreffile_idR
country_id int4 10 √ null
api_country.id dref_dref_country_id_39892d1a_fk_api_country_idR
is_surge_personnel_deployed bool 1 √ null
is_there_major_coordination_mechanism bool 1 √ null
did_national_society bool 1 √ null
supporting_document_id int4 10 √ null
dref_dreffile.id dref_dref_supporting_document_id_9a35260a_fk_dref_dreffile_idR
risk_security_concern text 2147483647 √ null
title_prefix varchar 255 √ null
people_in_need int4 10 √ null
is_man_made_event bool 1 √ null
type_of_dref int4 10 √ null
regional_focal_point_email varchar 255 √ null
regional_focal_point_name varchar 255 √ null
regional_focal_point_phone_number varchar 100 √ null
regional_focal_point_title varchar 255 √ null
translation_module_original_language varchar 2 null
translation_module_skip_auto_translation bool 1 null
anticipatory_actions_ar text 2147483647 √ null
anticipatory_actions_en text 2147483647 √ null
anticipatory_actions_es text 2147483647 √ null
anticipatory_actions_fr text 2147483647 √ null
communication_ar text 2147483647 √ null
communication_en text 2147483647 √ null
communication_es text 2147483647 √ null
communication_fr text 2147483647 √ null
dref_recurrent_text_ar text 2147483647 √ null
dref_recurrent_text_en text 2147483647 √ null
dref_recurrent_text_es text 2147483647 √ null
dref_recurrent_text_fr text 2147483647 √ null
event_description_ar text 2147483647 √ null
event_description_en text 2147483647 √ null
event_description_es text 2147483647 √ null
event_description_fr text 2147483647 √ null
event_scope_ar text 2147483647 √ null
event_scope_en text 2147483647 √ null
event_scope_es text 2147483647 √ null
event_scope_fr text 2147483647 √ null
event_text_ar text 2147483647 √ null
event_text_en text 2147483647 √ null
event_text_es text 2147483647 √ null
event_text_fr text 2147483647 √ null
human_resource_ar text 2147483647 √ null
human_resource_en text 2147483647 √ null
human_resource_es text 2147483647 √ null
human_resource_fr text 2147483647 √ null
icrc_ar text 2147483647 √ null
icrc_en text 2147483647 √ null
icrc_es text 2147483647 √ null
icrc_fr text 2147483647 √ null
identified_gaps_ar text 2147483647 √ null
identified_gaps_en text 2147483647 √ null
identified_gaps_es text 2147483647 √ null
identified_gaps_fr text 2147483647 √ null
ifrc_ar text 2147483647 √ null
ifrc_en text 2147483647 √ null
ifrc_es text 2147483647 √ null
ifrc_fr text 2147483647 √ null
lessons_learned_ar text 2147483647 √ null
lessons_learned_en text 2147483647 √ null
lessons_learned_es text 2147483647 √ null
lessons_learned_fr text 2147483647 √ null
logistic_capacity_of_ns_ar text 2147483647 √ null
logistic_capacity_of_ns_en text 2147483647 √ null
logistic_capacity_of_ns_es text 2147483647 √ null
logistic_capacity_of_ns_fr text 2147483647 √ null
major_coordination_mechanism_ar text 2147483647 √ null
major_coordination_mechanism_en text 2147483647 √ null
major_coordination_mechanism_es text 2147483647 √ null
major_coordination_mechanism_fr text 2147483647 √ null
national_authorities_ar text 2147483647 √ null
national_authorities_en text 2147483647 √ null
national_authorities_es text 2147483647 √ null
national_authorities_fr text 2147483647 √ null
ns_request_text_ar text 2147483647 √ null
ns_request_text_en text 2147483647 √ null
ns_request_text_es text 2147483647 √ null
ns_request_text_fr text 2147483647 √ null
operation_objective_ar text 2147483647 √ null
operation_objective_en text 2147483647 √ null
operation_objective_es text 2147483647 √ null
operation_objective_fr text 2147483647 √ null
partner_national_society_ar text 2147483647 √ null
partner_national_society_en text 2147483647 √ null
partner_national_society_es text 2147483647 √ null
partner_national_society_fr text 2147483647 √ null
people_assisted_ar text 2147483647 √ null
people_assisted_en text 2147483647 √ null
people_assisted_es text 2147483647 √ null
people_assisted_fr text 2147483647 √ null
pmer_ar text 2147483647 √ null
pmer_en text 2147483647 √ null
pmer_es text 2147483647 √ null
pmer_fr text 2147483647 √ null
response_strategy_ar text 2147483647 √ null
response_strategy_en text 2147483647 √ null
response_strategy_es text 2147483647 √ null
response_strategy_fr text 2147483647 √ null
risk_security_concern_ar text 2147483647 √ null
risk_security_concern_en text 2147483647 √ null
risk_security_concern_es text 2147483647 √ null
risk_security_concern_fr text 2147483647 √ null
selection_criteria_ar text 2147483647 √ null
selection_criteria_en text 2147483647 √ null
selection_criteria_es text 2147483647 √ null
selection_criteria_fr text 2147483647 √ null
surge_personnel_deployed_ar text 2147483647 √ null
surge_personnel_deployed_en text 2147483647 √ null
surge_personnel_deployed_es text 2147483647 √ null
surge_personnel_deployed_fr text 2147483647 √ null
title_prefix_ar varchar 255 √ null
title_prefix_en varchar 255 √ null
title_prefix_es varchar 255 √ null
title_prefix_fr varchar 255 √ null
un_or_other_actor_ar text 2147483647 √ null
un_or_other_actor_en text 2147483647 √ null
un_or_other_actor_es text 2147483647 √ null
un_or_other_actor_fr text 2147483647 √ null
is_active bool 1 √ null
disaster_category_analysis_id int4 10 √ null
dref_dreffile.id dref_dref_disaster_category_an_b4518c58_fk_dref_drefR
has_child_safeguarding_risk_analysis_assessment bool 1 √ null
targeting_strategy_support_file_id int4 10 √ null
dref_dreffile.id dref_dref_targeting_strategy_s_3fc2ba27_fk_dref_drefR
addressed_humanitarian_impacts text 2147483647 √ null
contingency_plans_supporting_document_id int4 10 √ null
dref_dreffile.id dref_dref_contingency_plans_su_9976406f_fk_dref_drefR
hazard_date_and_location text 2147483647 √ null
hazard_vulnerabilities_and_risks text 2147483647 √ null
indirect_cost int4 10 √ null
scenario_analysis_supporting_document_id int4 10 √ null
dref_dreffile.id dref_dref_scenario_analysis_su_24471d94_fk_dref_drefR
sub_total int4 10 √ null
surge_deployment_cost int4 10 √ null
total int4 10 √ null
child_safeguarding_risk_level text 2147483647 √ null
child_safeguarding_risk_level_ar text 2147483647 √ null
child_safeguarding_risk_level_en text 2147483647 √ null
child_safeguarding_risk_level_es text 2147483647 √ null
child_safeguarding_risk_level_fr text 2147483647 √ null
complete_child_safeguarding_risk bool 1 √ null
estimated_number_of_affected_female int4 10 √ null
estimated_number_of_affected_male int4 10 √ null
has_anti_fraud_corruption_policy bool 1 √ null
has_anti_sexual_harassment_policy bool 1 √ null
has_child_protection_policy bool 1 √ null
has_sexual_abuse_policy bool 1 √ null
has_whistleblower_protection_policy bool 1 √ null
is_volunteer_team_diverse text 2147483647 √ null
is_volunteer_team_diverse_ar text 2147483647 √ null
is_volunteer_team_diverse_en text 2147483647 √ null
is_volunteer_team_diverse_es text 2147483647 √ null
is_volunteer_team_diverse_fr text 2147483647 √ null
national_society_hotline_phone_number varchar 100 √ null
national_society_integrity_contact_email varchar 255 √ null
national_society_integrity_contact_name varchar 255 √ null
national_society_integrity_contact_phone_number varchar 100 √ null
national_society_integrity_contact_title varchar 255 √ null
estimated_number_of_affected_boys_under_18 int4 10 √ null
estimated_number_of_affected_girls_under_18 int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
dref_dref_pkey Primary key Asc id
dref_dref_assessment_report_id_dcea7432 Performance Asc assessment_report_id
dref_dref_budget_file_id_3f1fe5b7 Performance Asc budget_file_id
dref_dref_contingency_plans_supporting_document_id_9976406f Performance Asc contingency_plans_supporting_document_id
dref_dref_country_id_39892d1a Performance Asc country_id
dref_dref_cover_image_id_1bb89e28 Performance Asc cover_image_id
dref_dref_created_by_id_83dc6168 Performance Asc created_by_id
dref_dref_disaster_category_analysis_id_b4518c58 Performance Asc disaster_category_analysis_id
dref_dref_disaster_type_id_ae36f0c8 Performance Asc disaster_type_id
dref_dref_event_map_id_6ae73808 Performance Asc event_map_id
dref_dref_field_report_id_8be7005f Performance Asc field_report_id
dref_dref_modified_by_id_f9e55707 Performance Asc modified_by_id
dref_dref_national_society_id_4cd1766d Performance Asc national_society_id
dref_dref_scenario_analysis_supporting_document_id_24471d94 Performance Asc scenario_analysis_supporting_document_id
dref_dref_suporting_document_id_7aee0d1d Performance Asc supporting_document_id
dref_dref_targeting_strategy_support_file_id_3fc2ba27 Performance Asc targeting_strategy_support_file_id

Check Constraints

Constraint Name Constraint
dref_dref_indirect_cost_check ((indirect_cost >= 0))
dref_dref_total_check ((total >= 0))
dref_dref_sub_total_check ((sub_total >= 0))
dref_dref_surge_deployment_cost_check ((surge_deployment_cost >= 0))

Relationships

Close relationships within degrees of separation