product_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FKoovhds11g6rc5g75l9dx1utfs R
REVTYPE TINYINT 3 √ null
accountingHash VARCHAR 30 √ null
accountingId VARCHAR 36 √ null
activeFlag BIT 1 √ null
alertNote VARCHAR 256 √ null
cartonCount DECIMAL 28,9 √ null
defaultCartonTypeId INT 10 √ null
dateCreated DATETIME 26 √ null
defaultSoItemType INT 10 √ null
description VARCHAR 252 √ null
details LONGTEXT 2147483647 √ null
displayTypeId INT 10 √ null
height DECIMAL 28,9 √ null
incomeAccountId INT 10 √ null
kitFlag BIT 1 √ null
kitGroupedFlag BIT 1 √ null
len DECIMAL 28,9 √ null
num VARCHAR 70 √ null
partId INT 10 √ null
part.id Implied Constraint R
price DECIMAL 28,9 √ null
qbClassId INT 10 √ null
qbclass.id Implied Constraint R
sellableInOtherUoms BIT 1 √ null
showSoComboFlag BIT 1 √ null
sizeUomId INT 10 √ null
sku VARCHAR 31 √ null
taxId INT 10 √ null
taxableFlag BIT 1 √ null
uomId INT 10 √ null
uom.id Implied Constraint R
upc VARCHAR 31 √ null
url VARCHAR 256 √ null
usePriceFlag BIT 1 √ null
weight DECIMAL 28,9 √ null
weightUomId INT 10 √ null
width DECIMAL 28,9 √ null
customFields JSON 1073741824 √ null

Indexes

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

Relationships

Close relationships within degrees of separation