ticket_relation table - SuperOffice

ticket_relation Table (557)

A relation between 2 tickets

Fields

Name	Description	Type	Nullable
ticket_relation_id	Primary key	PK	No
source_ticket_id	Source ticket in this relation	FK ticket	No
destination_ticket_id	Destination ticket in this relation	FK ticket	No
ticket_relation_def_id	The (optional) relation definition where this relation originated from	FK ticket_relation_def	No
comment	Comment for relation	String(255)	Yes
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_relation table relationship diagram

Indexes

Fields	Types	Description
source_ticket_id	FK	Index
destination_ticket_id	FK	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
ticket	This table contains the tickets (requests) of the system. Its purpose should be evident.
ticket_relation_def	Ticket relation definition

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

ticket_relation_def table Put Ticket Relation Entity Post Ticket Relation Entity Default Ticket Relation Entity Get Ticket Relation Entity Post Ticket Relation Definition Entity