vTicketField

Each ticket will have a set of fields associated with it.  Three of these fields are standard fields, status, priority, and category.  Also, a series of user fields can be added that will also be seen in this view.  Each field has a datatype.  All lists are stored as integer values.  The view vTicketField has the associated text for each list value.

Column Name

Type

Purpose

TicketID

int(10), null

unique trouble ticket ID number within a single partition.

TicketLabel

varchar(50), null

The label of the field

IntegerValue

int(10), null

The value of a integer field

NumberValue

numeric(15,4), null

The value of a number field

StringValue

varchar(500), null

The value of a string field

ListValue

varchar(50), null

The value of a list field