| id_product |
int(10)
|
|
|
|
| id_shop |
int(10)
|
|
|
|
| id_category_default |
int(10)
|
|
|
|
| id_tax_rules_group |
int(11)
|
|
|
|
| on_sale |
tinyint(1)
|
|
|
|
| online_only |
tinyint(1)
|
|
|
|
| ecotax |
decimal(17,6)
|
|
|
|
| minimal_quantity |
int(10)
|
|
|
|
| low_stock_threshold |
int(10)
|
|
|
|
| low_stock_alert |
tinyint(1)
|
|
|
|
| price |
decimal(20,6)
|
|
|
|
| wholesale_price |
decimal(20,6)
|
|
|
|
| unity |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| unit_price |
decimal(20,6)
|
|
|
|
| unit_price_ratio |
decimal(20,6)
|
|
|
|
| additional_shipping_cost |
decimal(20,6)
|
|
|
|
| customizable |
tinyint(2)
|
|
|
|
| uploadable_files |
tinyint(4)
|
|
|
|
| text_fields |
tinyint(4)
|
|
|
|
| active |
tinyint(1)
|
|
|
|
| redirect_type |
enum('404', '410', '301-product', '302-product', '301-category', '302-category', '200-displayed', '404-displayed', '410-displayed', 'default')
|
utf8mb4_general_ci
|
|
|
| id_type_redirected |
int(10)
|
|
|
|
| available_for_order |
tinyint(1)
|
|
|
|
| available_date |
date
|
|
|
|
| show_condition |
tinyint(1)
|
|
|
|
| condition |
enum('new', 'used', 'refurbished')
|
utf8mb4_general_ci
|
|
|
| show_price |
tinyint(1)
|
|
|
|
| indexed |
tinyint(1)
|
|
|
|
| visibility |
enum('both', 'catalog', 'search', 'none')
|
utf8mb4_general_ci
|
|
|
| cache_default_attribute |
int(10)
|
|
|
|
| advanced_stock_management |
tinyint(1)
|
|
|
|
| date_add |
datetime
|
|
|
|
| date_upd |
datetime
|
|
|
|
| pack_stock_type |
int(11)
|
|
|
|
