task

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
task_id uuid 2147483647 null
approval_request.task_id fk_approval_request_task_company R
external_submission.task_id fk_external_submission_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
company_id uuid 2147483647 null
approval_request.company_id fk_approval_request_task_company R
external_submission.company_id fk_external_submission_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
user_account.company_id fk_task_updated_by_company R
worker.company_id fk_task_worker_company R
company.company_id fk_task_company R
worker_id uuid 2147483647 null
worker.worker_id fk_task_worker_company R
case_id uuid 2147483647 null
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

Indexes

Constraint Name Type Sort Column(s)
pk_task Primary key Asc task_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_worker Performance Asc/Asc/Asc company_id + worker_id + created_at
uq_task_id_company Must be unique Asc/Asc task_id + company_id

Check Constraints

Constraint Name Constraint
ck_task_business_data_not_blank (char_length(TRIM(BOTH FROM business_data_json)) > 0)
ck_task_source ((source)::text = ANY ((ARRAY['MANUAL'::character varying, 'SYSTEM_DDAY'::character varying, 'AI_CANDIDATE'::character varying])::text[]))
ck_task_type ((task_type)::text = ANY ((ARRAY['RECONTRACT'::character varying, 'EMPLOYMENT_PERIOD_EXTENSION'::character varying, 'STAY_PERIOD_EXTENSION'::character varying])::text[]))
ck_task_version (version >= 0)
ck_task_catalog_version_not_blank (char_length(TRIM(BOTH FROM workflow_catalog_version)) > 0)
ck_task_fingerprint_lowercase ((critical_fingerprint)::text = lower((critical_fingerprint)::text))
ck_task_workflow_id_not_blank (char_length(TRIM(BOTH FROM workflow_id)) > 0)
ck_task_fingerprint_length (char_length((critical_fingerprint)::text) = 64)
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_content_revision (content_revision >= 0)
ck_task_title_not_blank (char_length(TRIM(BOTH FROM title)) > 0)
ck_task_updated_at (updated_at >= created_at)

Relationships

Close relationships within degrees of separation