| id_product |
int(10)
|
|
|
|
| id_supplier |
int(10)
|
|
|
|
| id_manufacturer |
int(10)
|
|
|
|
| id_tax |
int(10)
|
|
|
|
| id_category_default |
int(10)
|
|
|
|
| id_color_default |
int(10)
|
|
|
|
| on_sale |
tinyint(1)
|
|
|
|
| ean13 |
varchar(13)
|
utf8_general_ci
|
|
|
| ecotax |
decimal(10,2)
|
|
|
|
| quantity |
int(10)
|
|
|
|
| price |
decimal(13,6)
|
|
|
|
| wholesale_price |
decimal(13,6)
|
|
|
|
| reduction_price |
decimal(10,2)
|
|
|
|
| reduction_percent |
float
|
|
|
|
| reduction_from |
date
|
|
|
|
| reduction_to |
date
|
|
|
|
| reference |
varchar(32)
|
utf8_general_ci
|
|
|
| supplier_reference |
varchar(32)
|
utf8_general_ci
|
|
|
| location |
varchar(64)
|
utf8_general_ci
|
|
|
| weight |
float
|
|
|
|
| out_of_stock |
int(10)
|
|
|
|
| quantity_discount |
tinyint(1)
|
|
|
|
| customizable |
tinyint(2)
|
|
|
|
| uploadable_files |
tinyint(4)
|
|
|
|
| text_fields |
tinyint(4)
|
|
|
|
| active |
tinyint(1)
|
|
|
|
| indexed |
tinyint(1)
|
|
|
|
| date_add |
datetime
|
|
|
|
| date_upd |
datetime
|
|
|
|
