xoitem_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FKqth4qeqbwb8o24bedm5mo5rm0 R
REVTYPE TINYINT 3 √ null
dateLastFulfillment DATETIME 26 √ null
dateScheduledFulfillment DATETIME 26 √ null
description VARCHAR 256 √ null
lineItem INT 10 √ null
note LONGTEXT 2147483647 √ null
partId INT 10 √ null
part.id Implied Constraint R
partNum VARCHAR 70 √ null
qtyFulfilled DECIMAL 28,9 √ null
qtyPicked DECIMAL 28,9 √ null
qtyToFulfill DECIMAL 28,9 √ null
revisionNum INT 10 √ null
statusId INT 10 √ null
totalCost DECIMAL 28,9 √ null
typeId INT 10 √ null
uomId INT 10 √ null
uom.id Implied Constraint R
xoId INT 10 √ null
xo.id Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc id + REV
FKqth4qeqbwb8o24bedm5mo5rm0 Performance Asc REV

Relationships

Close relationships within degrees of separation