pricingrule_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FKr13divdm7gjs1c3hw1bgc5wts R
REVTYPE TINYINT 3 √ null
customerInclId INT 10 √ null
customer.id Implied Constraint R
customerInclTypeId INT 10 √ null
dateApplies BIT 1 √ null
dateBegin DATETIME 26 √ null
dateCreated DATETIME 26 √ null
dateEnd DATETIME 26 √ null
description LONGTEXT 2147483647 √ null
isActive BIT 1 √ null
isAutoApply BIT 1 √ null
isTier2 BIT 1 √ null
name VARCHAR 41 √ null
paAmount DECIMAL 28,9 √ null
paApplies BIT 1 √ null
paBaseAmountTypeId INT 10 √ null
pabaseamounttype.id Implied Constraint R
paPercent DECIMAL 28,9 √ null
paTypeId INT 10 √ null
patype.id Implied Constraint R
productInclId INT 10 √ null
product.id Implied Constraint R
productInclTypeId INT 10 √ null
qtyApplies BIT 1 √ null
qtyMax DECIMAL 28,9 √ null
qtyMin DECIMAL 28,9 √ null
rndApplies BIT 1 √ null
rndIsMinus BIT 1 √ null
rndPMAmount DECIMAL 28,9 √ null
rndToAmount DECIMAL 28,9 √ null
rndTypeId INT 10 √ null
rndtype.id Implied Constraint R
spcApplies BIT 1 √ null
spcBuyX INT 10 √ null
spcGetYFree INT 10 √ null
userId INT 10 √ null

Indexes

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

Relationships

Close relationships within degrees of separation