deployments_personnel

3604 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
deployedperson_ptr_id int4 10 null
deployments_personnel_molnix_tags.personnel_id deployments_personne_personnel_id_e20d91a0_fk_deploymenR
deployments_deployedperson.id deployments_personne_deployedperson_ptr_i_9f01699d_fk_deploymenR
type varchar 4 null
country_from_id int4 10 √ null
api_country.id deployments_personne_country_from_id_f0930561_fk_api_countR
deployment_id int4 10 null
deployments_personneldeployment.id deployments_personne_deployment_id_8f9c9c34_fk_deploymenR
is_active bool 1 null
molnix_id int4 10 √ null
country_to_id int4 10 √ null
api_country.id deployments_personnel_country_to_id_728793e5_fk_api_country_idR
molnix_status varchar 8 null
surge_alert_id int4 10 √ null
notifications_surgealert.id deployments_personne_surge_alert_id_a5fe32e4_fk_notificatR
gender varchar 15 √ null
location varchar 300 √ null
appraisal_received bool 1 null

Indexes

Constraint Name Type Sort Column(s)
deployments_personnel_pkey Primary key Asc deployedperson_ptr_id
deployments_personnel_country_from_id_f0930561 Performance Asc country_from_id
deployments_personnel_country_to_id_728793e5 Performance Asc country_to_id
deployments_personnel_deployment_id_8f9c9c34 Performance Asc deployment_id
deployments_personnel_surge_alert_id_a5fe32e4 Performance Asc surge_alert_id

Relationships

Close relationships within degrees of separation