kititem_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FKgue87tf19wjb4x43w38da343t R
REVTYPE TINYINT 3 √ null
dateCreated DATETIME 26 √ null
defaultQty DECIMAL 28,9 √ null
description VARCHAR 256 √ null
discountId INT 10 √ null
kitItemTypeId INT 10 √ null
kitProductId INT 10 √ null
kitTypeId INT 10 √ null
kittype.id Implied Constraint R
maxQty DECIMAL 28,9 √ null
minQty DECIMAL 28,9 √ null
note LONGTEXT 2147483647 √ null
productId INT 10 √ null
product.id Implied Constraint R
qtyPriceAdjustment DECIMAL 28,9 √ null
soItemTypeId INT 10 √ null
sortOrder INT 10 √ null
taxRateId INT 10 √ null
taxrate.id Implied Constraint R
uomId INT 10 √ null
uom.id Implied Constraint R

Indexes

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

Relationships

Close relationships within degrees of separation