eap_fulleap

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
eap_eapregistration.latest_full_eap_id eap_eapregistration_latest_full_eap_id_514f5f0e_fk_eap_fulleR
eap_fulleap.parent_id eap_fulleap_parent_id_6b1aa579_fk_eap_fulleap_idR
eap_fulleap_activation_process_relevant_files.fulleap_id eap_fulleap_activati_fulleap_id_f1a9cace_fk_eap_fulleR
eap_fulleap_activation_process_source_of_information.fulleap_id eap_fulleap_activati_fulleap_id_b1069e32_fk_eap_fulleR
eap_fulleap_admin2.fulleap_id eap_fulleap_admin2_fulleap_id_0a414973_fk_eap_fulleap_idR
eap_fulleap_capacity_relevant_files.fulleap_id eap_fulleap_capacity_fulleap_id_504bc59f_fk_eap_fulleR
eap_fulleap_definition_and_justification_impact_level_images.fulleap_id eap_fulleap_definiti_fulleap_id_080f1703_fk_eap_fulleR
eap_fulleap_early_action_implementation_images.fulleap_id eap_fulleap_early_ac_fulleap_id_e6bcbe4e_fk_eap_fulleR
eap_fulleap_early_action_selection_process_images.fulleap_id eap_fulleap_early_ac_fulleap_id_fafe58ec_fk_eap_fulleR
eap_fulleap_early_actions.fulleap_id eap_fulleap_early_actions_fulleap_id_bd995fc5_fk_eap_fulleap_idR
eap_fulleap_enabling_approaches.fulleap_id eap_fulleap_enabling_fulleap_id_c558b749_fk_eap_fulleR
eap_fulleap_evidence_base_relevant_files.fulleap_id eap_fulleap_evidence_fulleap_id_5ffdd4d9_fk_eap_fulleR
eap_fulleap_evidence_base_source_of_information.fulleap_id eap_fulleap_evidence_fulleap_id_c2265248_fk_eap_fulleR
eap_fulleap_exposed_element_and_vulnerability_factor_images.fulleap_id eap_fulleap_exposed__fulleap_id_c494c62d_fk_eap_fulleR
eap_fulleap_forecast_selection_images.fulleap_id eap_fulleap_forecast_fulleap_id_913da5a0_fk_eap_fulleR
eap_fulleap_hazard_selection_images.fulleap_id eap_fulleap_hazard_s_fulleap_id_8e8295bd_fk_eap_fulleR
eap_fulleap_identification_of_the_intervention_area_images.fulleap_id eap_fulleap_identifi_fulleap_id_ee4c0888_fk_eap_fulleR
eap_fulleap_key_actors.fulleap_id eap_fulleap_key_actors_fulleap_id_42341e25_fk_eap_fulleap_idR
eap_fulleap_meal_relevant_files.fulleap_id eap_fulleap_meal_rel_fulleap_id_76b957a3_fk_eap_fulleR
eap_fulleap_meal_source_of_information.fulleap_id eap_fulleap_meal_sou_fulleap_id_57e558a6_fk_eap_fulleR
eap_fulleap_ns_capacity_source_of_information.fulleap_id eap_fulleap_ns_capac_fulleap_id_b239a061_fk_eap_fulleR
eap_fulleap_partner_contacts.fulleap_id eap_fulleap_partner__fulleap_id_cacabbc2_fk_eap_fulleR
eap_fulleap_partners.fulleap_id eap_fulleap_partners_fulleap_id_d49bcba8_fk_eap_fulleap_idR
eap_fulleap_planned_operations.fulleap_id eap_fulleap_planned__fulleap_id_679fee8f_fk_eap_fulleR
eap_fulleap_prioritized_impact_images.fulleap_id eap_fulleap_prioriti_fulleap_id_15c37f66_fk_eap_fulleR
eap_fulleap_prioritized_impacts.fulleap_id eap_fulleap_prioriti_fulleap_id_0ea275cb_fk_eap_fulleR
eap_fulleap_risk_analysis_relevant_files.fulleap_id eap_fulleap_risk_ana_fulleap_id_4248d18d_fk_eap_fulleR
eap_fulleap_risk_analysis_source_of_information.fulleap_id eap_fulleap_risk_ana_fulleap_id_2c5ef3bb_fk_eap_fulleR
eap_fulleap_trigger_activation_system_images.fulleap_id eap_fulleap_trigger__fulleap_id_7f623645_fk_eap_fulleR
eap_fulleap_trigger_model_relevant_files.fulleap_id eap_fulleap_trigger__fulleap_id_2c6ee7ce_fk_eap_fulleR
eap_fulleap_trigger_model_source_of_information.fulleap_id eap_fulleap_trigger__fulleap_id_144f58de_fk_eap_fulleR
eap_fulleap_trigger_statement_source_of_information.fulleap_id eap_fulleap_trigger__fulleap_id_9173446e_fk_eap_fulleR
created_at timestamptz 35,6 null
people_targeted int4 10 √ null
national_society_contact_name varchar 255 null
national_society_contact_title varchar 255 √ null
national_society_contact_email varchar 255 null
national_society_contact_phone_number varchar 100 √ null
ifrc_delegation_focal_point_name varchar 255 √ null
ifrc_delegation_focal_point_email varchar 255 √ null
ifrc_delegation_focal_point_title varchar 255 √ null
ifrc_delegation_focal_point_phone_number varchar 100 √ null
ifrc_head_of_delegation_name varchar 255 √ null
ifrc_head_of_delegation_email varchar 255 √ null
ifrc_head_of_delegation_title varchar 255 √ null
ifrc_head_of_delegation_phone_number varchar 100 √ null
dref_focal_point_name varchar 255 √ null
dref_focal_point_email varchar 255 √ null
dref_focal_point_title varchar 255 √ null
dref_focal_point_phone_number varchar 100 √ null
ifrc_regional_focal_point_name varchar 255 √ null
ifrc_regional_focal_point_email varchar 255 √ null
ifrc_regional_focal_point_title varchar 255 √ null
ifrc_regional_focal_point_phone_number varchar 100 √ null
ifrc_regional_ops_manager_name varchar 255 √ null
ifrc_regional_ops_manager_email varchar 255 √ null
ifrc_regional_ops_manager_title varchar 255 √ null
ifrc_regional_ops_manager_phone_number varchar 100 √ null
ifrc_regional_head_dcc_name varchar 255 √ null
ifrc_regional_head_dcc_email varchar 255 √ null
ifrc_regional_head_dcc_title varchar 255 √ null
ifrc_regional_head_dcc_phone_number varchar 100 √ null
ifrc_global_ops_coordinator_name varchar 255 √ null
ifrc_global_ops_coordinator_email varchar 255 √ null
ifrc_global_ops_coordinator_title varchar 255 √ null
ifrc_global_ops_coordinator_phone_number varchar 100 √ null
export_file varchar 100 √ null
diff_file varchar 100 √ null
review_checklist_file varchar 100 √ null
total_budget int4 10 √ null
readiness_budget int4 10 √ null
pre_positioning_budget int4 10 √ null
early_action_budget int4 10 √ null
modified_at timestamptz 35,6 null
expected_submission_time date 13 null
objective text 2147483647 null
is_worked_with_government bool 1 √ null
worked_with_government_description text 2147483647 √ null
is_technical_working_groups bool 1 √ null
technically_working_group_title varchar 255 √ null
technical_working_groups_in_place_description text 2147483647 √ null
hazard_selection text 2147483647 √ null
exposed_element_and_vulnerability_factor text 2147483647 √ null
prioritized_impact text 2147483647 √ null
trigger_statement text 2147483647 √ null
lead_time int4 10 √ null
lead_timeframe_unit int4 10 √ null
forecast_selection text 2147483647 √ null
definition_and_justification_impact_level text 2147483647 √ null
identification_of_the_intervention_area text 2147483647 √ null
early_action_selection_process text 2147483647 √ null
evidence_base text 2147483647 √ null
usefulness_of_actions text 2147483647 √ null
feasibility text 2147483647 √ null
early_action_implementation_process text 2147483647 √ null
trigger_activation_system text 2147483647 √ null
selection_of_target_population text 2147483647 √ null
stop_mechanism text 2147483647 √ null
meal text 2147483647 √ null
operational_administrative_capacity text 2147483647 √ null
strategies_and_plans text 2147483647 √ null
advance_financial_capacity text 2147483647 √ null
budget_description text 2147483647 √ null
readiness_cost_description text 2147483647 √ null
prepositioning_cost_description text 2147483647 √ null
early_action_cost_description text 2147483647 √ null
eap_endorsement text 2147483647 √ null
version int4 10 null
is_locked bool 1 null
budget_file_id int4 10 √ null
eap_eapfile.id eap_fulleap_budget_file_id_88dd8738_fk_eap_eapfile_idR
cover_image_id int4 10 √ null
eap_eapfile.id eap_fulleap_cover_image_id_4a18fb66_fk_eap_eapfile_idR
created_by_id int4 10 null
auth_user.id eap_fulleap_created_by_id_5a78ec41_fk_auth_user_idR
eap_registration_id int4 10 null
eap_eapregistration.id eap_fulleap_eap_registration_id_197284d9_fk_eap_eapreR
forecast_table_file_id int4 10 √ null
eap_eapfile.id eap_fulleap_forecast_table_file_id_a3cd12cc_fk_eap_eapfile_idR
modified_by_id int4 10 null
auth_user.id eap_fulleap_modified_by_id_ae5ff938_fk_auth_user_idR
parent_id int4 10 √ null
eap_fulleap.id eap_fulleap_parent_id_6b1aa579_fk_eap_fulleap_idR
theory_of_change_table_file_id int4 10 √ null
eap_eapfile.id eap_fulleap_theory_of_change_tab_9a166554_fk_eap_eapfiR
updated_checklist_file_id int4 10 √ null
eap_eapfile.id eap_fulleap_updated_checklist_fi_212a226e_fk_eap_eapfiR

Indexes

Constraint Name Type Sort Column(s)
eap_fulleap_pkey Primary key Asc id
eap_fulleap_budget_file_id_88dd8738 Performance Asc budget_file_id
eap_fulleap_cover_image_id_4a18fb66 Performance Asc cover_image_id
eap_fulleap_created_by_id_5a78ec41 Performance Asc created_by_id
eap_fulleap_eap_registration_id_197284d9 Performance Asc eap_registration_id
eap_fulleap_forecast_table_file_id_a3cd12cc Performance Asc forecast_table_file_id
eap_fulleap_modified_by_id_ae5ff938 Performance Asc modified_by_id
eap_fulleap_parent_id_6b1aa579 Performance Asc parent_id
eap_fulleap_theory_of_change_table_file_id_9a166554 Performance Asc theory_of_change_table_file_id
eap_fulleap_updated_checklist_file_id_212a226e Performance Asc updated_checklist_file_id
unique_full_eap_version Must be unique Asc/Asc eap_registration_id + version

Relationships

Close relationships within degrees of separation