ticket_log_change Table (268)
Some tooltip text!
• 3 minutes to read
• 3 minutes to read
This table contains log entries for the tickets.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| ticket_id | The id of the ticket this entry is connected to. | FK ticket | |
| message_id | If this entry is connected to a message, then this is a message change log entry. | FK ej_message | |
| action_id | The id of ticket_log_action this entry is connected to. | FK ticket_log_action | |
| extra_field_id | The id of the extra_field this entry is connected to. | FK extra_fields | |
| log_change | An enum indicating what kind of log-entry this is. | Int | ● |
| to_value | A the 'to' value | String(255) | |
| from_value | A the 'from' value | String(255) |
The field ticket_log_change.log_change has an enum from this list:
enum LogChange
Ticket:
| Name | Value |
|---|---|
LogChange_Ticket_CreatedAt |
1 |
LogChange_Ticket_Title |
2 |
LogChange_Ticket_LastChanged |
3 |
LogChange_Ticket_ReadByOwner |
4 |
LogChange_Ticket_ReadByCustomer |
5 |
LogChange_Ticket_ClosedAt |
6 |
LogChange_Ticket_TimeToClose |
7 |
LogChange_Ticket_RealTimeToClose |
8 |
LogChange_Ticket_TimeToReply |
9 |
LogChange_Ticket_RealTimeToReply |
10 |
LogChange_Ticket_Author |
11 |
LogChange_Ticket_CreatedBy |
12 |
LogChange_Ticket_AlertLevel |
13 |
LogChange_Ticket_AlertTimeout |
14 |
LogChange_Ticket_ConnectId |
15 |
LogChange_Ticket_FilterId |
16 |
LogChange_Ticket_ReadStatus |
17 |
LogChange_Ticket_HasAttachment |
18 |
LogChange_Ticket_DisplayFilter |
19 |
LogChange_Ticket_AlertStop |
20 |
LogChange_Ticket_RepliedAt |
21 |
LogChange_Ticket_SLevel |
22 |
LogChange_Ticket_Category |
23 |
LogChange_Ticket_Priority |
24 |
LogChange_Ticket_CustId |
25 |
LogChange_Ticket_Status |
26 |
LogChange_Ticket_FirstReadByUser |
27 |
LogChange_Ticket_Activate |
28 |
LogChange_Ticket_OwnedBy |
29 |
LogChange_Ticket_AgentId |
30 |
LogChange_Ticket_DbiKey |
31 |
LogChange_Ticket_DbiLastSyncronized |
32 |
LogChange_Ticket_ExtraField |
33 |
LogChange_Ticket_FirstReadByOwner |
34 |
LogChange_Ticket_TicketStatus |
35 |
LogChange_Ticket_Deadline |
36 |
LogChange_Ticket_FilterAddress |
37 |
LogChange_Ticket_TimeSpentInternally |
38 |
LogChange_Ticket_TimeSpentExternally |
39 |
LogChange_Ticket_TimeSpentQueue |
40 |
LogChange_Ticket_RealTimeSpentInternally |
41 |
LogChange_Ticket_RealTimeSpentExternally |
42 |
LogChange_Ticket_RealTimeSpentQueue |
43 |
LogChange_Ticket_NumReplies |
44 |
LogChange_Ticket_NumMessages |
45 |
LogChange_Ticket_Tags |
46 |
LogChange_Ticket_SaleId |
47 |
LogChange_Ticket_ProjectId |
48 |
LogChange_Ticket_TicketType |
49 |
Message:
| Name | Value |
|---|---|
LogChange_Message_TicketId |
10001 |
LogChange_Message_CreatedAt |
10002 |
LogChange_Message_CreatedBy |
10003 |
LogChange_Message_Author |
10004 |
LogChange_Message_SLevel |
10005 |
LogChange_Message_Type |
10006 |
LogChange_Message_MessageId |
10007 |
LogChange_Message_TimeSpent |
10008 |
LogChange_Message_Body |
10009 |
LogChange_Message_BodyHtml |
10010 |
LogChange_Message_Header |
10011 |
LogChange_Message_ExtraField |
10012 |
LogChange_Message_MailSorter |
10013 |
LogChange_Message_MessageCategory |
10014 |
LogChange_Message_CustomerId |
10015 |
LogChange_Message_DebugInfo |
10016 |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| ticket_id | FK | Index |
| message_id | FK | Index |
| action_id | FK | Index |
| extra_field_id | FK | Index |
Relationships
| Table | Description |
|---|---|
| ej_message | This table contains the messages listed under tickets. |
| extra_fields | This table contains entries for the extra fields in the system. |
| ticket | This table contains the tickets (requests) of the system. Its purpose should be evident. |
| ticket_log_action | This table contains actions for the tickets. |
Replication Flags
- None
Security Flags
- No access control via user's Role.