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.