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 | An enumeration table listing the different kinds of crm_contact entry defined by Smile. |
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. |