Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
| Campo | Tipo | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id_cart_rule | int(10) unsigned | NO | PRI | auto_increment | |
| id_customer | int(10) unsigned | NO | MUL | 0 | |
| date_from | datetime | NO | MUL | ||
| date_to | datetime | NO | MUL | ||
| description | mediumtext | YES | |||
| quantity | int(10) unsigned | NO | 0 | ||
| quantity_per_user | int(10) unsigned | NO | 0 | ||
| priority | int(10) unsigned | NO | 1 | ||
| partial_use | tinyint(1) unsigned | NO | 0 | ||
| code | varchar(254) | NO | |||
| minimum_amount | decimal(20,6) | NO | 0.000000 | ||
| minimum_amount_tax | tinyint(1) | NO | 0 | ||
| minimum_amount_currency | int(10) unsigned | NO | 0 | ||
| minimum_amount_shipping | tinyint(1) | NO | 0 | ||
| country_restriction | tinyint(1) unsigned | NO | 0 | ||
| carrier_restriction | tinyint(1) unsigned | NO | 0 | ||
| group_restriction | tinyint(1) unsigned | NO | MUL | 0 | |
| cart_rule_restriction | tinyint(1) unsigned | NO | 0 | ||
| product_restriction | tinyint(1) unsigned | NO | 0 | ||
| shop_restriction | tinyint(1) unsigned | NO | 0 | ||
| free_shipping | tinyint(1) | NO | 0 | ||
| reduction_percent | decimal(5,2) | NO | 0.00 | ||
| reduction_amount | decimal(20,6) | NO | 0.000000 | ||
| reduction_tax | tinyint(1) unsigned | NO | 0 | ||
| reduction_currency | int(10) unsigned | NO | 0 | ||
| reduction_product | int(10) | NO | 0 | ||
| reduction_exclude_special | tinyint(1) unsigned | NO | 0 | ||
| gift_product | int(10) unsigned | NO | 0 | ||
| gift_product_attribute | int(10) unsigned | NO | 0 | ||
| highlight | tinyint(1) unsigned | NO | 0 | ||
| active | tinyint(1) unsigned | NO | 0 | ||
| date_add | datetime | NO | |||
| date_upd | datetime | NO |