deployments_eru

48 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('deployments_eru_id_seq'::regclass)
deployments_emergencyproject.deployed_eru_id deployments_emergenc_deployed_eru_id_dac64d2c_fk_deploymenR
type int4 10 null
units int4 10 null
equipment_units int4 10 null
available bool 1 null
deployed_to_id int4 10 √ null
api_country.id deployments_eru_deployed_to_id_0149f892_fk_api_country_idR
eru_owner_id int4 10 null
deployments_eruowner.id deployments_eru_eru_owner_id_b3d1a029_fk_deploymenR
event_id int4 10 √ null
api_event.id deployments_eru_event_id_58780f12_fk_api_event_idR
alert_date timestamptz 35,6 √ null
appeal_id int4 10 √ null
api_appeal.id deployments_eru_appeal_id_11bd74db_fk_api_appeal_idR
end_date timestamptz 35,6 √ null
num_people_deployed int4 10 null
start_date timestamptz 35,6 √ null
supporting_societies varchar 500 √ null

Indexes

Constraint Name Type Sort Column(s)
deployments_eru_pkey Primary key Asc id
deployments_eru_appeal_id_11bd74db Performance Asc appeal_id
deployments_eru_deployed_to_id_0149f892 Performance Asc deployed_to_id
deployments_eru_eru_owner_id_b3d1a029 Performance Asc eru_owner_id
deployments_eru_event_id_58780f12 Performance Asc event_id

Relationships

Close relationships within degrees of separation