CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.
The DEFECTSOLUTION table stores the resolution information for a defect. This table is a child table to the DEFECT table.
table relationships
The DEFECTSOLUTION table has a (Many) to (One) relationship with the DEFECT table.
|
|
CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table. |
| Field | Datatype (Length) | Allow Nulls | Indexes |
|---|---|---|---|
|
DEFECTID(PK) (FK) |
STANDARDID(12) |
NOT NULL |
DEFECTSOLUTION_DEFECTID_PK (CA) |
|
NOTES |
TEXTBLOB(16) |
NULLS |
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|