AO Logo
 
  
  
  
Ticket Actions
AO
AO Industries, Inc.
Application Infrastructure ProviderApplication Infrastructure Provider
Sign UpWhat's NewClient AreaContact UsSite Map
 
your location:   home page ··· aoserv platform ··· software components ··· aoserv client ··· tables ··· table definitions ··· ticket actions

TABLE NAME

ticket_actions

DESCRIPTION

The ticket_actions table represent a complete history of the changes that have been made to a ticket. When a ticket is initially created it has no actions. Any change from its initial state will cause an action to be logged.

COLUMNS

columntypenulluniquereferencesreferenced_bysince_versiondescription
pkeypkeyfalsetrue1.44
ticketfkeyfalsefalsetickets.pkey1.44
administratorusernametruefalsebusiness_administrators.username1.44
timetimefalsefalse1.44
action_typestringfalsefalseticket_action_types.type1.44
old_accountingaccountingtruefalsebusinesses.accounting1.69
new_accountingaccountingtruefalsebusinesses.accounting1.69
old_prioritystringtruefalseticket_priorities.priority1.44
new_prioritystringtruefalseticket_priorities.priority1.44
old_typestringtruefalseticket_types.type1.49
new_typestringtruefalseticket_types.type1.49
old_statusstringtruefalseticket_stati.status1.44
new_statusstringtruefalseticket_stati.status1.44
old_assigned_tousernametruefalsebusiness_administrators.username1.80.0
new_assigned_tousernametruefalsebusiness_administrators.username1.80.0
old_categoryfkeytruefalseticket_categories.pkey1.44
new_categoryfkeytruefalseticket_categories.pkey1.44
old_valuestringtruefalse1.44
new_valuestringtruefalse1.44
from_addressemailtruefalse1.44
summarystringtruefalse1.44
detailsstringtruefalse1.44
raw_emailstringtruefalse1.44