pricingrule


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
customerInclId INT 10 √ null
customer.id Implied Constraint R
customerInclTypeId INT 10 null
customerincltype.id FKo6vpn7dj74hauf25n0nt3jxq0 R
dateApplies BIT 1 null
dateBegin DATETIME 26 √ null
dateCreated DATETIME 26 √ null
dateEnd DATETIME 26 √ null
dateLastModified 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 FKqxhcagwiruywtpw5ynf7p8uag R
paPercent DECIMAL 28,9 √ null
paTypeId INT 10 √ null
patype.id FK9bjrykiwa7abl7nmoafr19io5 R
productInclId INT 10 √ null
product.id Implied Constraint R
productInclTypeId INT 10 null
productincltype.id FKejo1ljvdsav4eqqlwkt2poldy R
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 FKm5fhbvu9bqn2dbiirl213d1vb R
spcApplies BIT 1 null
spcBuyX INT 10 √ null
spcGetYFree INT 10 √ null
userId INT 10 null
sysuser.id FK9tlisi4j6au13jdu4x3bg0t85 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK9bjrykiwa7abl7nmoafr19io5 Performance Asc paTypeId
FK9tlisi4j6au13jdu4x3bg0t85 Performance Asc userId
FKejo1ljvdsav4eqqlwkt2poldy Performance Asc productInclTypeId
FKm5fhbvu9bqn2dbiirl213d1vb Performance Asc rndTypeId
FKo6vpn7dj74hauf25n0nt3jxq0 Performance Asc customerInclTypeId
FKqxhcagwiruywtpw5ynf7p8uag Performance Asc paBaseAmountTypeId
PricingRuleProductInclIdIdx Performance Asc productInclId
UKrt6jylcshd3siajamdd4632rx Must be unique Asc name

Relationships

Close relationships within degrees of separation