deployments_heop

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('deployments_heop_id_seq'::regclass)
start_date timestamptz 35,6 √ null
end_date timestamptz 35,6 √ null
person varchar 100 √ null
role varchar 32 √ null
comments text 2147483647 √ null
country_id int4 10 null
api_country.id deployments_heop_country_id_30ddffc2_fk_api_country_idR
dtype_id int4 10 √ null
api_disastertype.id deployments_heop_dtype_id_0a894a02_fk_api_disastertype_idR
event_id int4 10 √ null
api_event.id deployments_heop_event_id_1d298c17_fk_api_event_idR
region_id int4 10 null
api_region.id deployments_heop_region_id_bd316224_fk_api_region_idR

Indexes

Constraint Name Type Sort Column(s)
deployments_heop_pkey Primary key Asc id
deployments_heop_country_id_30ddffc2 Performance Asc country_id
deployments_heop_dtype_id_0a894a02 Performance Asc dtype_id
deployments_heop_event_id_1d298c17 Performance Asc event_id
deployments_heop_region_id_bd316224 Performance Asc region_id

Relationships

Close relationships within degrees of separation