oc_filter_description
PK
filter_id
INT(11)
NN
PK
language_id
INT(11)
NN
filter_group_id
INT(11)
NN
name
VARCHAR(64)
NN
KEY
PRIMARY
oc_product_discount
PK
product_discount_id
INT(11)
NN
product_id
INT(11)
NN
customer_group_id
INT(11)
NN
quantity
INT(4)
NN
priority
INT(5)
NN
price
DECIMAL(15,4)
NN
date_start
DATE
NN
date_end
DATE
NN
KEY
PRIMARY
IX
product_id
oc_download
PK
download_id
INT(11)
NN
filename
VARCHAR(160)
NN
mask
VARCHAR(128)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_user
PK
user_id
INT(11)
NN
user_group_id
INT(11)
NN
username
VARCHAR(20)
NN
password
VARCHAR(255)
NN
firstname
VARCHAR(32)
NN
lastname
VARCHAR(32)
NN
email
VARCHAR(96)
NN
image
VARCHAR(255)
NN
code
VARCHAR(40)
NN
ip
VARCHAR(40)
NN
status
TINYINT(1)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_customer_login
PK
customer_login_id
INT(11)
NN
email
VARCHAR(96)
NN
ip
VARCHAR(40)
NN
total
INT(4)
NN
date_added
DATETIME
NN
date_modified
DATETIME
NN
KEY
PRIMARY
IX
email
IX
ip
oc_extension
PK
extension_id
INT(11)
NN
extension
VARCHAR(255)
NN
type
VARCHAR(32)
NN
code
VARCHAR(128)
NN
KEY
PRIMARY
oc_return_history
PK
return_history_id
INT(11)
NN
return_id
INT(11)
NN
return_status_id
INT(11)
NN
notify
TINYINT(1)
NN
comment
TEXT
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_length_class_description
PK
length_class_id
INT(11)
NN
PK
language_id
INT(11)
NN
title
VARCHAR(32)
NN
unit
VARCHAR(4)
NN
KEY
PRIMARY
oc_order_status
PK
order_status_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(32)
NN
KEY
PRIMARY
oc_currency
PK
currency_id
INT(11)
NN
title
VARCHAR(32)
NN
code
VARCHAR(3)
NN
symbol_left
VARCHAR(12)
NN
symbol_right
VARCHAR(12)
NN
decimal_place
INT(1)
NN
value
DOUBLE(15,8)
NN
status
TINYINT(1)
NN
date_modified
DATETIME
NN
KEY
PRIMARY
oc_order_history
PK
order_history_id
INT(11)
NN
order_id
INT(11)
NN
order_status_id
INT(11)
NN
notify
TINYINT(1)
NN
comment
TEXT
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_marketing
PK
marketing_id
INT(11)
NN
name
VARCHAR(32)
NN
description
TEXT
NN
code
VARCHAR(64)
NN
clicks
INT(5)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_cart
PK
cart_id
INT(11)
NN
api_id
INT(11)
NN
customer_id
INT(11)
NN
session_id
VARCHAR(32)
NN
product_id
INT(11)
NN
subscription_plan_id
INT(11)
NN
option
TEXT
NN
quantity
INT(5)
NN
date_added
DATETIME
NN
KEY
PRIMARY
IX
cart_id
oc_customer_wishlist
PK
customer_id
INT(11)
NN
PK
product_id
INT(11)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_order_subscription
PK
order_subscription_id
INT(11)
NN
order_product_id
INT(11)
NN
order_id
INT(11)
NN
subscription_plan_id
INT(11)
NN
name
VARCHAR(255)
NN
trial_price
DECIMAL(10,4)
NN
trial_frequency
ENUM
NN
trial_cycle
SMALLINT(6)
NN
trial_duration
SMALLINT(6)
NN
trial_remaining
SMALLINT(6)
NN
trial_status
TINYINT(1)
NN
price
DECIMAL(10,4)
NN
frequency
ENUM
NN
cycle
SMALLINT(6)
NN
duration
SMALLINT(6)
NN
KEY
PRIMARY
IX
order_id
oc_option_value_description
PK
option_value_id
INT(11)
NN
PK
language_id
INT(11)
NN
option_id
INT(11)
NN
name
VARCHAR(128)
NN
KEY
PRIMARY
oc_filter_group
PK
filter_group_id
INT(11)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
oc_layout
PK
layout_id
INT(11)
NN
name
VARCHAR(64)
NN
KEY
PRIMARY
oc_filter
PK
filter_id
INT(11)
NN
filter_group_id
INT(11)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
oc_voucher_theme_description
PK
voucher_theme_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(32)
NN
KEY
PRIMARY
oc_review
PK
review_id
INT(11)
NN
product_id
INT(11)
NN
customer_id
INT(11)
NN
author
VARCHAR(64)
NN
text
TEXT
NN
rating
INT(1)
NN
status
TINYINT(1)
NN
date_added
DATETIME
NN
date_modified
DATETIME
NN
KEY
PRIMARY
IX
product_id
oc_tax_rate
PK
tax_rate_id
INT(11)
NN
geo_zone_id
INT(11)
NN
name
VARCHAR(32)
NN
rate
DECIMAL(15,4)
NN
type
CHAR(1)
NN
date_added
DATETIME
NN
date_modified
DATETIME
NN
KEY
PRIMARY
oc_customer_affiliate
PK
customer_id
INT(11)
NN
company
VARCHAR(60)
NN
website
VARCHAR(255)
NN
tracking
VARCHAR(64)
NN
commission
DECIMAL(4,2)
NN
tax
VARCHAR(64)
NN
payment
VARCHAR(6)
NN
cheque
VARCHAR(100)
NN
paypal
VARCHAR(64)
NN
bank_name
VARCHAR(64)
NN
bank_branch_number
VARCHAR(64)
NN
bank_swift_code
VARCHAR(64)
NN
bank_account_name
VARCHAR(64)
NN
bank_account_number
VARCHAR(64)
NN
custom_field
TEXT
NN
status
TINYINT(1)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_layout_route
PK
layout_route_id
INT(11)
NN
layout_id
INT(11)
NN
store_id
INT(11)
NN
route
VARCHAR(64)
NN
KEY
PRIMARY
oc_category_to_layout
PK
category_id
INT(11)
NN
PK
store_id
INT(11)
NN
layout_id
INT(11)
NN
KEY
PRIMARY
oc_coupon_product
PK
coupon_product_id
INT(11)
NN
coupon_id
INT(11)
NN
product_id
INT(11)
NN
KEY
PRIMARY
oc_product_image
PK
product_image_id
INT(11)
NN
product_id
INT(11)
NN
image
VARCHAR(255)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
IX
product_id
oc_upload
PK
upload_id
INT(11)
NN
name
VARCHAR(255)
NN
filename
VARCHAR(255)
NN
code
VARCHAR(255)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_banner_image
PK
banner_image_id
INT(11)
NN
banner_id
INT(11)
NN
language_id
INT(11)
NN
title
VARCHAR(64)
NN
link
VARCHAR(255)
NN
image
VARCHAR(255)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
oc_customer_affiliate_report
PK
customer_affiliate_report_id
INT(11)
NN
customer_id
INT(11)
NN
store_id
INT(11)
NN
ip
VARCHAR(40)
NN
country
VARCHAR(2)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_address_format
PK
address_format_id
INT(11)
NN
name
VARCHAR(128)
NN
address_format
TEXT
NN
KEY
PRIMARY
oc_length_class
PK
length_class_id
INT(11)
NN
value
DECIMAL(15,8)
NN
KEY
PRIMARY
oc_setting
PK
setting_id
INT(11)
NN
store_id
INT(11)
NN
code
VARCHAR(128)
NN
key
VARCHAR(128)
NN
value
TEXT
NN
serialized
TINYINT(1)
NN
KEY
PRIMARY
oc_subscription_plan_description
PK
subscription_plan_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(255)
NN
KEY
PRIMARY
oc_return
PK
return_id
INT(11)
NN
order_id
INT(11)
NN
product_id
INT(11)
NN
customer_id
INT(11)
NN
firstname
VARCHAR(32)
NN
lastname
VARCHAR(32)
NN
email
VARCHAR(96)
NN
telephone
VARCHAR(32)
NN
product
VARCHAR(255)
NN
model
VARCHAR(64)
NN
quantity
INT(4)
NN
opened
TINYINT(1)
NN
return_reason_id
INT(11)
NN
return_action_id
INT(11)
NN
return_status_id
INT(11)
NN
comment
TEXT
NN
date_ordered
DATE
NN
date_added
DATETIME
NN
date_modified
DATETIME
NN
KEY
PRIMARY
oc_product_attribute
PK
product_id
INT(11)
NN
PK
attribute_id
INT(11)
NN
PK
language_id
INT(11)
NN
text
TEXT
NN
KEY
PRIMARY
oc_api_session
PK
api_session_id
INT(11)
NN
api_id
INT(11)
NN
session_id
VARCHAR(32)
NN
ip
VARCHAR(40)
NN
date_added
DATETIME
NN
date_modified
DATETIME
NN
KEY
PRIMARY
oc_order_total
PK
order_total_id
INT(10)
NN
order_id
INT(11)
NN
extension
VARCHAR(255)
NN
code
VARCHAR(32)
NN
title
VARCHAR(255)
NN
value
DECIMAL(15,4)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
IX
order_id
oc_product_reward
PK
product_reward_id
INT(11)
NN
product_id
INT(11)
NN
customer_group_id
INT(11)
NN
points
INT(8)
NN
KEY
PRIMARY
oc_attribute_description
PK
attribute_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(64)
NN
KEY
PRIMARY
oc_customer_group_description
PK
customer_group_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(32)
NN
description
TEXT
NN
KEY
PRIMARY
oc_theme
PK
theme_id
INT(11)
NN
store_id
INT(11)
NN
route
VARCHAR(64)
NN
code
MEDIUMTEXT
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_statistics
PK
statistics_id
INT(11)
NN
code
VARCHAR(64)
NN
value
DECIMAL(15,4)
NN
KEY
PRIMARY
oc_customer_online
PK
ip
VARCHAR(40)
NN
customer_id
INT(11)
NN
url
TEXT
NN
referer
TEXT
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_module
PK
module_id
INT(11)
NN
name
VARCHAR(64)
NN
code
VARCHAR(64)
NN
setting
TEXT
NN
KEY
PRIMARY
oc_category_filter
PK
category_id
INT(11)
NN
PK
filter_id
INT(11)
NN
KEY
PRIMARY
oc_country
PK
country_id
INT(11)
NN
name
VARCHAR(128)
NN
iso_code_2
VARCHAR(2)
NN
iso_code_3
VARCHAR(3)
NN
address_format_id
INT(11)
NN
postcode_required
TINYINT(1)
NN
status
TINYINT(1)
NN
KEY
PRIMARY
oc_api
PK
api_id
INT(11)
NN
username
VARCHAR(64)
NN
key
TEXT
NN
status
TINYINT(1)
NN
date_added
DATETIME
NN
date_modified
DATETIME
NN
KEY
PRIMARY
oc_product_to_store
PK
product_id
INT(11)
NN
PK
store_id
INT(11)
NN
KEY
PRIMARY
oc_marketing_report
PK
marketing_report_id
INT(11)
NN
marketing_id
INT(11)
NN
store_id
INT(11)
NN
ip
VARCHAR(40)
NN
country
VARCHAR(2)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_information
PK
information_id
INT(11)
NN
bottom
INT(1)
NN
sort_order
INT(3)
NN
status
TINYINT(1)
NN
KEY
PRIMARY
oc_order_product
PK
order_product_id
INT(11)
NN
order_id
INT(11)
NN
product_id
INT(11)
NN
master_id
INT(11)
NN
name
VARCHAR(255)
NN
model
VARCHAR(64)
NN
quantity
INT(4)
NN
price
DECIMAL(15,4)
NN
total
DECIMAL(15,4)
NN
tax
DECIMAL(15,4)
NN
reward
INT(8)
NN
KEY
PRIMARY
IX
order_id
oc_download_report
PK
download_report_id
INT(11)
NN
download_id
INT(11)
NN
store_id
INT(11)
NN
ip
VARCHAR(40)
NN
country
VARCHAR(2)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_product_report
PK
product_report_id
INT(11)
NN
product_id
INT(11)
NN
store_id
INT(11)
NN
ip
VARCHAR(40)
NN
country
VARCHAR(2)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_banner
PK
banner_id
INT(11)
NN
name
VARCHAR(64)
NN
status
TINYINT(1)
NN
KEY
PRIMARY
oc_filter_group_description
PK
filter_group_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(64)
NN
KEY
PRIMARY
oc_attribute_group
PK
attribute_group_id
INT(11)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
oc_information_to_layout
PK
information_id
INT(11)
NN
PK
store_id
INT(11)
NN
layout_id
INT(11)
NN
KEY
PRIMARY
oc_weight_class_description
PK
weight_class_id
INT(11)
NN
PK
language_id
INT(11)
NN
title
VARCHAR(32)
NN
unit
VARCHAR(4)
NN
KEY
PRIMARY
oc_information_description
PK
information_id
INT(11)
NN
PK
language_id
INT(11)
NN
title
VARCHAR(64)
NN
description
MEDIUMTEXT
NN
meta_title
VARCHAR(255)
NN
meta_description
VARCHAR(255)
NN
meta_keyword
VARCHAR(255)
NN
KEY
PRIMARY
oc_coupon_category
PK
coupon_id
INT(11)
NN
PK
category_id
INT(11)
NN
KEY
PRIMARY
oc_option_value
PK
option_value_id
INT(11)
NN
option_id
INT(11)
NN
image
VARCHAR(255)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
oc_voucher_theme
PK
voucher_theme_id
INT(11)
NN
image
VARCHAR(255)
NN
KEY
PRIMARY
oc_layout_module
PK
layout_module_id
INT(11)
NN
layout_id
INT(11)
NN
code
VARCHAR(64)
NN
position
VARCHAR(14)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
oc_customer_history
PK
customer_history_id
INT(11)
NN
customer_id
INT(11)
NN
comment
TEXT
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_customer_ip
PK
customer_ip_id
INT(11)
NN
customer_id
INT(11)
NN
store_id
INT(11)
NN
ip
VARCHAR(40)
NN
country
VARCHAR(2)
NN
date_added
DATETIME
NN
KEY
PRIMARY
IX
ip
oc_customer_activity
PK
customer_activity_id
INT(11)
NN
customer_id
INT(11)
NN
key
VARCHAR(64)
NN
data
TEXT
NN
ip
VARCHAR(40)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_user_group
PK
user_group_id
INT(11)
NN
name
VARCHAR(64)
NN
permission
TEXT
NN
KEY
PRIMARY
oc_subscription_plan
PK
subscription_plan_id
INT(11)
NN
trial_price
DECIMAL(10,4)
NN
trial_frequency
ENUM
NN
trial_duration
INT(10)
NN
trial_cycle
INT(10)
NN
trial_status
TINYINT(4)
NN
frequency
ENUM
NN
duration
INT(10)
NN
cycle
INT(10)
NN
status
TINYINT(1)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
oc_category_description
PK
category_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(255)
NN
description
TEXT
NN
meta_title
VARCHAR(255)
NN
meta_description
VARCHAR(255)
NN
meta_keyword
VARCHAR(255)
NN
KEY
PRIMARY
IX
name
oc_custom_field_value_description
PK
custom_field_value_id
INT(11)
NN
PK
language_id
INT(11)
NN
custom_field_id
INT(11)
NN
name
VARCHAR(128)
NN
KEY
PRIMARY
oc_gdpr
PK
gdpr_id
INT(11)
NN
store_id
INT(11)
NN
language_id
INT(11)
NN
code
VARCHAR(40)
NN
email
VARCHAR(96)
NN
action
VARCHAR(6)
NN
status
TINYINT(1)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_seo_url
PK
seo_url_id
INT(11)
NN
store_id
INT(11)
NN
language_id
INT(11)
NN
key
VARCHAR(64)
NN
value
VARCHAR(255)
NN
keyword
VARCHAR(255)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
IX
keyword
IX
query
oc_information_to_store
PK
information_id
INT(11)
NN
PK
store_id
INT(11)
NN
KEY
PRIMARY
oc_api_ip
PK
api_ip_id
INT(11)
NN
api_id
INT(11)
NN
ip
VARCHAR(40)
NN
KEY
PRIMARY
oc_tax_rate_to_customer_group
PK
tax_rate_id
INT(11)
NN
PK
customer_group_id
INT(11)
NN
KEY
PRIMARY
oc_product_option_value
PK
product_option_value_id
INT(11)
NN
product_option_id
INT(11)
NN
product_id
INT(11)
NN
option_id
INT(11)
NN
option_value_id
INT(11)
NN
quantity
INT(3)
NN
subtract
TINYINT(1)
NN
price
DECIMAL(15,4)
NN
price_prefix
VARCHAR(1)
NN
points
INT(8)
NN
points_prefix
VARCHAR(1)
NN
weight
DECIMAL(15,8)
NN
weight_prefix
VARCHAR(1)
NN
KEY
PRIMARY
oc_order_voucher
PK
order_voucher_id
INT(11)
NN
order_id
INT(11)
NN
voucher_id
INT(11)
NN
description
VARCHAR(255)
NN
code
VARCHAR(10)
NN
from_name
VARCHAR(64)
NN
from_email
VARCHAR(96)
NN
to_name
VARCHAR(64)
NN
to_email
VARCHAR(96)
NN
voucher_theme_id
INT(11)
NN
message
TEXT
NN
amount
DECIMAL(15,4)
NN
KEY
PRIMARY
oc_extension_install
PK
extension_install_id
INT(11)
NN
extension_id
INT(11)
NN
extension_download_id
INT(11)
NN
name
VARCHAR(128)
NN
code
VARCHAR(255)
NN
version
VARCHAR(255)
NN
author
VARCHAR(255)
NN
link
VARCHAR(255)
NN
status
TINYINT(1)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_category_to_store
PK
category_id
INT(11)
NN
store_id
INT(11)
NN
KEY
PRIMARY
oc_customer
PK
customer_id
INT(11)
NN
customer_group_id
INT(11)
NN
store_id
INT(11)
NN
language_id
INT(11)
NN
firstname
VARCHAR(32)
NN
lastname
VARCHAR(32)
NN
email
VARCHAR(96)
NN
telephone
VARCHAR(32)
NN
password
VARCHAR(255)
NN
custom_field
TEXT
NN
newsletter
TINYINT(1)
NN
ip
VARCHAR(40)
NN
status
TINYINT(1)
NN
safe
TINYINT(1)
NN
token
TEXT
NN
code
VARCHAR(40)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_attribute
PK
attribute_id
INT(11)
NN
attribute_group_id
INT(11)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
oc_stock_status
PK
stock_status_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(32)
NN
KEY
PRIMARY
oc_return_action
PK
return_action_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(64)
NN
KEY
PRIMARY
oc_translation
PK
translation_id
INT(11)
NN
store_id
INT(11)
NN
language_id
INT(11)
NN
route
VARCHAR(64)
NN
key
VARCHAR(64)
NN
value
TEXT
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_cron
PK
cron_id
INT(11)
NN
code
VARCHAR(128)
NN
description
TEXT
NN
cycle
VARCHAR(12)
NN
action
TEXT
NN
status
TINYINT(1)
NN
date_added
DATETIME
NN
date_modified
DATETIME
NN
KEY
PRIMARY
oc_option_description
PK
option_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(128)
NN
KEY
PRIMARY
oc_store
PK
store_id
INT(11)
NN
name
VARCHAR(64)
NN
url
VARCHAR(255)
NN
KEY
PRIMARY
oc_notification
PK
notification_id
INT(11)
NN
title
VARCHAR(64)
NN
text
TEXT
NN
status
TINYINT(11)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_voucher_history
PK
voucher_history_id
INT(11)
NN
voucher_id
INT(11)
NN
order_id
INT(11)
NN
amount
DECIMAL(15,4)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_product_to_category
PK
product_id
INT(11)
NN
PK
category_id
INT(11)
NN
KEY
PRIMARY
IX
category_id
oc_address
PK
address_id
INT(11)
NN
customer_id
INT(11)
NN
firstname
VARCHAR(32)
NN
lastname
VARCHAR(32)
NN
company
VARCHAR(60)
NN
address_1
VARCHAR(128)
NN
address_2
VARCHAR(128)
NN
city
VARCHAR(128)
NN
postcode
VARCHAR(10)
NN
country_id
INT(11)
NN
zone_id
INT(11)
NN
custom_field
TEXT
NN
default
TINYINT(1)
NN
KEY
PRIMARY
IX
customer_id
oc_customer_search
PK
customer_search_id
INT(11)
NN
store_id
INT(11)
NN
language_id
INT(11)
NN
customer_id
INT(11)
NN
keyword
VARCHAR(255)
NN
category_id
INT(11)
NN
sub_category
TINYINT(1)
NN
description
TINYINT(1)
NN
products
INT(11)
NN
ip
VARCHAR(40)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_custom_field_description
PK
custom_field_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(128)
NN
KEY
PRIMARY
oc_customer_transaction
PK
customer_transaction_id
INT(11)
NN
customer_id
INT(11)
NN
order_id
INT(11)
NN
description
TEXT
NN
amount
DECIMAL(15,4)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_return_reason
PK
return_reason_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(128)
NN
KEY
PRIMARY
oc_custom_field_value
PK
custom_field_value_id
INT(11)
NN
custom_field_id
INT(11)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
oc_product_option
PK
product_option_id
INT(11)
NN
product_id
INT(11)
NN
option_id
INT(11)
NN
value
TEXT
NN
required
TINYINT(1)
NN
KEY
PRIMARY
oc_zone_to_geo_zone
PK
zone_to_geo_zone_id
INT(11)
NN
country_id
INT(11)
NN
zone_id
INT(11)
NN
geo_zone_id
INT(11)
NN
date_added
DATETIME
NN
date_modified
DATETIME
NN
KEY
PRIMARY
oc_language
PK
language_id
INT(11)
NN
name
VARCHAR(32)
NN
code
VARCHAR(5)
NN
locale
VARCHAR(255)
NN
extension
VARCHAR(255)
NN
sort_order
INT(3)
NN
status
TINYINT(1)
NN
KEY
PRIMARY
IX
name
oc_product_special
PK
product_special_id
INT(11)
NN
product_id
INT(11)
NN
customer_group_id
INT(11)
NN
priority
INT(5)
NN
price
DECIMAL(15,4)
NN
date_start
DATE
NN
date_end
DATE
NN
KEY
PRIMARY
IX
product_id
oc_session
PK
session_id
VARCHAR(32)
NN
data
TEXT
NN
expire
DATETIME
NN
KEY
PRIMARY
IX
expire
oc_manufacturer_to_layout
PK
manufacturer_id
INT(11)
NN
PK
store_id
INT(11)
NN
layout_id
INT(11)
NN
KEY
PRIMARY
oc_startup
PK
startup_id
INT(11)
NN
code
VARCHAR(64)
NN
action
TEXT
NN
status
TINYINT(1)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
oc_attribute_group_description
PK
attribute_group_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(64)
NN
KEY
PRIMARY
oc_product_related
PK
product_id
INT(11)
NN
PK
related_id
INT(11)
NN
KEY
PRIMARY
oc_product
PK
product_id
INT(11)
NN
master_id
INT(11)
NN
model
VARCHAR(64)
NN
sku
VARCHAR(64)
NN
upc
VARCHAR(12)
NN
ean
VARCHAR(14)
NN
jan
VARCHAR(13)
NN
isbn
VARCHAR(17)
NN
mpn
VARCHAR(64)
NN
location
VARCHAR(128)
NN
variant
TEXT
NN
override
TEXT
NN
quantity
INT(4)
NN
stock_status_id
INT(11)
NN
image
VARCHAR(255)
NN
manufacturer_id
INT(11)
NN
shipping
TINYINT(1)
NN
price
DECIMAL(15,4)
NN
points
INT(8)
NN
tax_class_id
INT(11)
NN
date_available
DATE
NN
weight
DECIMAL(15,8)
NN
weight_class_id
INT(11)
NN
length
DECIMAL(15,8)
NN
width
DECIMAL(15,8)
NN
height
DECIMAL(15,8)
NN
length_class_id
INT(11)
NN
subtract
TINYINT(1)
NN
minimum
INT(11)
NN
sort_order
INT(11)
NN
status
TINYINT(1)
NN
date_added
DATETIME
NN
date_modified
DATETIME
NN
KEY
PRIMARY
oc_user_authorize
PK
user_authorize_id
INT(11)
NN
user_id
INT(11)
NN
token
VARCHAR(96)
NN
total
INT(1)
NN
ip
VARCHAR(40)
NN
user_agent
VARCHAR(255)
NN
status
TINYINT(1)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_category
PK
category_id
INT(11)
NN
image
VARCHAR(255)
NN
parent_id
INT(11)
NN
top
TINYINT(1)
NN
column
INT(3)
NN
sort_order
INT(3)
NN
status
TINYINT(1)
NN
date_added
DATETIME
NN
date_modified
DATETIME
NN
KEY
PRIMARY
IX
parent_id
oc_manufacturer
PK
manufacturer_id
INT(11)
NN
name
VARCHAR(64)
NN
image
VARCHAR(255)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
oc_extension_path
PK
extension_path_id
INT(11)
NN
extension_install_id
INT(11)
NN
path
VARCHAR(255)
NN
KEY
PRIMARY
IX
path
oc_product_viewed
PK
product_id
INT(11)
NN
viewed
INT(11)
NN
KEY
PRIMARY
oc_customer_group
PK
customer_group_id
INT(11)
NN
approval
INT(1)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
oc_tax_class
PK
tax_class_id
INT(11)
NN
title
VARCHAR(32)
NN
description
VARCHAR(255)
NN
date_added
DATETIME
NN
date_modified
DATETIME
NN
KEY
PRIMARY
oc_zone
PK
zone_id
INT(11)
NN
country_id
INT(11)
NN
name
VARCHAR(128)
NN
code
VARCHAR(32)
NN
status
TINYINT(1)
NN
KEY
PRIMARY
oc_product_to_layout
PK
product_id
INT(11)
NN
PK
store_id
INT(11)
NN
layout_id
INT(11)
NN
KEY
PRIMARY
oc_tax_rule
PK
tax_rule_id
INT(11)
NN
tax_class_id
INT(11)
NN
tax_rate_id
INT(11)
NN
based
VARCHAR(10)
NN
priority
INT(5)
NN
KEY
PRIMARY
oc_custom_field_customer_group
PK
custom_field_id
INT(11)
NN
PK
customer_group_id
INT(11)
NN
required
TINYINT(1)
NN
KEY
PRIMARY
oc_weight_class
PK
weight_class_id
INT(11)
NN
value
DECIMAL(15,8)
NN
KEY
PRIMARY
oc_product_filter
PK
product_id
INT(11)
NN
PK
filter_id
INT(11)
NN
KEY
PRIMARY
oc_geo_zone
PK
geo_zone_id
INT(11)
NN
name
VARCHAR(32)
NN
description
VARCHAR(255)
NN
date_added
DATETIME
NN
date_modified
DATETIME
NN
KEY
PRIMARY
oc_subscription_status
PK
subscription_status_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(32)
NN
KEY
PRIMARY
oc_subscription
PK
subscription_id
INT(11)
NN
order_id
INT(11)
NN
order_product_id
INT(11)
NN
store_id
INT(11)
NN
customer_id
INT(11)
NN
customer_group_id
INT(11)
NN
payment_address_id
INT(11)
NN
payment_method
TEXT
NN
shipping_address_id
INT(11)
NN
shipping_method
TEXT
NN
product_id
INT(11)
NN
quantity
INT(4)
NN
subscription_plan_id
INT(11)
NN
name
VARCHAR(255)
NN
trial_price
DECIMAL(10,4)
NN
trial_frequency
ENUM
NN
trial_cycle
SMALLINT(6)
NN
trial_duration
SMALLINT(6)
NN
trial_remaining
SMALLINT(6)
NN
trial_status
TINYINT(1)
NN
price
DECIMAL(10,4)
NN
frequency
ENUM
NN
cycle
SMALLINT(6)
NN
duration
SMALLINT(6)
NN
remaining
SMALLINT(6)
NN
date_next
DATETIME
NN
comment
TEXT
NN
subscription_status_id
INT(11)
NN
affiliate_id
INT(11)
NN
commission
DECIMAL(10,4)
NN
marketing_id
INT(11)
NN
tracking
VARCHAR(64)
NN
language_id
INT(11)
NN
currency_id
INT(11)
NN
ip
VARCHAR(40)
NN
forwarded_ip
VARCHAR(40)
NN
user_agent
VARCHAR(255)
NN
accept_language
VARCHAR(255)
NN
date_added
DATETIME
NN
date_modified
DATETIME
NN
KEY
PRIMARY
IX
order_id
oc_manufacturer_to_store
PK
manufacturer_id
INT(11)
NN
PK
store_id
INT(11)
NN
KEY
PRIMARY
oc_product_description
PK
product_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(255)
NN
description
TEXT
NN
tag
TEXT
NN
meta_title
VARCHAR(255)
NN
meta_description
VARCHAR(255)
NN
meta_keyword
VARCHAR(255)
NN
KEY
PRIMARY
IX
name
oc_coupon
PK
coupon_id
INT(11)
NN
name
VARCHAR(128)
NN
code
VARCHAR(20)
NN
type
CHAR(1)
NN
discount
DECIMAL(15,4)
NN
logged
TINYINT(1)
NN
shipping
TINYINT(1)
NN
total
DECIMAL(15,4)
NN
date_start
DATE
NN
date_end
DATE
NN
uses_total
INT(11)
NN
uses_customer
INT(11)
NN
status
TINYINT(1)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_subscription_history
PK
subscription_history_id
INT(11)
NN
subscription_id
INT(11)
NN
subscription_status_id
INT(11)
NN
notify
TINYINT(1)
NN
comment
TEXT
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_return_status
PK
return_status_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(32)
NN
KEY
PRIMARY
oc_voucher
PK
voucher_id
INT(11)
NN
order_id
INT(11)
NN
code
VARCHAR(10)
NN
from_name
VARCHAR(64)
NN
from_email
VARCHAR(96)
NN
to_name
VARCHAR(64)
NN
to_email
VARCHAR(96)
NN
voucher_theme_id
INT(11)
NN
message
TEXT
NN
amount
DECIMAL(15,4)
NN
status
TINYINT(1)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_customer_reward
PK
customer_reward_id
INT(11)
NN
customer_id
INT(11)
NN
order_id
INT(11)
NN
description
TEXT
NN
points
INT(8)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_location
PK
location_id
INT(11)
NN
name
VARCHAR(32)
NN
address
TEXT
NN
telephone
VARCHAR(32)
NN
geocode
VARCHAR(32)
NN
image
VARCHAR(255)
NN
open
TEXT
NN
comment
TEXT
NN
KEY
PRIMARY
IX
name
oc_order_option
PK
order_option_id
INT(11)
NN
order_id
INT(11)
NN
order_product_id
INT(11)
NN
product_option_id
INT(11)
NN
product_option_value_id
INT(11)
NN
name
VARCHAR(255)
NN
value
TEXT
NN
type
VARCHAR(32)
NN
KEY
PRIMARY
oc_order
PK
order_id
INT(11)
NN
subscription_id
INT(11)
NN
invoice_no
INT(11)
NN
invoice_prefix
VARCHAR(26)
NN
transaction_id
VARCHAR(100)
NN
store_id
INT(11)
NN
store_name
VARCHAR(64)
NN
store_url
VARCHAR(255)
NN
customer_id
INT(11)
NN
customer_group_id
INT(11)
NN
firstname
VARCHAR(32)
NN
lastname
VARCHAR(32)
NN
email
VARCHAR(96)
NN
telephone
VARCHAR(32)
NN
custom_field
TEXT
NN
payment_address_id
INT(11)
NN
payment_firstname
VARCHAR(32)
NN
payment_lastname
VARCHAR(32)
NN
payment_company
VARCHAR(60)
NN
payment_address_1
VARCHAR(128)
NN
payment_address_2
VARCHAR(128)
NN
payment_city
VARCHAR(128)
NN
payment_postcode
VARCHAR(10)
NN
payment_country
VARCHAR(128)
NN
payment_country_id
INT(11)
NN
payment_zone
VARCHAR(128)
NN
payment_zone_id
INT(11)
NN
payment_address_format
TEXT
NN
payment_custom_field
TEXT
NN
payment_method
TEXT
NN
shipping_address_id
INT(11)
NN
shipping_firstname
VARCHAR(32)
NN
shipping_lastname
VARCHAR(32)
NN
shipping_company
VARCHAR(60)
NN
shipping_address_1
VARCHAR(128)
NN
shipping_address_2
VARCHAR(128)
NN
shipping_city
VARCHAR(128)
NN
shipping_postcode
VARCHAR(10)
NN
shipping_country
VARCHAR(128)
NN
shipping_country_id
INT(11)
NN
shipping_zone
VARCHAR(128)
NN
shipping_zone_id
INT(11)
NN
shipping_address_format
TEXT
NN
shipping_custom_field
TEXT
NN
shipping_method
TEXT
NN
comment
TEXT
NN
total
DECIMAL(15,4)
NN
order_status_id
INT(11)
NN
affiliate_id
INT(11)
NN
commission
DECIMAL(15,4)
NN
marketing_id
INT(11)
NN
tracking
VARCHAR(64)
NN
language_id
INT(11)
NN
language_code
VARCHAR(5)
NN
currency_id
INT(11)
NN
currency_code
VARCHAR(3)
NN
currency_value
DECIMAL(15,8)
NN
ip
VARCHAR(40)
NN
forwarded_ip
VARCHAR(40)
NN
user_agent
VARCHAR(255)
NN
accept_language
VARCHAR(255)
NN
date_added
DATETIME
NN
date_modified
DATETIME
NN
KEY
PRIMARY
oc_option
PK
option_id
INT(11)
NN
type
VARCHAR(32)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
oc_customer_approval
PK
customer_approval_id
INT(11)
NN
customer_id
INT(11)
NN
type
VARCHAR(9)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_product_to_download
PK
product_id
INT(11)
NN
PK
download_id
INT(11)
NN
KEY
PRIMARY
oc_category_path
PK
category_id
INT(11)
NN
PK
path_id
INT(11)
NN
level
INT(11)
NN
KEY
PRIMARY
oc_coupon_history
PK
coupon_history_id
INT(11)
NN
coupon_id
INT(11)
NN
order_id
INT(11)
NN
customer_id
INT(11)
NN
amount
DECIMAL(15,4)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_event
PK
event_id
INT(11)
NN
code
VARCHAR(128)
NN
description
TEXT
NN
trigger
TEXT
NN
action
TEXT
NN
status
TINYINT(1)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
oc_user_login
PK
user_login_id
INT(11)
NN
user_id
INT(11)
NN
ip
VARCHAR(40)
NN
user_agent
VARCHAR(255)
NN
date_added
DATETIME
NN
KEY
PRIMARY
oc_download_description
PK
download_id
INT(11)
NN
PK
language_id
INT(11)
NN
name
VARCHAR(64)
NN
KEY
PRIMARY
oc_product_subscription
PK
product_id
INT(11)
NN
PK
subscription_plan_id
INT(11)
NN
PK
customer_group_id
INT(11)
NN
trial_price
DECIMAL(10,4)
NN
price
DECIMAL(10,4)
NN
KEY
PRIMARY
oc_custom_field
PK
custom_field_id
INT(11)
NN
type
VARCHAR(32)
NN
value
TEXT
NN
validation
VARCHAR(255)
NN
location
VARCHAR(10)
NN
status
TINYINT(1)
NN
sort_order
INT(3)
NN
KEY
PRIMARY
License
OpenCart is licensed under GNU General Public License version 3 (GPLv3)