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

> Ticket relation definition

## ticket\_relation\_def Table (555)

Ticket relation definition

## Fields

| Name                           | Description                                                | Type                                                      | Nullable |
| ------------------------------ | ---------------------------------------------------------- | --------------------------------------------------------- | :------: |
| ticket\_relation\_def\_id      | Primary key                                                | PK                                                        |    No    |
| name                           | The name of this Ticket relation                           | String(4000)                                              |    No    |
| description                    | Tooltip or other description                               | String(4000)                                              |    Yes   |
| rank                           | Rank order                                                 | UShort                                                    |    Yes   |
| relation\_type                 | Type of the relation (Related, Parent, Child)              | Enum [TicketRelationType](./enums/ticketrelationtype.mdx) |    No    |
| is\_parent\_mandatory          | Parent relation is mandatory when a new request is created | Bool                                                      |    Yes   |
| is\_close\_parent\_with\_child | Close parent when all children are closed                  | Bool                                                      |    Yes   |
| is\_prevent\_closing\_parent   | Prevent closing parent until all children are closed       | Bool                                                      |    Yes   |
| is\_close\_with\_parent        | Offer to close all related when parent is closed           | Bool                                                      |    Yes   |
| 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    |
| isBuiltIn                      | Is this row part of SuperOffice priming data               | Bool                                                      |    Yes   |

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

## Indexes

| Fields | Types        | Description |
| ------ | ------------ | ----------- |
| name   | String(4000) | Unique      |

## Relationships

| Table                                                          | Description                                                                                                              |
| -------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------ |
| [associate](./associate)                                       | Employees, resources and other users - except for External persons                                                       |
| [ticket\_rel\_def\_ticket\_type](./ticket-rel-def-ticket-type) | Link table defining what Ticket types are involved in this relation. Will have M:N rows for a single relation definition |
| [ticket\_relation](./ticket-relation)                          | A relation between 2 tickets                                                                                             |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [ticket_relation table](/en/database/tables/ticket-relation.md)
- [ticket_rel_def_ticket_type table](/en/database/tables/ticket-rel-def-ticket-type.md)
- [SuperOffice.WebApi.Data.TicketRelationDefinitionEntity](/en/api/reference/webapi/SuperOffice.WebApi.Data.TicketRelationDefinitionEntity.md)
- [Default Ticket Relation Definition Entity](/en/api/reference/restful/rest/ticketrelationdefinition/default-ticket-relation-definition-entity.md)
- [Post Ticket Relation Definition Entity](/en/api/reference/restful/rest/ticketrelationdefinition/post-ticket-relation-definition-entity.md)
- [Put Ticket Relation Definition Entity](/en/api/reference/restful/rest/ticketrelationdefinition/put-ticket-relation-definition-entity.md)