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.