fct_ticket_todos


Description

Multiple todos can be added to each ticket through the ticket template. This is a series of steps that need to be completed after the ticket is created. For example, a step might be: Schedule a follow-up with the Member.

Columns

Column Type Children Parents Comments
ticket_todo_id int8

The unique ticket todo ID. E.g. 43.
ticket_id int8
fct_tickets.ticket_id Implied Constraint R

The associated ticket ID of the todo. E.g. 59.
todo_title varchar

The title of the todo within the ticket. E.g. Create Member Help Plan.
sequence_number int4

Defines the order in which todos should be completed, from 1 to the number of todos. E.g. 4.
is_done bool

Whether the todo is completed or not. True or False.
completed_at timestamp

The date and time (in UTC) the todo was completed. E.g.: 2021-03-02 00:12:59.
created_at timestamp

The date and time (in UTC) the todo was created. E.g.: 2021-03-02 00:12:59.
updated_at timestamp

The date and time (in UTC) the todo was updated. E.g.: 2021-03-02 00:12:59.
ticket_state text

See state in fct_tickets.
ticket_opened_at timestamp

See opened_at in fct_tickets.
ticket_closed_at timestamp

See closed_at in fct_tickets.
company_id int8
dim_companies.company_id Implied Constraint R

The ID of the company. E.g.: 345.

Indexes

Constraint Name Type Sort Column(s)
fct_ticket_todos_pkey Primary key Asc ticket_todo_id
fct_ticket_todos_ticket_id_idx Performance Asc ticket_id

Relationships

Close relationships within degrees of separation