ticket_log table

ticket_log Table (267)

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
log_code	An enum indicating what kind of log-entry this is.	log_code	Yes
log_who	The username/alias of the user performing the action.	String(255)	Yes
log_when	When the action occured.	DateTime	Yes
log_description	A string describing the event (or part of such) to be logged.	Clob	Yes
log_what_value2	A reference to various tables, depending on the log_code.	Int	Yes

Table	Description
ticket	This table contains the tickets (requests) of the system. Its purpose should be evident.