The TICKET table stores general information about tickets. Tickets are records of customer inquiries or complaints and can contain information necessary to report, investigate, and close an inquiry or problem. The TICKET table has many related tables.
|
|
|
|
|
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
TICKETID (PK) |
STANDARDID(12) |
NOT NULL |
TICKET_TICKETID_PK (AK) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (One) |
|||||
|
(One) to (One) |
|||||
|
ACCOUNTID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
URGENCYCODE |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
STANDARDSOLUTIONID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CONTRACTID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
STANDARDPROBLEMID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
RECEIVEDDATE |
datetime(8) |
NULLS |
|
|
|
|
RECEIVEDBYID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
WEIGHTCODE |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
PRIORITY |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
ASSIGNEDTOID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
ASSIGNEDDATE |
datetime(8) |
NULLS |
|
|
|
|
NEEDEDBYDATE |
datetime(8) |
NULLS |
|
|
|
|
COMPLETEDBYID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
COMPLETEDDATE |
datetime(8) |
NULLS |
|
|
|
|
CLOSED |
BOOLEAN(1) |
NULLS |
|
|
|
|
FIRST |
BOOLEAN(1) |
NULLS |
|
|
|
|
STATUSCODE |
STANDARDID(12) |
NULLS |
|
|
unknown |
|
ALERT |
BOOLEAN(1) |
NULLS |
|
|
|
|
INCIDENTUSED |
BOOLEAN(1) |
NULLS |
|
|
|
|
ADDKNOWLEDGE |
BOOLEAN(1) |
NULLS |
|
|
|
|
VIACODE |
STANDARDID(12) |
NULLS |
|
|
unknown |
|
CONTACTID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
USERFIELD1 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD2 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD3 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD4 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD5 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD6 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD7 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD8 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD9 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD10 |
varchar(80) |
NULLS |
|
|
|
|
ALTERNATEKEYPREFIX |
varchar(8) |
NULLS |
TICKET_COMPOSITE (IE) |
|
|
|
ALTERNATEKEYSUFFIX |
varchar(24) |
NULLS |
TICKET_COMPOSITE (IE) |
|
|
|
AREA |
varchar(64) |
NULLS |
|
|
|
|
CATEGORY |
varchar(64) |
NULLS |
|
|
|
|
ISSUE |
varchar(64) |
NULLS |
|
|
|
|
NOTES |
TEXTBLOB(16) |
NULLS |
|
|
|
|
ALERTID (FK) |
STANDARDID(12) |
NULLS |
|
(One) to (Many) |
|
|
SECCODEID (FK) |
STANDARDID(12) |
NOT NULL |
TICKET_SECCODEID (CA) |
(Many) to (One) |
|
|
URGENCYID (FK) |
STANDARDID(12) |
NULLS |
|
(One) to (Many) |
|
|
CLOSEDONFIRST |
BOOLEAN(1) |
NULLS |
|
|
|
|
PUBLICACCESSCODE |
char(12) |
NULLS |
|
|
unknown |
|
SUBJECT |
varchar(255) |
NULLS |
|
|
|
|
SUBMITSEARCH |
char(1) |
NULLS |
|
|
|
|
ACCOUNTPRODUCTID (FK) |
char(12) |
NULLS |
|
(One) to (Many) |
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
