product


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
assocprice.productId FKicmefryqsufau45tt3reripo7 R
assocprice_aud.productId Implied Constraint R
bomitem.productId Implied Constraint R
bomitem_aud.productId Implied Constraint R
customerparts.productId FKna1apak8us4xiisn316n0uhjl R
customerparts_aud.productId Implied Constraint R
kititem.kitProductId FKiijbe14ru0vm22ruoi64vs9ks R
kititem.productId FK8i2pu1q41ph3o0228k6sb68x5 R
kititem_aud.productId Implied Constraint R
kitoption.productId FKsm4io1laky3kn9sy1c4r6pm4f R
kitoption_aud.productId Implied Constraint R
part.defaultProductId FKd66hs7743k1fatmsronlq7l5v R
pricingrule.productInclId Implied Constraint R
pricingrule_aud.productInclId Implied Constraint R
producttotree.productId FKa7bd6t6993u4wtu3ltc4al8iu R
producttotree_aud.productId Implied Constraint R
quicklistitem.productId FKhe8s3qv7g3u6u7ihuxb34c4kc R
quicklistitem_aud.productId Implied Constraint R
rmaitem.productId FK422sbdwhwbqx2q2mh3pok8s3 R
rmaitem.productSubId FKn1iu90y8r0xlkset9273ami9t R
rmaitem_aud.productId Implied Constraint R
rmaitem_aud.productSubId Implied Constraint R
soitem.productId FKc5dwnwba96x78bb8pdleqddac R
soitem_aud.productId Implied Constraint R
accountingHash VARCHAR 30 √ null
accountingId VARCHAR 36 √ null
activeFlag BIT 1 null
alertNote VARCHAR 256 √ null
cartonCount DECIMAL 28,9 0.000000000
defaultCartonTypeId INT 10 √ null
cartontype.id FKcartonType R
dateCreated DATETIME 26 √ null
dateLastModified DATETIME 26 √ null
defaultSoItemType INT 10 null
soitemtype.id FKmpt7wmnpasu4xm9htvlx4tk2o R
description VARCHAR 252 √ null
details LONGTEXT 2147483647 √ null
displayTypeId INT 10 √ null
kitdisplaytype.id FKl6kuy56bo330inolrb9f6rwbq R
height DECIMAL 28,9 √ null
incomeAccountId INT 10 √ null
asaccount.id FKkouipxtdl8e1xm2cpojs2gqk R
kitFlag BIT 1 null
kitGroupedFlag BIT 1 null
len DECIMAL 28,9 √ null
num VARCHAR 70 null
partId INT 10 √ null
part.id FKj9v7tao0cke6neukmq70q0i14 R
price DECIMAL 28,9 √ null
qbClassId INT 10 √ null
qbclass.id FKj4pceg5l3atadp8o1ikbnl37f R
sellableInOtherUoms BIT 1 null
showSoComboFlag BIT 1 null
sizeUomId INT 10 √ null
uom.id FKqtt5lk0of46jkiqlfu1hqgvao R
sku VARCHAR 31 √ null
taxId INT 10 √ null
taxrate.id FKomhtsqhqgt8v81tmu4vjb3kuf R
taxableFlag BIT 1 null
uomId INT 10 null
uom.id FKexsq89d2vtabwkk78n5cku33o R
upc VARCHAR 31 √ null
url VARCHAR 256 √ null
usePriceFlag BIT 1 null
weight DECIMAL 28,9 √ null
weightUomId INT 10 √ null
uom.id FK7mm9b0j0rgdgiua6dbywitopj R
width DECIMAL 28,9 √ null
customFields JSON 1073741824 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK7mm9b0j0rgdgiua6dbywitopj Performance Asc weightUomId
FKcartonType Performance Asc defaultCartonTypeId
FKexsq89d2vtabwkk78n5cku33o Performance Asc uomId
FKj4pceg5l3atadp8o1ikbnl37f Performance Asc qbClassId
FKj9v7tao0cke6neukmq70q0i14 Performance Asc partId
FKkouipxtdl8e1xm2cpojs2gqk Performance Asc incomeAccountId
FKl6kuy56bo330inolrb9f6rwbq Performance Asc displayTypeId
FKmpt7wmnpasu4xm9htvlx4tk2o Performance Asc defaultSoItemType
FKomhtsqhqgt8v81tmu4vjb3kuf Performance Asc taxId
FKqtt5lk0of46jkiqlfu1hqgvao Performance Asc sizeUomId
ProductDescriptionIdx Performance Asc description
ProductNumIdx Performance Asc num
ProductShowSoComboFlagIdx Performance Asc showSoComboFlag
ProductSkuIdx Performance Asc sku
ProductUpcIdx Performance Asc upc
UK_pvbunwdwn8v8e5n6lt6wyghfg Must be unique Asc num

Relationships

Close relationships within degrees of separation