> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ticket_log_action table

> This table contains actions for the tickets.

## 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](./ticket.mdx)                           |    No    |
| org\_ticket\_id | The id of the orignal ticket this entry was connected to.                         | FK [ticket](./ticket.mdx)                           |    No    |
| message\_id     | If this entry is connected to a message, then this is a message change log entry. | FK [ej\_message](./ej-message.mdx)                  |    No    |
| user\_id        | The id of the user this entry is connected to.                                    | FK [ejuser](./ejuser.mdx)                           |    No    |
| customer\_id    | The id of the customer this entry is connected to.                                | FK [person](./person.mdx)                           |    No    |
| log\_when       | When the action occured.                                                          | DateTime                                            |    Yes   |
| log\_action     | An enum indicating what kind of log-entry this is.                                | Enum [TicketLogAction](./enums/ticketlogaction.mdx) |    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   |

<img src="https://mintcdn.com/superofficeas/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/ticket_log_action.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=054387ae3cc9e04cd9e5c1d722a56d92" alt="ticket_log_action table relationship diagram" width="784" height="732" data-path="media/loc/en/database/tables/ticket_log_action.png" />

## 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](./ej-message)                | This table contains the messages listed under tickets.                                   |
| [ejuser](./ejuser)                         | This table contains entries for the users of the system.                                 |
| [person](./person)                         | Persons                                                                                  |
| [ticket](./ticket)                         | This table contains the tickets (requests) of the system. Its purpose should be evident. |
| [ticket\_log\_change](./ticket-log-change) | This table contains log entries for the tickets.                                         |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [Logs](/en/automation/crmscript/howto/request/request-logs.md)
- [What's new in version 10.2.2.707](/release-notes/database/changes-10.2.2.md)
- [What's new in version 10.2.3.544](/release-notes/database/changes-10.2.3.md)
- [What's new in version 10.2.4.796](/release-notes/database/changes-10.2.4.md)
- [What's new in version 10.2.5.1175](/release-notes/database/changes-10.2.5.md)
- [What's new in version 10.2.6.1248](/release-notes/database/changes-10.2.6.md)