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

> Link table defining what Statuses are relevant to a particular Ticket type

## ticket\_type\_status Table (554)

Link table defining what Statuses are relevant to a particular Ticket type

## Fields

| Name                      | Description                           | Type                                     | Nullable |
| ------------------------- | ------------------------------------- | ---------------------------------------- | :------: |
| ticket\_type\_status\_id  | Primary key                           | PK                                       |    No    |
| ticket\_type\_id          | Ticket type                           | FK [ticket\_type](./ticket-type.mdx)     |    No    |
| ticket\_status\_id        | Ticket status                         | FK [ticket\_status](./ticket-status.mdx) |    No    |
| registered                | Registered when                       | UtcDateTime                              |    No    |
| registered\_associate\_id | Registered by whom                    | FK [associate](./associate.mdx)          |    No    |
| updated                   | Last updated when                     | UtcDateTime                              |    No    |
| updated\_associate\_id    | Last updated by whom                  | FK [associate](./associate.mdx)          |    No    |
| updatedCount              | Number of updates made to this record | UShort                                   |    No    |

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

## Indexes

| Fields | Types | Description |
| ------ | ----- | ----------- |

## Relationships

| Table                             | Description                                                        |
| --------------------------------- | ------------------------------------------------------------------ |
| [associate](./associate)          | Employees, resources and other users - except for External persons |
| [ticket\_status](./ticket-status) | This table user defined ticket status values.                      |
| [ticket\_type](./ticket-type)     | A ticket (request) type                                            |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [ticket_status table](/en/database/tables/ticket-status.md)
- [ticket_type table](/en/database/tables/ticket-type.md)
- [ticket_status_history table](/en/database/tables/ticket-status-history.md)
- [Ticket table](/en/api/bulk-operations/bulk-update/reference/ticket-table.md)
- [ticket table](/en/database/tables/ticket.md)
- [What's new in version 10.2.7.5452](/release-notes/database/changes-10.2.7.md)