> ## 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_change table

> This table contains log entries for the tickets.

## ticket\_log\_change Table (268)

This table contains log entries 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    |
| 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    |
| action\_id       | The id of ticket\_log\_action this entry is connected to.                         | FK [ticket\_log\_action](./ticket-log-action.mdx) |    No    |
| extra\_field\_id | The id of the extra\_field this entry is connected to.                            | FK [extra\_fields](./extra-fields.mdx)            |    No    |
| log\_change      | An enum indicating what kind of log-entry this is.                                | Int                                               |    Yes   |
| to\_value        | A the \'to\' value                                                      | String(255)                                       |    No    |
| from\_value      | A the \'from\' value                                                    | String(255)                                       |    No    |

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

## Indexes

| Fields           | Types | Description |
| ---------------- | ----- | ----------- |
| ticket\_id       | FK    | Index       |
| message\_id      | FK    | Index       |
| action\_id       | FK    | Index       |
| extra\_field\_id | FK    | Index       |

## Relationships

| Table                                      | Description                                                                              |
| ------------------------------------------ | ---------------------------------------------------------------------------------------- |
| [ej\_message](./ej-message)                | This table contains the messages listed under tickets.                                   |
| [extra\_fields](./extra-fields)            | This table contains entries for the extra fields in the system.                          |
| [ticket](./ticket)                         | This table contains the tickets (requests) of the system. Its purpose should be evident. |
| [ticket\_log\_action](./ticket-log-action) | This table contains actions 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)
- [ticket_log_action table](/en/database/tables/ticket-log-action.md)
- [ticket_log table](/en/database/tables/ticket-log.md)
- [Enum TicketLogFieldChange](/en/automation/crmscript/reference/CRMScript.NetServer.TicketLogFieldChange.md)
- [extra_fields table](/en/database/tables/extra-fields.md)
- [ticket table](/en/database/tables/ticket.md)