task

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
task_id uuid 2147483647 null
ai_candidate_decision_task.task_id fk_ai_candidate_decision_task_task_company R
approval_request.task_id fk_approval_request_task_company R
document_request_draft.task_id fk_document_request_draft_task_company R
external_submission.task_id fk_external_submission_task_company R
stored_file.task_id fk_stored_file_task_company R
task_checklist_item.task_id fk_task_checklist_task_company C
task_evidence.task_id fk_task_evidence_task_company R
task_transition_history.task_id fk_task_transition_task_company R
worker_document.task_id fk_worker_document_task_worker_company R
worker_link.task_id fk_worker_link_task_company R
company_id uuid 2147483647 null
ai_candidate_decision_task.company_id fk_ai_candidate_decision_task_task_company R
approval_request.company_id fk_approval_request_task_company R
document_request_draft.company_id fk_document_request_draft_task_company R
external_submission.company_id fk_external_submission_task_company R
stored_file.company_id fk_stored_file_task_company R
task_checklist_item.company_id fk_task_checklist_task_company C
task_evidence.company_id fk_task_evidence_task_company R
task_transition_history.company_id fk_task_transition_task_company R
worker_document.company_id fk_worker_document_task_worker_company R
worker_link.company_id fk_worker_link_task_company R
company.company_id fk_task_company R
user_account.company_id fk_task_updated_by_company R
worker.company_id fk_task_worker_company R
worker_id uuid 2147483647 √ null
worker_document.worker_id fk_worker_document_task_worker_company R
worker.worker_id fk_task_worker_company R
case_id uuid 2147483647 √ null
workflow_case.case_id Implied Constraint R
task_type varchar 40 null
workflow_id varchar 100 null
workflow_catalog_version varchar 80 null
title varchar 160 null
description varchar 2000 √ null
business_data_json text 2147483647 null
critical_fingerprint varchar 64 null
content_revision int8 19 0
source varchar 30 null
status varchar 30 null
due_date date 13 √ null
created_by uuid 2147483647 null
user_account.user_id fk_task_created_by_company R
updated_by uuid 2147483647 null
user_account.user_id fk_task_updated_by_company R
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
version int8 19 0
target_type varchar 20 'WORKER'::character varying
assignee_id uuid 2147483647 √ null
user_account.user_id fk_task_assignee_company R

Indexes

Constraint Name Type Sort Column(s)
pk_task Primary key Asc task_id
idx_task_company_assignee Performance Asc/Asc company_id + assignee_id
idx_task_company_case Performance Asc/Asc company_id + case_id
idx_task_company_status_due Performance Asc/Asc/Asc company_id + status + due_date
idx_task_company_target_source Performance Asc/Asc/Asc/Desc company_id + target_type + source + created_at
idx_task_company_worker Performance Asc/Asc/Asc company_id + worker_id + created_at
uq_task_id_company Must be unique Asc/Asc task_id + company_id
uq_task_id_worker_company Must be unique Asc/Asc/Asc task_id + worker_id + company_id

Check Constraints

Constraint Name Constraint
ck_task_updated_at ((updated_at >= created_at))
ck_task_title_not_blank ((char_length(TRIM(BOTH FROM title)) > 0))
ck_task_version ((version >= 0))
ck_task_type (((task_type)::text = ANY ((ARRAY['RECONTRACT'::character varying, 'EMPLOYMENT_PERIOD_EXTENSION'::character varying, 'STAY_PERIOD_EXTENSION'::character varying, 'DOCUMENT_REQUEST'::character varying, 'WORKER_ONBOARDING'::character varying, 'PAYROLL_EXPLANATION'::character varying, 'EMPLOYMENT_CHANGE'::character varying, 'WORK_INSTRUCTION'::character varying])::text[])))
ck_task_catalog_version_not_blank ((char_length(TRIM(BOTH FROM workflow_catalog_version)) > 0))
ck_task_content_revision ((content_revision >= 0))
ck_task_source (((source)::text = ANY ((ARRAY['MANUAL'::character varying, 'SYSTEM_DDAY'::character varying, 'AI_CANDIDATE'::character varying, 'FILE_IMPORT'::character varying, 'WORKER_RESPONSE'::character varying])::text[])))
ck_task_status (((status)::text = ANY ((ARRAY['DRAFT'::character varying, 'NEEDS_INFO'::character varying, 'READY_FOR_REVIEW'::character varying, 'APPROVED'::character varying, 'WAITING_WORKER'::character varying, 'WAITING_EXTERNAL'::character varying, 'COMPLETED'::character varying, 'CANCELLED'::character varying])::text[])))
ck_task_workflow_id_not_blank ((char_length(TRIM(BOTH FROM workflow_id)) > 0))
ck_task_business_data_not_blank ((char_length(TRIM(BOTH FROM business_data_json)) > 0))
ck_task_target (((((target_type)::text = 'WORKER'::text) AND (worker_id IS NOT NULL) AND (case_id IS NOT NULL)) OR (((target_type)::text = 'COMPANY'::text) AND (worker_id IS NULL) AND (case_id IS NULL))))
ck_task_fingerprint_lowercase (((critical_fingerprint)::text = lower((critical_fingerprint)::text)))
ck_task_fingerprint_length ((char_length((critical_fingerprint)::text) = 64))

Relationships

Close relationships within degrees of separation