ticket_log_change table

ticket_log_change Table (268)

This table contains log entries for the tickets.

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
ticket_id	The id of the ticket this entry is connected to.	FK ticket	No
message_id	If this entry is connected to a message, then this is a message change log entry.	FK ej_message	No
action_id	The id of ticket_log_action this entry is connected to.	FK ticket_log_action	No
extra_field_id	The id of the extra_field this entry is connected to.	FK extra_fields	No
log_change	An enum indicating what kind of log-entry this is.	Int	Yes
to_value	A the 'to' value	String(255)	No
from_value	A the 'from' value	String(255)	No

Table	Description
ej_message	This table contains the messages listed under tickets.
extra_fields	This table contains entries for the extra fields in the system.
ticket	This table contains the tickets (requests) of the system. Its purpose should be evident.
ticket_log_action	This table contains actions for the tickets.