task_transition_history

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
transition_id uuid 2147483647 null
task_id uuid 2147483647 null
task.task_id fk_task_transition_task_company R
company_id uuid 2147483647 null
user_account.company_id fk_task_transition_actor_company R
task.company_id fk_task_transition_task_company R
from_status varchar 30 null
to_status varchar 30 null
actor_id uuid 2147483647 null
user_account.user_id fk_task_transition_actor_company R
reason varchar 500 √ null
request_id varchar 128 null
created_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
pk_task_transition_history Primary key Asc transition_id
idx_task_transition_task_time Performance Asc/Asc/Asc company_id + task_id + created_at

Check Constraints

Constraint Name Constraint
ck_task_transition_changed ((from_status)::text <> (to_status)::text)
ck_task_transition_to_status ((to_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_transition_request_not_blank (char_length(TRIM(BOTH FROM request_id)) > 0)
ck_task_transition_from_status ((from_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[]))

Relationships

Close relationships within degrees of separation