ticket_log_action Table (269)
This table contains actions for the tickets.Fields
| Name | Description | Type | Nullable |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | No |
| ticket_id | The id of the ticket this entry is connected to. | FK ticket | No |
| org_ticket_id | The id of the orignal ticket this entry was connected to. | FK ticket | No |
| message_id | If this entry is connected to a message, then this is a message change log entry. | FK ej_message | No |
| user_id | The id of the user this entry is connected to. | FK ejuser | No |
| customer_id | The id of the customer this entry is connected to. | FK person | No |
| log_when | When the action occured. | DateTime | Yes |
| log_action | An enum indicating what kind of log-entry this is. | Enum TicketLogAction | Yes |
| description | Action description, only used by customer actions like ejscript | String(255) | No |
| details | Field for storing details of the log action as e.g. JSON | Clob | Yes |
Indexes
| Fields | Types | Description |
|---|---|---|
| ticket_id | FK | Index |
| org_ticket_id | FK | Index |
| message_id | FK | Index |
| user_id | FK | Index |
| customer_id | FK | Index |
Relationships
| Table | Description |
|---|---|
| ej_message | This table contains the messages listed under tickets. |
| ejuser | This table contains entries for the users of the system. |
| person | Persons |
| ticket | This table contains the tickets (requests) of the system. Its purpose should be evident. |
| ticket_log_change | This table contains log entries for the tickets. |
Replication Flags
- None
Security Flags
- No access control via user’s Role.