ticket_type_status table - SuperOffice

ticket_type_status Table (554)

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

Fields

Name	Description	Type	Nullable
ticket_type_status_id	Primary key	PK	No
ticket_type_id	Ticket type	FK ticket_type	No
ticket_status_id	Ticket status	FK ticket_status	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_status table relationship diagram

Indexes

Fields	Types	Description

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
ticket_status	This table user defined ticket status values.
ticket_type	A ticket (request) type

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

ticket_status table ticket_type table ticket_status_history table Ticket table ticket table What's new in version 10.2.7.5452

⌘I