ticket_status_history table - SuperOffice

ticket_status_history Table (261)

This table contains the history of a tickets statuses. Each time a ticket changes status a copy of the previous status of the record will be saved

Fields

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
ticket_id	Reference to a ticket	FK ticket	No
ticket_status	User defined ticket status	FK ticket_status	No
timespan	The time (seconds) the ticket was in that status. Calculated based on priority's timeframe.	Int	Yes
real_timespan	The time (seconds) the ticket was in that status. Not calculated based on priority's timeframe.	Int	Yes
from_datetime		DateTime	Yes
to_datetime		DateTime	Yes

Indexes

Fields	Types	Description
ticket_id	FK	Index
ticket_status	FK	Index

Relationships

Table	Description
ticket	This table contains the tickets (requests) of the system. Its purpose should be evident.
ticket_status	This table user defined ticket status values.

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

ticket_status table ticket_type_status table ticket table History table History Save Histories

⌘I