The TICKETPROBLEM table stores the problem description for a Ticket. The TICKETPROBLEM table is a child to the parent table TICKET.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
TICKETID (PK) (FK) |
STANDARDID(12) |
NOT NULL |
TICKETPROBLEM_TICKETID_PK (CA) |
(One) to (One) |
|
|
NOTES |
TEXTBLOB(16) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|