task_checklist_item

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
checklist_item_id uuid 2147483647 null
task_id uuid 2147483647 null
task.task_id fk_task_checklist_task_company C
company_id uuid 2147483647 null
user_account.company_id fk_task_checklist_actor_company R
task.company_id fk_task_checklist_task_company C
item_code varchar 100 null
label varchar 300 null
required bool 1 null
completed bool 1 false
completed_by uuid 2147483647 √ null
user_account.user_id fk_task_checklist_actor_company R
completed_at timestamptz 35,6 √ null
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_checklist_item Primary key Asc checklist_item_id
idx_task_checklist_task Performance Asc/Asc company_id + task_id
uq_task_checklist_code Must be unique Asc/Asc task_id + item_code

Check Constraints

Constraint Name Constraint
ck_task_checklist_code_not_blank (char_length(TRIM(BOTH FROM item_code)) > 0)
ck_task_checklist_label_not_blank (char_length(TRIM(BOTH FROM label)) > 0)
ck_task_checklist_completion (((completed = false) AND (completed_by IS NULL) AND (completed_at IS NULL)) OR ((completed = true) AND (completed_by IS NOT NULL) AND (completed_at IS NOT NULL)))
ck_task_checklist_version (version >= 0)
ck_task_checklist_updated_at (updated_at >= created_at)

Relationships

Close relationships within degrees of separation