vTicketNote
|
vTicketNote |
Trouble ticket notes are stored in the database. Each ticket summary can have multiple notes. There is a timestamp that identifies the order they were attached. |
|
|
Column Name |
Type |
Purpose |
|
TicketID |
int(10), null |
unique trouble ticket ID number |
|
author |
varchar(100), null |
person who wrote this note in the ticket |
|
TicketNoteTime |
datetime(3), not null |
Timestamp identifying when the note was added |
|
TicketNote |
varchar(2000), not null |
Contents of the ticket note |
|
HiddenNote |
int(10), not null |
0 if the note is visible. 1 if the note is hidden. |
|
partitionId |
numeric(26,0), not null |
Tenant identifier. |
|
CreationDate |
datetime(3), null |
The date/time the ticket was created. |
|
DueDate |
datetime(3), null |
The due date of the ticket. |
