| id_cart_rule |
int(10)
|
|
|
|
| id_customer |
int(10)
|
|
|
|
| date_from |
datetime
|
|
|
|
| date_to |
datetime
|
|
|
|
| description |
mediumtext
|
utf8mb4_general_ci
|
|
|
| quantity |
int(10)
|
|
|
|
| quantity_per_user |
int(10)
|
|
|
|
| priority |
int(10)
|
|
|
|
| partial_use |
tinyint(1)
|
|
|
|
| code |
varchar(254)
|
utf8mb4_general_ci
|
|
|
| minimum_amount |
decimal(20,6)
|
|
|
|
| minimum_amount_tax |
tinyint(1)
|
|
|
|
| minimum_amount_currency |
int(10)
|
|
|
|
| minimum_amount_shipping |
tinyint(1)
|
|
|
|
| country_restriction |
tinyint(1)
|
|
|
|
| carrier_restriction |
tinyint(1)
|
|
|
|
| group_restriction |
tinyint(1)
|
|
|
|
| cart_rule_restriction |
tinyint(1)
|
|
|
|
| product_restriction |
tinyint(1)
|
|
|
|
| shop_restriction |
tinyint(1)
|
|
|
|
| free_shipping |
tinyint(1)
|
|
|
|
| reduction_percent |
decimal(5,2)
|
|
|
|
| reduction_amount |
decimal(20,6)
|
|
|
|
| reduction_tax |
tinyint(1)
|
|
|
|
| reduction_currency |
int(10)
|
|
|
|
| reduction_product |
int(10)
|
|
|
|
| reduction_exclude_special |
tinyint(1)
|
|
|
|
| gift_product |
int(10)
|
|
|
|
| gift_product_attribute |
int(10)
|
|
|
|
| highlight |
tinyint(1)
|
|
|
|
| active |
tinyint(1)
|
|
|
|
| date_add |
datetime
|
|
|
|
| date_upd |
datetime
|
|
|
|
| id_cart_rule_type |
int(10)
|
|
|
|
| minimum_product_quantity |
int(10)
|
|
|
|