Customers and Statistics
Orders
gender guest web_browser
id_web_browser INT(10) name VARCHAR(64) name VARCHAR(64) Indexes id_customer INT(10) id_customer INT(10) Indexes id_customer INT(10) id_employee INT(10) id_order INT(10) id_order INT(10) message TEXT private TINYINT(1) date_add DATETIME date_add DATETIME Indexes id_manufacturer INT(10) id_supplier INT(10) alias VARCHAR(32) company VARCHAR(32) company VARCHAR(32) lastname VARCHAR(32) firstname VARCHAR(32) address1 VARCHAR(128) address1 VARCHAR(128) address2 VARCHAR(128) postcode VARCHAR(12) city VARCHAR(64) city VARCHAR(64) other TEXT phone VARCHAR(16) phone VARCHAR(16) phone_mobile VARCHAR(16) date_add DATETIME date_upd DATETIME date_upd DATETIME active TINYINT(1) deleted TINYINT(1) Indexes Indexes id_state INT(10) name VARCHAR(16) name VARCHAR(16) id_cart INT(10) id_country INT(10) iso_code TINYINT(3) iso_code TINYINT(3) id_message INT(10) id_message INT(10) id_address INT(10) id_address INT(10) id_gender INT(10)
address address message message
id_order INT(10) id_order INT(10) id_carrier INT(10) id_lang INT(10)
orders orders
order_history
order_state
order_st order_st
id_guest INT(10) id_operating_system INT(10) id_web_browser INT(10) id_web_browser INT(10) id_customer INT(10) javascript TINYINT(1)
id_order_history INT(10)
id_order_state INT(10)
id_order_sta id_order_sta
id_employee INT(10)
invoice TINYINT(1)
id_lang INT(
id_customer INT(10) id_customer INT(10) id_cart INT(10) id_currency INT(10) id_address_delivery INT(10) id_address_delivery INT(10) id_address_invoice INT(10) secure_key VARCHAR(32) payment VARCHAR(64) payment VARCHAR(64) module VARCHAR(32) recyclable TINYINT(1) gift TINYINT(1) gift_message TEXT gift_message TEXT total_discounts DECIMAL(10,2)
id_order INT(10) id_order INT(10)
send_email TINYINT(1) send_email TINYINT(1)
name VARCH
id_order_state INT(10)
color VARCHAR(32)
template VAR template VAR
customer
id_customer INT(10)
date_add DATETIME
unremovable TINYINT(1)
Indexes
screen_resolution_x SMALLINT(5) screen_resolution_x SMALLINT(5) screen_resolution_y SMALLINT(5)
Indexes Indexes
logable TINYINT(1)
delivery TINYINT(1) delivery TINYINT(1)
operating_system
id_gender INT(10) secure_key VARCHAR(32) secure_key VARCHAR(32) email VARCHAR(128) passwd VARCHAR(32) last_passwd_gen TIMESTAMP last_passwd_gen TIMESTAMP birthday DATE lastname VARCHAR(32) newsletter TINYINT(1) newsletter TINYINT(1) ip_registration_newsletter VARCHAR(15) ip_registration_newsletter VARCHAR(15) optin TINYINT(1) firstname VARCHAR(32) active TINYINT(1) active TINYINT(1) date_add DATETIME date_upd DATETIME Indexes Indexes id_operating_system INT(10) name VARCHAR(64) name VARCHAR(64) Indexes
screen_color TINYINT(3) sun_java TINYINT(1) sun_java TINYINT(1) adobe_flash TINYINT(1) adobe_director TINYINT(1) apple_quicktime TINYINT(1) real_player TINYINT(1) real_player TINYINT(1) windows_media TINYINT(1) accept_language VARCHAR(8) Indexes Indexes
Indexes
order_detail order_detail
id_order_detail INT(10) id_order_detail INT(10)
shipping_number VARCHAR(32)
id_order INT(10)
order_discount order_discount
product_id INT(10)
id_order_discount INT(10) id_order_discount INT(10)
cart_discount
id_cart INT(10) id_discount INT(10) id_discount INT(10) Indexes
total_paid DECIMAL(10,2) total_paid DECIMAL(10,2) total_paid_real DECIMAL(10,2) total_products DECIMAL(10,2) total_shipping DECIMAL(10,2) total_shipping DECIMAL(10,2) total_wrapping DECIMAL(10,2) invoice_number INT(10) delivery_number INT(10) delivery_number INT(10) invoice_date DATETIME delivery_date DATETIME
product_attribute_id INT(10) product_attribute_id INT(10)
id_order INT(10)
product_name VARCHAR(255)
id_discount INT(10)
product_quantity INT(10)
name VARCHAR(32) name VARCHAR(32)
product_quantity_return INT(10)
value DECIMAL(10,2)
product_price DECIMAL(13,6) product_price DECIMAL(13,6)
Indexes
product_quantity_discount DECIMAL(13,6)
connections
id_connections INT(10) id_guest INT(10) id_guest INT(10) id_page INT(10) ip_address VARCHAR(16) counter INT(10) id_date_range INT(10) id_page INT(10) id_page INT(10)
product_ean13 VARCHAR(13)
page_viewed page_viewed
product_reference VARCHAR(32) product_reference VARCHAR(32)
product_supplier_reference VARCHAR(32) date_add DATETIME date_add DATETIME
product_weight FLOAT
date_range
id_date_range INT(10) time_start DATETIME time_end DATETIME time_end DATETIME Indexes
cart
id_cart INT(10) id_carrier INT(10) id_carrier INT(10) id_lang INT(10) id_lang INT(10) id_address_delivery INT(10) id_address_invoice INT(10) id_currency INT(10) id_currency INT(10) id_customer INT(10) recyclable TINYINT(1)
date_add DATETIME date_add DATETIME http_referer VARCHAR(256) Indexes
Indexes Indexes
date_upd DATETIME Indexes
tax_name VARCHAR(16) tax_name VARCHAR(16)
order_slip
tax_rate DECIMAL(10,2)
id_order_slip INT(10)
ecotax DECIMAL(10,2)
id_customer INT(10) id_customer INT(10)
download_hash VARCHAR(255) download_hash VARCHAR(255)
id_order INT(10) id_order INT(10)
cart_product
id_cart INT(10) id_product INT(10) id_product INT(10) id_product_attribute INT(10) quantity INT(10) gift TINYINT(1) gift TINYINT(1) gift_message TEXT date_add DATETIME date_upd DATETIME date_upd DATETIME Indexes Indexes Indexes
download_nb INT(10)
shipping_cost TINYINT(3)
download_deadline DATETIME
date_add DATETIME
deleted TINYINT(3) deleted TINYINT(3)
date_upd DATETIME
Indexes
Indexes
connections_page connections_page page page
id_page INT(10) id_page INT(10) id_page_type INT(10) id_object VARCHAR(256) Indexes Indexes Indexes name VARCHAR(256) id_page_type INT(10) id_connections INT(10) id_connections INT(10) id_page INT(10) time_start DATETIME time_end DATETIME Indexes
page_type
Carriers and Localization
Products
carrier_lang
id_carrier INT(10) id_lang INT(10)
lang
id_lang INT(10) name VARCHAR(32)
carrier carrier
id_carrier INT(10) id_carrier INT(10) id_tax INT(10) name VARCHAR(64)
delay VARCHAR(128) delay VARCHAR(128) Indexes
attribute_group_lang attribute_group_lang
active TINYINT(3) iso_code CHAR(2)
id
id_attribute_group INT(10) id_attribute_group INT(10)
id
tax_lang
id_tax INT(10) url VARCHAR(255) url VARCHAR(255) active TINYINT(1) deleted TINYINT(1) shipping_handling TINYINT(1) shipping_handling TINYINT(1) range_behavior TINYINT(1) Indexes id_lang INT(10) name VARCHAR(32) name VARCHAR(32)
id_lang INT(10) id_lang INT(10) Indexes
Inde Inde
name VARCHAR(128)
zone
id_zone INT(10) name VARCHAR(64) active TINYINT(1) enabled TINYINT(1) enabled TINYINT(1) Indexes Indexes Indexes id_zone INT(10) id_carrier INT(10)
public_name VARCHAR(64)
carrier_zone
Indexes Indexes
tax tax
id_tax INT(10) id_tax INT(10) rate FLOAT Indexes Indexes
Indexes
Discounts
attribute_i attribute_i discount_lang
id_discount INT(10) id_lang INT(10) id_lang INT(10) description TEXT
discount_type_lang
attribute_group
id_attribute_im id_attribute_im
id_discount_type INT(10)
id_attribute_group INT(10)
id_product INT(
id_lang INT(10) Indexes Indexes Indexes
is_color_group TINYINT(1) is_color_group TINYINT(1)
id_attribute INT
name VARCHAR(64)
Indexes
weight FLOAT weight FLOAT
country
id_country INT(10) id_country INT(10) id_zone INT(10) iso_code VARCHAR(3) active TINYINT(1) active TINYINT(1) contains_states TINYINT(1) Indexes
price DECIMAL(
Indexes
tax_state tax_state country_lang
id_country INT(10) id_lang INT(10) name VARCHAR(64) name VARCHAR(64) Indexes id_tax INT(10)
tax_zone
id_tax INT(10)
delivery
id_delivery INT(10) id_carrier INT(10) id_range_price INT(10) id_range_weight INT(10) id_range_weight INT(10) id_zone INT(10) price DECIMAL(10,2) Indexes Indexes
discount_type discount_type
id_state INT(10) id_state INT(10) Indexes id_zone INT(10) Indexes Indexes Indexes
id_discount_type INT(10) id_discount_type INT(10)
attribute_lang discount
id_discount INT(10) id_discount_type INT(10) id_customer INT(10) id_customer INT(10) name VARCHAR(32)
attribut
id_attribute INT(10)
id_attribute id_attribute
id_lang INT(10)
id_attribute
discount_category currency currency state state
id_currency INT(10) value DECIMAL(10,2) quantity INT(10) quantity INT(10) quantity_per_user INT(10)
name VARCHAR(128) name VARCHAR(128)
color VARC
id_discount INT(11) Indexes
Indexes
Indexes Indexes
id_category INT(11) id_category INT(11)
Modules
er_state_lang er_state_lang
er_state INT(10) er_state INT(10) g INT(10) VARCHAR(64) ate VARCHAR(64) ate VARCHAR(64) s position TINYINT(1) description TEXT description TEXT Indexes Indexes Indexes title VARCHAR(64) position TINYINT(2) position TINYINT(2) id_currency INT(11) id_currency INT(11) name VARCHAR(64) id_hook INT(10) id_module INT(10) id_hook INT(10) id_hook INT(10) id_module INT(10)
hook hook hook_module module_currency
order_return_detail
id_order_return INT(10) id_order_detail INT(10) id_order_detail INT(10) product_quantity INT(10) Indexes active INT(10) Indexes Indexes name VARCHAR(64) id_module INT(10) id_module INT(10)
module module
hook_module_exceptions
id_hook_module_exceptions INT(10) id_module INT(10) id_module INT(10)
order_return
id_order_return INT(10) id_customer INT(10) id_order INT(10) id_order INT(10) state TINYINT(1) question TEXT date_add DATETIME date_upd DATETIME Indexes
Back Office
module_country
id_module INT(10) id_country INT(10) id_country INT(10) Indexes
order_return_state_lang order_return_state_lang
id_hook INT(10) file_name VARCHAR(255) Indexes Indexes id_order_return_state INT(10) id_order_return_state INT(10) id_lang INT(10) name VARCHAR(64) Indexes Indexes
order_return_state employee employee access access
id_profile INT(10) id_profile INT(10) id_tab INT(10) view INT(11) add INT(11) edit INT(11) edit INT(11) delete INT(11) Indexes id_employee INT(10) id_profile INT(10) lastname VARCHAR(32) firstname VARCHAR(32) firstname VARCHAR(32) email VARCHAR(128) passwd VARCHAR(32) last_passwd_gen TIMESTAMP last_passwd_gen TIMESTAMP active TINYINT(1) Indexes id_order_return_state INT(10) color VARCHAR(32) Indexes Indexes
profile profile
id_profile INT(10) Indexes
profile_lang
id_lang INT(10) id_profile INT(10) id_profile INT(10) name VARCHAR(128) Indexes
order_slip_detail
id_order_slip INT(10) id_order_detail INT(10) id_order_detail INT(10) product_quantity INT(10) Indexes
quick_access
id_quick_access INT(10) new_window TINYINT(1) link VARCHAR(128) link VARCHAR(128) Indexes
tab tab order_message_lang order_message_lang
id_order_message INT(10) id_lang INT(10) id_lang INT(10) id_tab INT(10) name VARCHAR(32) Indexes
tab_lang tab_lang
id_tab INT(10) id_parent INT(11) class_name VARCHAR(64) class_name VARCHAR(64) position INT(10) Indexes
quick_access_lang
id_quick_access INT(10) id_lang INT(10) name VARCHAR(32) Indexes Indexes
order_message
id_lang INT(10) name VARCHAR(128) message TEXT message TEXT Indexes id_order_message INT(10) date_add DATETIME Indexes
customization_field product_attribute_combination category_lang category_lang
id_category INT(10) id_category INT(10) id_lang INT(10) name VARCHAR(128) description TEXT description TEXT link_rewrite VARCHAR(128) meta_title VARCHAR(128) meta_keywords VARCHAR(128) meta_keywords VARCHAR(128) meta_description VARCHAR(128) id_attribute INT(10) id_product_attribute INT(10) Indexes Indexes id_customization_field INT(10) id_product INT(10) type TINYINT(1) required TINYINT(1) required TINYINT(1) Indexes
customized_data customized_data
id_customization INT(10) id_customization INT(10) type TINYINT(1) index INT(3) value VARCHAR(255) value VARCHAR(255) Indexes
customization_field_lang
Indexes id_customization_field INT(10) id_lang INT(10) id_lang INT(10) name VARCHAR(255) Indexes
ute_impact ute_impact
ute_impact INT(11) ute_impact INT(11) ct INT(11) ute INT(11) LOAT LOAT CIMAL(10,2) ean13 VARCHAR(13) wholesale_price DECIMAL(13,6) wholesale_price DECIMAL(13,6) price DECIMAL(10,2) ecotax DECIMAL(10,2) quantity INT(10) quantity INT(10) weight FLOAT default_on TINYINT(1) Indexes Indexes reference VARCHAR(32) reference VARCHAR(32) supplier_reference VARCHAR(32) id_product INT(10) id_image INT(10) id_product_attribute INT(10)
product_attribute product_attribute
customization
id_customization INT(10) id_customization INT(10) id_product_attribute INT(10) id_cart INT(10) id_product INT(10) Indexes Indexes
category
id_category INT(10) id_parent INT(10) level_depth TINYINT(3) level_depth TINYINT(3) active TINYINT(1) date_add DATETIME date_upd DATETIME date_upd DATETIME Indexes
category_product category_product
id_category INT(10) id_category INT(10) id_product INT(10) position INT(10) Indexes
ttribute
ttribute INT(10) ttribute INT(10) ttribute_group INT(10) r VARCHAR(32) es es
supplier supplier
id_supplier INT(10) id_supplier INT(10) name VARCHAR(64)
product_lang product_lang
id_product INT(10) id_product INT(10) id_lang INT(10)
date_add DATETIME date_upd DATETIME date_upd DATETIME Indexes
state
id_currency INT(10) id_currency INT(10) name VARCHAR(32) quantity_per_user INT(10) cumulable TINYINT(1) cumulable TINYINT(1) cumulable_reduction TINYINT(1) date_from DATETIME date_to DATETIME date_to DATETIME minimal DECIMAL(10,2) active TINYINT(1) Indexes Indexes quantity INT(10) id_state INT(10) id_country INT(11) id_zone INT(11) id_zone INT(11) id_range_weight INT(10) id_range_weight INT(10) id_carrier INT(10) id_range_price INT(10) id_range_price INT(10) id_carrier INT(10) delimiter1 FLOAT delimiter2 FLOAT Indexes Indexes deleted TINYINT(1) Indexes Indexes conversion_rate DECIMAL(13,6) decimals TINYINT(1) decimals TINYINT(1) format TINYINT(1) delimiter1 DECIMAL(13,6) delimiter2 DECIMAL(13,6) Indexes Indexes blank TINYINT(1) name VARCHAR(64) iso_code VARCHAR(3) tax_behavior SMALLINT(1) tax_behavior SMALLINT(1) active TINYINT(1) Indexes
Indexes
range_weight range_weight
iso_code VARCHAR(3)
discount_quantity discount_quantity
range_price range_price
sign VARCHAR(8) sign VARCHAR(8)
id_discount_quantity INT(10) id_discount_quantity INT(10)
id_discount_type INT(10)
product_download product_download
scene
id_product INT(10)
id_product_download INT(10) id_product_download INT(10)
id_scene INT(
id_product_attribute INT(10)
id_product INT(10)
active TINYIN
quantity INT(10) quantity INT(10) Indexes
display_filename VARCHAR(255)
Indexes Indexes
value DECIMAL(10,2)
physically_filename VARCHAR(255) physically_filename VARCHAR(255)
date_deposit DATETIME
date_expiration DATETIME
scene_produ
nb_days_accessible INT(10)
Website Configuration Contacts
id_scene INT(10)
nb_downloadable INT(10) nb_downloadable INT(10)
id_product INT(10
active TINYINT(1)
x_axis INT(4) x_axis INT(4)
Indexes
y_axis INT(4)
meta_lang meta
id_meta INT(10) id_lang INT(10) id_configuration INT(10) id_lang INT(10) value TEXT value TEXT date_upd DATETIME Indexes Indexes title VARCHAR(255) title VARCHAR(255) description VARCHAR(255) keywords VARCHAR(255) Indexes Indexes page VARCHAR(64) page VARCHAR(64) Indexes id_meta INT(10)
zone_width INT(3
configuration_lang
zone_height INT( zone_height INT(
contact_lang
id_lang INT(10) id_lang INT(10) description TEXT Indexes Indexes
Indexes
id_contact INT(10)
subdomain
id_subdomain INT(10) name VARCHAR(16) name VARCHAR(16) Indexes
name VARCHAR(32)
feature_lang
id_feature INT(10)
id_lang INT(10) id_lang INT(10)
name VARCHAR(128)
feature
Indexes
id_feature INT(1
Indexes Indexes
cms_lang block_cms block_cms
id_cms INT(10) Indexes Indexes meta_description VARCHAR(255) meta_keywords VARCHAR(255) meta_keywords VARCHAR(255) content TEXT link_rewrite VARCHAR(128) Indexes Indexes meta_title VARCHAR(128) id_lang INT(10) id_lang INT(10) id_block INT(10) id_cms INT(10) id_cms INT(10) Indexes
cms cms
id_cms INT(10)
configuration
id_configuration INT(10) name VARCHAR(32) value TEXT value TEXT date_add DATETIME date_upd DATETIME date_upd DATETIME Indexes
alias contact
id_alias INT(10) id_alias INT(10)
id_contact INT(10)
alias VARCHAR(255)
feature_value
email VARCHAR(128) Indexes
search VARCHAR(255)
id_feature_value INT(10)
position TINYINT(2) position TINYINT(2)
active TINYINT(1) active TINYINT(1)
id_feature INT(10)
Indexes
custom TINYINT(3) custom TINYINT(3)
Indexes
id_product INT(10)
date_upd DATETIME Indexes
accessory product
description TEXT description TEXT description_short TEXT link_rewrite VARCHAR(128) meta_description VARCHAR(255) meta_description VARCHAR(255) id_product INT(10) id_supplier INT(10) id_manufacturer INT(10) id_manufacturer INT(10) id_product_1 INT(10)
id_lang INT(10)
ne
ne INT(10) TINYINT(1) Indexes id_category_default INT(10) meta_title VARCHAR(128) id_lang INT(10) id_lang INT(10) description TEXT Indexes name VARCHAR(128) name VARCHAR(128) available_now VARCHAR(255) available_later VARCHAR(255) Indexes id_color_default INT(10) id_color_default INT(10) on_sale TINYINT(1) id_tax INT(10) meta_keywords VARCHAR(255) id_supplier INT(10) id_category INT(10) id_scene INT(10) id_scene INT(10) Indexes Indexes
scene_category scene_category
id_product_2 INT(10)
supplier_lang
products
ean13 VARCHAR(13) ecotax DECIMAL(10,2) ecotax DECIMAL(10,2) quantity INT(10) price DECIMAL(13,6) wholesale_price DECIMAL(13,6) wholesale_price DECIMAL(13,6) reduction_price DECIMAL(10,2) reduction_percent FLOAT reduction_from DATE reduction_to DATE reduction_to DATE reference VARCHAR(32) supplier_reference VARCHAR(32) weight FLOAT weight FLOAT out_of_stock INT(10) products TINYINT(1) categories TINYINT(1) manufacturers TINYINT(1) suppliers TINYINT(1) suppliers TINYINT(1) scenes TINYINT(1) Indexes height INT(10) height INT(10) width INT(10) name VARCHAR(16) id_image_type INT(10) id_image_type INT(10) T(10) INT(10) (4) (4) (4) INT(3) t INT(3) t INT(3) Indexes Indexes name VARCHAR(100) Indexes id_lang INT(10) id_tag INT(10) id_scene INT(10) id_scene INT(10) id_product INT(10) id_product INT(10)
scene_lang scene_lang
product_tag product_tag
image_type image_type manufacturer
id_manufacturer INT(10) name VARCHAR(64) date_add DATETIME date_add DATETIME date_upd DATETIME Indexes Indexes
feature_product
quantity_discount TINYINT(1)
e
id_feature INT(10) customizable TINYINT(1) customizable TINYINT(1) uploadable_files TINYINT(4) text_fields TINYINT(4) active TINYINT(1) active TINYINT(1) date_add DATETIME date_upd DATETIME Indexes Indexes id_product INT(10) id_tag INT(10) id_lang INT(10) name VARCHAR(32) name VARCHAR(32) Indexes Indexes id_feature_value INT(10) id_feature_value INT(10) Indexes
tag
INT(10)
manufacturer_lang manufacturer_lang
id_manufacturer INT(10) id_lang INT(10) id_lang INT(10) description TEXT Indexes
feature_value_lang
(10) id_lang INT(10) value VARCHAR(255) value VARCHAR(255) Indexes date_upd DATE Indexes Indexes legend VARCHAR(128) sale_nbr INT(10) sale_nbr INT(10) id_lang INT(10) id_lang INT(10) quantity INT(10) id_image INT(10) id_product INT(10) id_feature_value INT(10)
product_sale image_lang
image
id_image INT(10) id_product INT(10) position TINYINT(2) position TINYINT(2) cover TINYINT(1) Indexes
