deployments_fact

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('deployments_fact_id_seq'::regclass)
deployments_factperson.fact_id deployments_factperson_fact_id_14e20cbf_fk_deployments_fact_idR
start_date timestamptz 35,6 √ null
comments text 2147483647 √ null
country_id int4 10 null
api_country.id deployments_fact_country_id_4f80d5ad_fk_api_country_idR
dtype_id int4 10 √ null
api_disastertype.id deployments_fact_dtype_id_f940324a_fk_api_disastertype_idR
event_id int4 10 √ null
api_event.id deployments_fact_event_id_6953280a_fk_api_event_idR
region_id int4 10 null
api_region.id deployments_fact_region_id_cdd84270_fk_api_region_idR

Indexes

Constraint Name Type Sort Column(s)
deployments_fact_pkey Primary key Asc id
deployments_fact_country_id_4f80d5ad Performance Asc country_id
deployments_fact_dtype_id_f940324a Performance Asc dtype_id
deployments_fact_event_id_6953280a Performance Asc event_id
deployments_fact_region_id_cdd84270 Performance Asc region_id

Relationships

Close relationships within degrees of separation