ticket_relation_def Table (546)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
Ticket relation definition
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| ticket_relation_def_id | Primary key | PK | |
| name | The name of this Ticket relation | String(4000) | |
| description | Tooltip or other description | String(4000) | ● |
| rank | Rank order | UShort | ● |
| relation_type | Type of the relation (Related, Parent, Child) | Enum TicketRelationType | |
| is_parent_mandatory | Parent relation is mandatory when a new request is created | Bool | ● |
| is_close_parent_with_child | Close parent when all children are closed | Bool | ● |
| is_prevent_closing_parent | Prevent closing parent until all children are closed | Bool | ● |
| is_close_with_parent | Offer to close all related when parent is closed | Bool | ● |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort | |
| isBuiltIn | Is this row part of SuperOffice priming data | Bool | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| name | String(4000) | Unique |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| 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 | A relation between 2 tickets |
Replication Flags
- None
Security Flags
- No access control via user's Role.