deployments_molnixappraisal

359 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
deployments_molnixappraiser.appraisal_id deployments_molnixap_appraisal_id_b3a92212_fk_deploymenR
molnix_id int8 19 null
target_id int8 19 null
deployment_molnix_id int8 19 √ null
stage varchar 64 √ null
appraisers_count int4 10 √ null
score numeric 7,3 √ null
deployment_country_id int4 10 √ null
deployment_start timestamptz 35,6 √ null
deployment_end timestamptz 35,6 √ null
deployment_title varchar 255 √ null
sending_organization_id int8 19 √ null
receiving_organization_id int8 19 √ null
deployment_tags_json jsonb 2147483647 √ null
competencies_json jsonb 2147483647 √ null
created_at timestamptz 35,6 √ null
updated_at timestamptz 35,6 √ null
personnel_id int4 10 √ null
deployments_personnel.deployedperson_ptr_id deployments_molnixap_personnel_id_3ced79ea_fk_deploymenR
appraised_person_id int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
deployments_molnixappraisal_pkey Primary key Asc id
deployments_molnixappraisal_molnix_id_key Must be unique Asc molnix_id
deployments_molnixappraisal_personnel_id_3ced79ea Performance Asc personnel_id
molnix_app_personnel_idx Performance Asc personnel_id
molnix_app_target_idx Performance Asc target_id
molnix_app_updated_idx Performance Asc updated_at
molnix_appraised_person_idx Performance Asc appraised_person_id

Relationships

Close relationships within degrees of separation