ticket_type_priority table - SuperOffice

ticket_type_priority Table (553)

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

Fields

Name	Description	Type	Nullable
ticket_type_priority_id	Primary key	PK	No
ticket_type_id	Ticket type	FK ticket_type	No
ticket_priority_id	Ticket priority	FK ticket_priority	No
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

ticket_type_priority table relationship diagram

Indexes

Fields	Types	Description

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
ticket_priority	This table contains the ticket priorities.
ticket_type	A ticket (request) type

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

ticket_priority table ticket_type table Get Ticket Priorities Get Ticket Priority Ticket table Get Ticket Priority List

⌘I