ticket_rel_def_ticket_type Table (546)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
Link table defining what Ticket types are involved in this relation. Will have M;N rows for a single relation definition
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| ticket_rel_def_ticket_type_id | Primary key | PK | |
| ticket_relation_def_id | Ticket relation definition | FK ticket_relation_def | |
| source_ticket_type_id | Ticket type | FK ticket_type | |
| destination_ticket_type_id | Ticket type | FK ticket_type |
Indexes
| Fields | Types | Description |
|---|---|---|
| ticket_rel_def_ticket_type_id | PK | Clustered, Unique |
| ticket_relation_def_id, source_ticket_type_id, destination_ticket_type_id | FK, FK, FK | Unique |
Relationships
| Table | Description |
|---|---|
| ticket_relation_def | Ticket relation definition |
| ticket_type | A ticket (request) type |
Replication Flags
- None
Security Flags
- No access control via user's Role.