kititem


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
kitoption.kitItemId FK73gtkri1fgjrxrapwq3kyttt1 R
kitoption_aud.kitItemId Implied Constraint R
dateCreated DATETIME 26 √ null
dateLastModified DATETIME 26 √ null
defaultQty DECIMAL 28,9 null
description VARCHAR 256 √ null
discountId INT 10 √ null
itemadjust.id FKciiikjl03nmgpmqpp45eat6qf R
kitItemTypeId INT 10 null
kititemtype.id FKnnq6wba83pk2qh7c2x8mhhbmk R
kitProductId INT 10 null
product.id FKiijbe14ru0vm22ruoi64vs9ks R
kitTypeId INT 10 null
kittype.id FKi8w84xt4bveufskomxkmc8lf R
maxQty DECIMAL 28,9 null
minQty DECIMAL 28,9 null
note LONGTEXT 2147483647 √ null
productId INT 10 √ null
product.id FK8i2pu1q41ph3o0228k6sb68x5 R
qtyPriceAdjustment DECIMAL 28,9 √ null
soItemTypeId INT 10 √ null
soitemtype.id FKjvl5i0ij32utt7baciv7nsfym R
sortOrder INT 10 √ null
taxRateId INT 10 √ null
taxrate.id FK69o19mjn68kqokl05iid361fu R
uomId INT 10 √ null
uom.id FKtjwqga0pi4rqkqidd27p24hj R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK69o19mjn68kqokl05iid361fu Performance Asc taxRateId
FK8i2pu1q41ph3o0228k6sb68x5 Performance Asc productId
FKciiikjl03nmgpmqpp45eat6qf Performance Asc discountId
FKi8w84xt4bveufskomxkmc8lf Performance Asc kitTypeId
FKiijbe14ru0vm22ruoi64vs9ks Performance Asc kitProductId
FKjvl5i0ij32utt7baciv7nsfym Performance Asc soItemTypeId
FKnnq6wba83pk2qh7c2x8mhhbmk Performance Asc kitItemTypeId
FKtjwqga0pi4rqkqidd27p24hj Performance Asc uomId

Relationships

Close relationships within degrees of separation