deployments_emergencyproject

169 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('deployments_emergencyproject_id_seq'::regclass)
deployments_emergencyproject_admin2.emergencyproject_id deployments_emergenc_emergencyproject_id_ca28b2a4_fk_deploymenR
deployments_emergencyproject_districts.emergencyproject_id deployments_emergenc_emergencyproject_id_6308847e_fk_deploymenR
deployments_emergencyprojectactivity.project_id deployments_emergenc_project_id_f32dd6c4_fk_deploymenR
title varchar 255 null
created_at timestamptz 35,6 null
modified_at timestamptz 35,6 null
activity_lead varchar 30 null
reporting_ns_contact_name varchar 255 √ null
reporting_ns_contact_role varchar 255 √ null
reporting_ns_contact_email varchar 255 √ null
start_date date 13 null
status varchar 40 null
created_by_id int4 10 √ null
auth_user.id deployments_emergenc_created_by_id_13774b97_fk_auth_userR
deployed_eru_id int4 10 √ null
deployments_eru.id deployments_emergenc_deployed_eru_id_dac64d2c_fk_deploymenR
event_id int4 10 null
api_event.id deployments_emergencyproject_event_id_10bc370f_fk_api_event_idR
modified_by_id int4 10 √ null
auth_user.id deployments_emergenc_modified_by_id_28f08254_fk_auth_userR
reporting_ns_id int4 10 √ null
api_country.id deployments_emergenc_reporting_ns_id_252d470d_fk_api_countR
country_id int4 10 null
api_country.id deployments_emergenc_country_id_15bda26c_fk_api_countR
end_date date 13 √ null
visibility varchar 32 null

Indexes

Constraint Name Type Sort Column(s)
deployments_emergencyproject_pkey Primary key Asc id
deployments_emergencyproject_country_id_15bda26c Performance Asc country_id
deployments_emergencyproject_created_by_id_13774b97 Performance Asc created_by_id
deployments_emergencyproject_deployed_eru_id_dac64d2c Performance Asc deployed_eru_id
deployments_emergencyproject_event_id_10bc370f Performance Asc event_id
deployments_emergencyproject_modified_by_id_28f08254 Performance Asc modified_by_id
deployments_emergencyproject_reporting_ns_id_252d470d Performance Asc reporting_ns_id

Relationships

Close relationships within degrees of separation