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

unique trouble ticket ID number

Author

varchar

person who wrote this note in the ticket

TicketNoteTime

dateTime

Timestamp identifying when the note was added

TicketNote

varchar

Contents of the ticket note

HiddenNote

int

0 if the note is visible. 1 if the note is hidden.