Ticket group
The ticket group of tables provide access to database tables relating to ticketing.
Informational tables are identified with the information symbol:
| Table name | Description |
|---|---|
| account | General account information. |
| crm_contact | An audit or history of all of the changes and events related to a ticket. |
| crm_contact_type | |
| operator | Information about someone who has access to Smile. |
| subscription | Header record for subscriptions. |
| ticket | All tickets and workflow instances. |
| ticket_action | Lists the ticket actions defined by each ticket type. |
| ticket_group | Tickets belong to ticket assignment groups. These groups represent the teams of people who work on tickets. |
| ticket_priority | An enumeration table listing the priorities defined in the system. |
| ticket_status | As tickets progress through their work flows their status changes. |
| ticket_status_log | Records the status changes of tickets over time. |
| ticket_type | Ticket types represent workflow configurations. |
| timesheet | A record of time spent by an operator on a particular ticket. |
| tx | Represents a financial transaction on an account. |