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

> This table user defined ticket status values.

## ticket\_status Table (263)

This table user defined ticket status values.

## Fields

| Name              | Description                                                                   | Type                                                                | Nullable |
| ----------------- | ----------------------------------------------------------------------------- | ------------------------------------------------------------------- | :------: |
| id                | The primary key (auto-incremented)                                            | PK                                                                  |    No    |
| status            | The \'classic\' ticket status. I.e. active/closed/postponed/deleted | Enum [TicketBaseStatus](./enums/ticketbasestatus.mdx)               |    No    |
| ts\_rank          | Sort order                                                                    | Int                                                                 |    No    |
| name              | Name of user defined ticket status                                            | String(255)                                                         |    No    |
| time\_counter     | Which field in ticket we count time spent on (queue, internal, external)      | Enum [TicketStatusTimeCounter](./enums/ticketstatustimecounter.mdx) |    Yes   |
| deleted           | Whether the status is deleted (unavailable) or not                            | Bool                                                                |    Yes   |
| no\_email\_reopen | Whether inbound emails can reopen requests with this status or not            | Bool                                                                |    Yes   |

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

## Indexes

| Fields | Types | Description |
| ------ | ----- | ----------- |
| status | Enum  | Index       |

## Relationships

| Table                                              | Description                                                                                                                                        |
| -------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- |
| [ej\_category](./ej-category)                      | This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner.                            |
| [ejuser](./ejuser)                                 | This table contains entries for the users of the system.                                                                                           |
| [ticket](./ticket)                                 | This table contains the tickets (requests) of the system. Its purpose should be evident.                                                           |
| [ticket\_status\_history](./ticket-status-history) | This table contains the history of a tickets statuses. Each time a ticket changes status a copy of the previous status of the record will be saved |
| [ticket\_type](./ticket-type)                      | A ticket (request) type                                                                                                                            |
| [ticket\_type\_status](./ticket-type-status)       | Link table defining what Statuses are relevant to a particular Ticket type                                                                         |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [ticket_status_history table](/en/database/tables/ticket-status-history.md)
- [Ticket table](/en/api/bulk-operations/bulk-update/reference/ticket-table.md)
- [ticket_type_status table](/en/database/tables/ticket-type-status.md)
- [Enum values for TicketStatusTimeCounter](/en/database/tables/enums/ticketstatustimecounter.md)
- [ticket table](/en/database/tables/ticket.md)
- [Enum values for TicketBaseStatus](/en/database/tables/enums/ticketbasestatus.md)