Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| ticket_profile_id | text |
|
|
|
| ticket_id | int8 |
|
|
The unique ticket ID, e.g. 101. |
| profile_id | int8 |
|
|
The profile_id of the person assigned to the ticket. E.g. 123. |
| profile_link | text |
|
|
A link to the assigned profile, e.g. https://app.carecompany.com.au/admin/profiles/101. |
| ticket_state | text |
|
|
The state of the ticket. One of four values - |
| ticket_due_at | timestamp |
|
|
The due date and time for the ticket resolution (in UTC), e.g.: 2021-03-02 00:12:59.996101. |
| company_id | int8 |
|
|
The ID of the company. E.g.: 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_ticket_assignees_pkey | Primary key | Asc | ticket_profile_id |
| fct_ticket_assignees_company_id_idx | Performance | Asc | company_id |
| fct_ticket_assignees_profile_id_idx | Performance | Asc | profile_id |
| fct_ticket_assignees_ticket_id_idx | Performance | Asc | ticket_id |