vTicketField
|
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 |
