worker

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
worker_id uuid 2147483647 null
ai_candidate.worker_id fk_ai_candidate_worker_company R
stay_verification_case.worker_id fk_stay_verification_worker_company R
stored_file.worker_id fk_stored_file_worker_company R
task.worker_id fk_task_worker_company R
worker_archive.worker_id fk_worker_archive_worker_company R
worker_document.worker_id fk_worker_document_worker R
worker_import_row.worker_id fk_worker_import_row_worker_company R
workflow_case.worker_id fk_workflow_case_worker_company C
company_id uuid 2147483647 null
ai_candidate.company_id fk_ai_candidate_worker_company R
stay_verification_case.company_id fk_stay_verification_worker_company R
stored_file.company_id fk_stored_file_worker_company R
task.company_id fk_task_worker_company R
worker_archive.company_id fk_worker_archive_worker_company R
worker_document.company_id fk_worker_document_worker R
worker_import_row.company_id fk_worker_import_row_worker_company R
workflow_case.company_id fk_workflow_case_worker_company C
company.company_id fk_worker_company R
display_name varchar 120 null
nationality_code varchar 10 √ null
preferred_language varchar 20 √ null
work_status varchar 20 null
stay_expiry_date date 13 √ null
contract_start_date date 13 √ null
contract_end_date date 13 √ null
created_at timestamptz 35,6 CURRENT_TIMESTAMP
updated_at timestamptz 35,6 CURRENT_TIMESTAMP
version int8 19 0
visa_type varchar 20 √ null
employment_permit_end_date date 13 √ null
employment_activity_end_date date 13 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_worker Primary key Asc worker_id
idx_worker_company Performance Asc company_id
uq_worker_id_company Must be unique Asc/Asc worker_id + company_id

Check Constraints

Constraint Name Constraint
ck_worker_work_status (((work_status)::text = ANY ((ARRAY['ACTIVE'::character varying, 'ON_LEAVE'::character varying, 'RESIGNED'::character varying, 'TERMINATED'::character varying])::text[])))
ck_worker_contract_period (((contract_start_date IS NULL) OR (contract_end_date IS NULL) OR (contract_end_date >= contract_start_date)))
ck_worker_display_name_not_blank ((char_length(TRIM(BOTH FROM display_name)) > 0))
ck_worker_version ((version >= 0))
ck_worker_updated_at ((updated_at >= created_at))

Relationships

Close relationships within degrees of separation