bomitem_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FK8hjablrpk36hlr44c9jj306av R
REVTYPE TINYINT 3 √ null
addToService BIT 1 √ null
bomId INT 10 √ null
bom.id Implied Constraint R
bomItemGroupId INT 10 √ null
description VARCHAR 256 √ null
groupDefault BIT 1 √ null
maxQty DECIMAL 28,9 √ null
minQty DECIMAL 28,9 √ null
oneTimeItem BIT 1 √ null
partId INT 10 √ null
part.id Implied Constraint R
priceAdjustment DECIMAL 28,9 √ null
productId INT 10 √ null
product.id Implied Constraint R
quantity DECIMAL 28,9 √ null
sortIdConfig INT 10 √ null
stage BIT 1 √ null
stageBomId INT 10 √ null
typeId INT 10 √ null
uomId INT 10 √ null
uom.id Implied Constraint R
useItemLocation BIT 1 √ null
variableQty BIT 1 √ null
customFields JSON 1073741824 √ null

Indexes

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

Relationships

Close relationships within degrees of separation