shipitem_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FKjqfmu2t5leterf5gd1gfp91wa R
REVTYPE TINYINT 3 √ null
itemId INT 10 √ null
orderId INT 10 √ null
orderTypeId INT 10 √ null
ordertype.id Implied Constraint R
poItemId INT 10 √ null
qtyShipped DECIMAL 28,9 √ null
shipCartonId INT 10 √ null
shipId INT 10 √ null
ship.id Implied Constraint R
soItemId INT 10 √ null
tagId BIGINT 19 √ null
tag.id Implied Constraint R
totalCost DECIMAL 28,9 √ null
uomId INT 10 √ null
uom.id Implied Constraint R
xoItemId INT 10 √ null

Indexes

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

Relationships

Close relationships within degrees of separation