ticket_rel_def_ticket_type table - SuperOffice

ticket_rel_def_ticket_type Table (556)

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	Nullable
ticket_rel_def_ticket_type_id	Primary key	PK	No
ticket_relation_def_id	Ticket relation definition	FK ticket_relation_def	No
source_ticket_type_id	Ticket type	FK ticket_type	No
destination_ticket_type_id	Ticket type	FK ticket_type	No

Indexes

Fields	Types	Description
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.

Related topics

ticket_relation_def table ticket_type table ticket_type_priority table ticket_type_status table ticket_relation table Default Ticket Relation Entity

⌘I