The TICKETHISTORY table stores information on the chronological account of actions taken on a selected ticket. The information includes the Ticket ID, Field Name that changed, the Old Value and New Values of the Field that changed, and any notes entered by the user.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
TICKETHISID (PK) |
STANDARDID(12) |
NOT NULL |
TICKETHISTORY_TICKERHISID (AK) |
|
|
|
TICKETID (FK) |
STANDARDID(12) |
NOT NULL |
TICKETHISTORY_TICKETID (CA) |
(Many) to (One) |
|
|
FIELDNAME |
varchar(64) |
NULLS |
|
|
|
|
OLDVALUE |
varchar(255) |
NULLS |
|
|
|
|
NEWVALUE |
varchar(255) |
NULLS |
|
|
|
|
NOTE |
varchar(255) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|