eap_eapregistration

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
eap_eapregistration_partners.eapregistration_id eap_eapregistration__eapregistration_id_e65b9d5a_fk_eap_eapreR
eap_eapregistration_users.eapregistration_id eap_eapregistration__eapregistration_id_7a77809d_fk_eap_eapreR
eap_fulleap.eap_registration_id eap_fulleap_eap_registration_id_197284d9_fk_eap_eapreR
eap_simplifiedeap.eap_registration_id eap_simplifiedeap_eap_registration_id_07390825_fk_eap_eapreR
created_at timestamptz 35,6 null
modified_at timestamptz 35,6 null
eap_type int4 10 √ null
status int4 10 null
expected_submission_time date 13 √ null
validated_budget_file varchar 100 √ null
summary_file varchar 100 √ 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_contact_name varchar 255 √ null
ifrc_contact_email varchar 255 √ null
ifrc_contact_title varchar 255 √ null
ifrc_contact_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
technically_validated_at timestamptz 35,6 √ null
approved_at timestamptz 35,6 √ null
pending_pfa_at timestamptz 35,6 √ null
deadline date 13 √ null
deadline_remainder_sent_at timestamptz 35,6 √ null
country_id int4 10 null
api_country.id eap_eapregistration_country_id_2811e21d_fk_api_country_idR
created_by_id int4 10 null
auth_user.id eap_eapregistration_created_by_id_4269bab6_fk_auth_user_idR
disaster_type_id int4 10 null
api_disastertype.id eap_eapregistration_disaster_type_id_39bff3db_fk_api_disasR
latest_full_eap_id int4 10 √ null
eap_fulleap.id eap_eapregistration_latest_full_eap_id_514f5f0e_fk_eap_fulleR
latest_simplified_eap_id int4 10 √ null
eap_simplifiedeap.id eap_eapregistration_latest_simplified_ea_8e1429a1_fk_eap_simplR
modified_by_id int4 10 null
auth_user.id eap_eapregistration_modified_by_id_38e7bf96_fk_auth_user_idR
national_society_id int4 10 null
api_country.id eap_eapregistration_national_society_id_9b189096_fk_api_countR

Indexes

Constraint Name Type Sort Column(s)
eap_eapregistration_pkey Primary key Asc id
eap_eapregistration_country_id_2811e21d Performance Asc country_id
eap_eapregistration_created_by_id_4269bab6 Performance Asc created_by_id
eap_eapregistration_disaster_type_id_39bff3db Performance Asc disaster_type_id
eap_eapregistration_latest_full_eap_id_514f5f0e Performance Asc latest_full_eap_id
eap_eapregistration_latest_simplified_eap_id_8e1429a1 Performance Asc latest_simplified_eap_id
eap_eapregistration_modified_by_id_38e7bf96 Performance Asc modified_by_id
eap_eapregistration_national_society_id_9b189096 Performance Asc national_society_id

Relationships

Close relationships within degrees of separation