The DEFECTHISTORY table stores history information, such as the field name that was changed, the old value of the field, the new value of the field, and notes that were entered by the user that made the change for a defect record.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
DEFECTHISID (PK) |
STANDARDID(12) |
NOT NULL |
DEFECTHISTORY_DEFECTHISID_PK (AK) |
|
|
|
DEFECTID (FK) |
STANDARDID(12) |
NULLS |
DEFECTHISTORY_DEFECTID (CA) |
(Many) to (One) |
|
|
FIELDNAME |
varchar(64) |
NULLS |
|
|
|
|
OLDVALUE |
varchar(255) |
NULLS |
|
|
|
|
NEWVALUE |
varchar(255) |
NULLS |
|
|
|
|
NOTE |
varchar(255) |
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 |
|
|
|