deployments_personneldeployment

496 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('deployments_personneldeployment_id_seq'::regclass)
deployments_personnel.deployment_id deployments_personne_deployment_id_8f9c9c34_fk_deploymenR
comments text 2147483647 √ null
country_deployed_to_id int4 10 null
api_country.id deployments_personne_country_deployed_to__4695aac7_fk_api_countR
event_deployed_to_id int4 10 √ null
api_event.id deployments_personne_event_deployed_to_id_4ca35a75_fk_api_eventR
region_deployed_to_id int4 10 √ null
api_region.id deployments_personne_region_deployed_to_i_e7cf7745_fk_api_regioR
alert_date timestamptz 35,6 √ null
appeal_deployed_to_id int4 10 √ null
api_appeal.id deployments_personne_appeal_deployed_to_i_03cee064_fk_api_appeaR
end_date timestamptz 35,6 √ null
end_duration varchar 100 √ null
exp_start_date timestamptz 35,6 √ null
start_date timestamptz 35,6 √ null
created_at timestamptz 35,6 null
previous_update timestamptz 35,6 √ null
updated_at timestamptz 35,6 null
comments_ar text 2147483647 √ null
comments_en text 2147483647 √ null
comments_es text 2147483647 √ null
comments_fr text 2147483647 √ null
is_molnix bool 1 null
translation_module_original_language varchar 2 null
translation_module_skip_auto_translation bool 1 null

Indexes

Constraint Name Type Sort Column(s)
deployments_personneldeployment_pkey Primary key Asc id
deployments_personneldeployment_appeal_deployed_to_id_03cee064 Performance Asc appeal_deployed_to_id
deployments_personneldeployment_country_deployed_to_id_4695aac7 Performance Asc country_deployed_to_id
deployments_personneldeployment_event_deployed_to_id_4ca35a75 Performance Asc event_deployed_to_id
deployments_personneldeployment_region_deployed_to_id_e7cf7745 Performance Asc region_deployed_to_id

Relationships

Close relationships within degrees of separation