TABLE NAMEtickets
DESCRIPTIONTable tickets contains information on service requests COLUMNScolumn | type | null | unique | references | referenced_by | since_version | description |
---|
pkey | pkey | false | true | | ticket_actions.ticket ticket_assignments.ticket | 1.0a100 | | brand | accounting | false | false | brands.accounting | | 1.46 | | reseller | accounting | false | false | resellers.accounting | | 1.44 | | accounting | accounting | true | false | businesses.accounting | | 1.0a126 | | language | string | false | false | languages.code | | 1.44 | | created_by | username | true | false | business_administrators.username | | 1.0a126 | | category | fkey | true | false | ticket_categories.pkey | | 1.44 | | ticket_type | string | false | false | ticket_types.type | | 1.0a100 | | from_address | email | true | false | | | 1.44 | | summary | string | false | false | | | 1.44 | | details | string | true | false | | | 1.44 | | raw_email | string | true | false | | | 1.44 | | open_date | time | false | false | | | 1.0a100 | | client_priority | string | false | false | ticket_priorities.priority | | 1.0a100 | | admin_priority | string | true | false | ticket_priorities.priority | | 1.10 | | status | string | false | false | ticket_stati.status | | 1.0a100 | | status_timeout | time | true | false | | | 1.69 | | contact_emails | string | false | false | | | 1.0a125 | | contact_phone_numbers | string | false | false | | | 1.0a125 | | internal_notes | string | false | false | | | 1.69 | |
|