SchemaSpy Analysis of schema_generation - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Jun 18 16:54 CDT 2007
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
schema_generation contains 1003 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
ID articles_xsell int 10  √ 
products_xsell.ID Implied Constraint
ID products_xsell int 10  √ 
articles_xsell.ID Implied Constraint
OSC_link events_calendar varchar 255  √  null
account_name orders varchar 32  √  null
account_number orders varchar 20  √  null
active template char 1 1
address_book_id address_book int 11  √ 
address_city paypal varchar 32  √  null
address_country paypal varchar 64  √  null
address_format address_format varchar 128
address_format_id address_format int 11  √ 
countries.address_format_id countries_ibfk_1
address_format_id countries int 11 0
address_format.address_format_id countries_ibfk_1
address_name paypal varchar 32  √  null
address_state paypal varchar 32  √  null
address_status paypal varchar 11  √  null
address_street paypal varchar 64  √  null
address_summary address_format varchar 48
address_zip paypal varchar 10  √  null
admin_created admin datetime 19  √  null
admin_email_address admin varchar 96
admin_files_id admin_files int 11  √ 
admin_files_is_boxes admin_files tinyint 5 0
admin_files_name admin_files varchar 64
admin_files_to_boxes admin_files int 11 0
admin_firstname admin varchar 32
admin_groups_id admin int 11  √  null
admin_groups.admin_groups_id admin_ibfk_1
admin_groups_id admin_files set 5 1
admin_groups_id admin_groups int 11  √ 
admin.admin_groups_id admin_ibfk_1
admin_groups_name admin_groups varchar 64  √  null
admin_id admin int 11  √ 
admin_lastname admin varchar 32  √  null
admin_logdate admin datetime 19  √  null
admin_lognum admin int 11 0
admin_modified admin datetime 19 0000-00-00 00:00:00
admin_password admin varchar 40
affiliate_address_format_id affiliate_payment int 5 0
affiliate_agb affiliate_affiliate tinyint 4 0
affiliate_banner_id affiliate_clickthroughs int 11 0
affiliate_banners_affiliate_id affiliate_banners_history int 11 0
affiliate_banners_clicks affiliate_banners_history tinyint 4 0
affiliate_banners_group affiliate_banners varchar 10
affiliate_banners_history_date affiliate_banners_history date 10 0000-00-00
affiliate_banners_history_id affiliate_banners_history int 11  √ 
affiliate_banners_html_text affiliate_banners text 65535  √  null
affiliate_banners_id affiliate_banners int 11  √ 
affiliate_banners_history.affiliate_banners_id Implied Constraint
affiliate_banners_id affiliate_banners_history int 11 0
affiliate_banners.affiliate_banners_id Implied Constraint
affiliate_banners_image affiliate_banners varchar 64
affiliate_banners_products_id affiliate_banners_history int 11 0
affiliate_banners_shown affiliate_banners_history int 11 0
affiliate_banners_title affiliate_banners varchar 64
affiliate_billing_status affiliate_sales int 5 0
affiliate_browser affiliate_sales varchar 100
affiliate_browser orders_session_info varchar 100  √ 
affiliate_category_id affiliate_banners int 11  √  null
categories.categories_id affiliate_banners_ibfk_2
affiliate_city affiliate_affiliate varchar 32
affiliate_city affiliate_payment varchar 32
affiliate_clickthrough_id affiliate_clickthroughs int 11  √ 
affiliate_clickthroughs_id affiliate_sales int 11 0
affiliate_clickthroughs_id orders_session_info int 11  √  0
affiliate_clientbrowser affiliate_clickthroughs varchar 200  √  Could Not Find This Data
affiliate_clientdate affiliate_clickthroughs datetime 19 0000-00-00 00:00:00
affiliate_clientip affiliate_clickthroughs varchar 50  √  Could Not Find This Data
affiliate_clientreferer affiliate_clickthroughs varchar 200  √  None Detected (Perhaps a direct link)
affiliate_commission_percent affiliate_affiliate decimal 4,2 0.00
affiliate_company affiliate_affiliate varchar 60
affiliate_company affiliate_payment varchar 60
affiliate_company_taxid affiliate_affiliate varchar 64
affiliate_country affiliate_payment varchar 32 0
affiliate_country_id affiliate_affiliate int 11 0
affiliate_date affiliate_sales datetime 19 0000-00-00 00:00:00
affiliate_date orders_session_info datetime 19  √  null
affiliate_date_account_created affiliate_affiliate datetime 19 0000-00-00 00:00:00
affiliate_date_account_last_modified affiliate_affiliate datetime 19 0000-00-00 00:00:00
affiliate_date_added affiliate_banners datetime 19 0000-00-00 00:00:00
affiliate_date_added affiliate_payment_status_history datetime 19 0000-00-00 00:00:00
affiliate_date_of_last_logon affiliate_affiliate datetime 19 0000-00-00 00:00:00
affiliate_date_scheduled affiliate_banners datetime 19  √  null
affiliate_date_status_change affiliate_banners datetime 19  √  null
affiliate_dob affiliate_affiliate datetime 19 0000-00-00 00:00:00
affiliate_email_address affiliate_affiliate varchar 96
affiliate_expires_date affiliate_banners datetime 19  √  null
affiliate_expires_impressions affiliate_banners int 7  √  0
affiliate_fax affiliate_affiliate varchar 32
affiliate_firstname affiliate_affiliate varchar 32
affiliate_firstname affiliate_payment varchar 32
affiliate_gender affiliate_affiliate char 1
affiliate_homepage affiliate_affiliate varchar 96
affiliate_id affiliate_affiliate int 11  √ 
affiliate_clickthroughs.affiliate_id affiliate_clickthroughs_ibfk_1
affiliate_payment.affiliate_id affiliate_payment_ibfk_1
affiliate_sales.affiliate_id affiliate_sales_ibfk_1
orders_session_info.affiliate_id Implied Constraint
affiliate_id affiliate_clickthroughs int 11 0
affiliate_affiliate.affiliate_id affiliate_clickthroughs_ibfk_1
affiliate_id affiliate_payment int 11 0
affiliate_affiliate.affiliate_id affiliate_payment_ibfk_1
affiliate_id affiliate_sales int 11 0
affiliate_affiliate.affiliate_id affiliate_sales_ibfk_1
affiliate_id orders_session_info int 11  √  0
affiliate_affiliate.affiliate_id Implied Constraint
affiliate_ipaddress affiliate_sales varchar 20
affiliate_ipaddress orders_session_info varchar 20  √ 
affiliate_language_id affiliate_payment_status int 11 1
languages.languages_id affiliate_payment_status_ibfk_1
affiliate_last_modified affiliate_payment datetime 19 0000-00-00 00:00:00
affiliate_lastname affiliate_affiliate varchar 32
affiliate_lastname affiliate_payment varchar 32
affiliate_lft affiliate_affiliate int 11 0
affiliate_new_value affiliate_payment_status_history int 5 0
affiliate_news_contents affiliate_news_contents text 65535
affiliate_news_contents_id affiliate_news_contents int 11  √ 
affiliate_news_headlines affiliate_news_contents varchar 255
affiliate_news_id affiliate_news_contents int 11 0
affiliate_news.news_id affiliate_news_contents_ibfk_1
affiliate_news_languages_id affiliate_news_contents int 11 0
languages.languages_id affiliate_news_contents_ibfk_2
affiliate_newsletter affiliate_affiliate char 1 1
affiliate_newsletters_id affiliate_newsletters int 11  √ 
affiliate_notified affiliate_payment_status_history int 1  √  0
affiliate_number_of_logons affiliate_affiliate int 11 0
affiliate_old_value affiliate_payment_status_history int 5  √  null
affiliate_orders_id affiliate_sales int 11 0
orders.orders_id affiliate_sales_ibfk_2
affiliate_password affiliate_affiliate varchar 40
affiliate_payment affiliate_payment decimal 15,2 0.00
affiliate_payment affiliate_sales decimal 15,2 0.00
affiliate_payment_bank_account_name affiliate_affiliate varchar 64
affiliate_payment_bank_account_number affiliate_affiliate varchar 64
affiliate_payment_bank_branch_number affiliate_affiliate varchar 64
affiliate_payment_bank_name affiliate_affiliate varchar 64
affiliate_payment_bank_swift_code affiliate_affiliate varchar 64
affiliate_payment_check affiliate_affiliate varchar 100
affiliate_payment_date affiliate_payment datetime 19 0000-00-00 00:00:00
affiliate_payment_date affiliate_sales datetime 19 0000-00-00 00:00:00
affiliate_payment_id affiliate_payment int 11  √ 
affiliate_payment_status_history.affiliate_payment_id affiliate_payment_status_history_ibfk_1
affiliate_sales.affiliate_payment_id Implied Constraint
affiliate_payment_id affiliate_payment_status_history int 11 0
affiliate_payment.affiliate_payment_id affiliate_payment_status_history_ibfk_1
affiliate_payment_id affiliate_sales int 11 0
affiliate_payment.affiliate_payment_id Implied Constraint
affiliate_payment_last_modified affiliate_payment datetime 19 0000-00-00 00:00:00
affiliate_payment_paypal affiliate_affiliate varchar 64
affiliate_payment_status affiliate_payment int 5 0
affiliate_payment_status.affiliate_payment_status_id affiliate_payment_ibfk_2
affiliate_payment_status_id affiliate_payment_status int 11 0
affiliate_payment.affiliate_payment_status affiliate_payment_ibfk_2
affiliate_payment_status_name affiliate_payment_status varchar 32
affiliate_payment_tax affiliate_payment decimal 15,2 0.00
affiliate_payment_total affiliate_payment decimal 15,2 0.00
affiliate_percent affiliate_sales decimal 4,2 0.00
affiliate_postcode affiliate_affiliate varchar 10
affiliate_postcode affiliate_payment varchar 10
affiliate_products_id affiliate_banners int 11  √  null
products.products_id affiliate_banners_ibfk_1
affiliate_products_id affiliate_clickthroughs int 11  √  0
products.products_id affiliate_clickthroughs_ibfk_2
affiliate_rgt affiliate_affiliate int 11 0
affiliate_root affiliate_affiliate int 11 0
affiliate_salesman affiliate_sales int 11 0
affiliate_state affiliate_affiliate varchar 32
affiliate_state affiliate_payment varchar 32 0
affiliate_status affiliate_banners int 1 1
affiliate_status_history_id affiliate_payment_status_history int 11  √ 
affiliate_street_address affiliate_affiliate varchar 64
affiliate_street_address affiliate_payment varchar 64
affiliate_suburb affiliate_affiliate varchar 64
affiliate_suburb affiliate_payment varchar 64
affiliate_telephone affiliate_affiliate varchar 32
affiliate_value affiliate_sales decimal 15,2 0.00
affiliate_zone_id affiliate_affiliate int 11 0
amount coupon_gv_customer decimal 8,4 0.0000
amount coupon_gv_queue decimal 8,4 0.0000
answer faq text 65535
approved article_reviews tinyint unsigned 3  √  0
articles_date_added articles datetime 19 0000-00-00 00:00:00
articles_date_available articles datetime 19  √  null
articles_description articles_description text 65535  √  null
articles_head_desc_tag articles_description text 65535  √  null
articles_head_keywords_tag articles_description text 65535  √  null
articles_head_title_tag articles_description varchar 80  √  null
articles_id article_reviews int 11 0
articles.articles_id article_reviews_ibfk_1
articles_id articles int 11  √ 
article_reviews.articles_id article_reviews_ibfk_1
articles_description.articles_id articles_description_ibfk_1
articles_to_topics.articles_id articles_to_topics_ibfk_1
articles_xsell.articles_id articles_xsell_ibfk_1
articles_id articles_description int 11  √ 
articles.articles_id articles_description_ibfk_1
articles_id articles_to_topics int 11 0
articles.articles_id articles_to_topics_ibfk_1
articles_id articles_xsell int 10 1
articles.articles_id articles_xsell_ibfk_1
articles_last_modified articles datetime 19  √  null
articles_name articles_description varchar 64
articles_status articles bit 1 0
articles_url articles_description varchar 255  √  null
articles_viewed articles_description int 5  √  0
association_id zones_to_geo_zones int 11  √ 
auction_buyer_id paypal varchar 64
auction_closing_date paypal datetime 19 0000-00-00 00:00:00
auction_multi_item paypal tinyint 4 0
authors_description authors_info text 65535  √  null
authors_id articles int 11  √  null
authors.authors_id articles_ibfk_1
authors_id authors int 11  √ 
articles.authors_id articles_ibfk_1
authors_info.authors_id authors_info_ibfk_1
authors_id authors_info int 11 0
authors.authors_id authors_info_ibfk_1
authors_image authors varchar 64  √  null
authors_name authors varchar 32
authors_url authors_info varchar 255
bank_name algozone_fraud_queries varchar 20  √ 
bank_phone algozone_fraud_queries varchar 15  √ 
banners_clicked banners_history int 5 0
banners_group banners varchar 10
banners_history_date banners_history datetime 19 0000-00-00 00:00:00
banners_history_id banners_history int 11  √ 
banners_html_text banners text 65535  √  null
banners_id banners int 11  √ 
banners_history.banners_id Implied Constraint
banners_id banners_history int 11 0
banners.banners_id Implied Constraint
banners_image banners varchar 64
banners_shown banners_history int 5 0
banners_title banners varchar 64
banners_url banners varchar 255
billing_address_format_id orders int 5 0
billing_city orders varchar 32
billing_company orders varchar 32  √  null
billing_country orders varchar 32
billing_name orders varchar 64
billing_postcode orders varchar 10
billing_state orders varchar 32  √  null
billing_street_address orders varchar 64
billing_suburb orders varchar 32  √  null
billto orders_session_info int 11 1
bin_country_code algozone_fraud_queries varchar 5  √ 
blacklist_card_number card_blacklist varchar 20
blacklist_id card_blacklist int 5  √ 
box_heading infobox_configuration varchar 64
box_heading infobox_heading varchar 64
box_heading_font_color infobox_configuration varchar 10 #000000
box_template infobox_configuration varchar 64 infobox
box_width_left template varchar 4 125
box_width_right template varchar 4 125
business paypal varchar 96
cart_in_header template char 3 no
cat_id data_cat int 11 0
cat_tree data_cat varchar 254  √  null
categories_date_added faq_categories datetime 19  √  null
categories_date_added pages_categories datetime 19  √  null
categories_description categories_description text 65535  √  null
categories_description faq_categories_description text 65535  √  null
categories_description pages_categories_description text 65535  √  null
categories_head_desc_tag categories_description longtext 2147483647
categories_head_keywords_tag categories_description longtext 2147483647
categories_head_title_tag categories_description varchar 80  √  null
categories_heading_title categories_description varchar 64  √  null
categories_htc_desc_tag categories_description longtext 2147483647  √  null
categories_htc_description categories_description longtext 2147483647  √  null
categories_htc_keywords_tag categories_description longtext 2147483647  √  null
categories_htc_title_tag categories_description varchar 80  √  null
categories_id categories int 11  √ 
affiliate_banners.affiliate_category_id affiliate_banners_ibfk_2
categories_description.categories_id categories_description_ibfk_1
products_to_categories.categories_id products_to_categories_ibfk_2
categories_id categories_description int 11 0
categories.categories_id categories_description_ibfk_1
categories_id faq_categories tinyint unsigned 3  √ 
faq_categories_description.categories_id faq_categories_description_ibfk_1
faq_to_categories.categories_id faq_to_categories_ibfk_2
pages_categories.categories_id Implied Constraint
categories_id faq_categories_description tinyint unsigned 3 0
faq_categories.categories_id faq_categories_description_ibfk_1
categories_id faq_to_categories tinyint unsigned 3 0
faq_categories.categories_id faq_to_categories_ibfk_2
categories_id pages_categories tinyint unsigned 3  √ 
pages_categories_description.categories_id pages_categories_description_ibfk_1
pages_to_categories.categories_id pages_to_categories_ibfk_2
faq_categories.categories_id Implied Constraint
categories_id pages_categories_description tinyint unsigned 3 0
pages_categories.categories_id pages_categories_description_ibfk_1
categories_id pages_to_categories tinyint unsigned 3 0
pages_categories.categories_id pages_to_categories_ibfk_2
categories_id products_to_categories int 11 0
categories.categories_id products_to_categories_ibfk_2
categories_image categories varchar 64  √  null
categories_image faq_categories varchar 64  √  null
categories_image pages_categories varchar 64  √  null
categories_last_modified faq_categories datetime 19  √  null
categories_last_modified pages_categories datetime 19  √  null
categories_name categories_description varchar 32
categories_name faq_categories_description varchar 32
categories_name pages_categories_description varchar 32
categories_sort_order faq_categories int 3  √  null
categories_sort_order pages_categories int 3  √  null
categories_status faq_categories bit 1 0
categories_status pages_categories bit 1 0
cc_bank_phone orders varchar 32
cc_ccv orders varchar 90  √  null
cc_expires orders varchar 90  √  null
cc_issue orders char 3  √  null
cc_number orders varchar 90  √  null
cc_owner orders varchar 64  √  null
cc_start orders varchar 4  √  null
cc_type orders varchar 20  √  null
class orders_total varchar 32
code currencies char 3
code languages char 2
code visual_verify_code varchar 6
comments orders_status_history text 65535  √  null
configuration_description configuration varchar 255
configuration_group_description configuration_group varchar 255
configuration_group_id configuration int 11 0
configuration_group.configuration_group_id configuration_ibfk_1
configuration_group_id configuration_group int 11  √ 
configuration.configuration_group_id configuration_ibfk_1
configuration_group_title configuration_group varchar 64
configuration_id configuration int 11  √ 
configuration_key configuration varchar 64
configuration_title configuration varchar 64
configuration_value configuration varchar 255
content affiliate_newsletters text 65535
content newsletters text 65535
content_type orders_session_info varchar 32
counter counter int 12  √  null
counter counter_history int 12  √  null
countries_id countries int 11  √ 
zones.zone_country_id zones_ibfk_1
zones_to_geo_zones.zone_country_id zones_to_geo_zones_ibfk_2
countries_iso_code_2 countries char 2
countries_iso_code_3 countries char 3
countries_name countries varchar 64
country_code algozone_fraud_queries varchar 21  √ 
coupon_active coupons char 1 Y
coupon_amount coupons decimal 8,4 0.0000
coupon_code coupons varchar 32
coupon_description coupons_description text 65535  √  null
coupon_expire_date coupons datetime 19 0000-00-00 00:00:00
coupon_id coupon_email_track int 11 0
coupons.coupon_id coupon_email_track_ibfk_1
coupon_id coupon_redeem_track int 11 0
coupons.coupon_id coupon_redeem_track_ibfk_1
coupon_id coupons int 11  √ 
coupon_email_track.coupon_id coupon_email_track_ibfk_1
coupon_redeem_track.coupon_id coupon_redeem_track_ibfk_1
coupons_description.coupon_id coupons_description_ibfk_1
coupon_id coupons_description int 11 0
coupons.coupon_id coupons_description_ibfk_1
coupon_minimum_order coupons decimal 8,4 0.0000
coupon_name coupons_description varchar 32
coupon_start_date coupons datetime 19 0000-00-00 00:00:00
coupon_type coupons char 1 F
currencies_id currencies int 11  √ 
currency orders char 3  √  null
currency orders_session_info char 3
currency_value orders decimal 14,6  √  null
currency_value orders_session_info float 13,8  √  null
customer_greeting template char 3 yes
customer_id coupon_gv_customer int 5 0
customers.customers_id coupon_gv_customer_ibfk_1
customer_id coupon_gv_queue int 5 0
customers.customers_id coupon_gv_queue_ibfk_1
customer_id coupon_redeem_track int 11 0
customers.customers_id coupon_redeem_track_ibfk_2
customer_id whos_online int 11  √  null
customer_id_sent coupon_email_track int 11 0
customers.customers_id coupon_email_track_ibfk_2
customer_notified orders_status_history int 1  √  0
customers_address_format_id orders int 5 0
customers_basket_attributes_id customers_basket_attributes int 11  √ 
customers_basket_date_added customers_basket varchar 8  √  null
customers_basket_id customers_basket int 11  √ 
customers_basket_quantity customers_basket int 2 0
customers_city orders varchar 32
customers_company orders varchar 32  √  null
customers_country orders varchar 32
customers_default_address_id customers int 11 0
customers_dob customers datetime 19 0000-00-00 00:00:00
customers_email_address customers varchar 96
customers_email_address orders varchar 96
customers_email_registered customers varchar 32
customers_fax customers varchar 32  √  null
customers_firstname customers varchar 32
customers_gender customers char 1
customers_group_id customers smallint 5 0
customers_group_id customers_groups smallint unsigned 5 0
products_groups.customers_group_id Implied Constraint
specials.customers_group_id Implied Constraint
customers_group_id products_groups smallint unsigned 5 0
customers_groups.customers_group_id Implied Constraint
customers_group_id specials smallint unsigned 5 0
customers_groups.customers_group_id Implied Constraint
customers_group_id specials_retail_prices smallint 6  √  null
customers_group_name customers_groups varchar 32
customers_group_price products_groups decimal 15,4 0.0000
customers_group_price1 products_groups decimal 15,4 0.0000
customers_group_price10 products_groups decimal 15,4 0.0000
customers_group_price11 products_groups decimal 15,4 0.0000
customers_group_price2 products_groups decimal 15,4 0.0000
customers_group_price3 products_groups decimal 15,4 0.0000
customers_group_price4 products_groups decimal 15,4 0.0000
customers_group_price5 products_groups decimal 15,4 0.0000
customers_group_price6 products_groups decimal 15,4 0.0000
customers_group_price7 products_groups decimal 15,4 0.0000
customers_group_price8 products_groups decimal 15,4 0.0000
customers_group_price9 products_groups decimal 15,4 0.0000
customers_group_ra customers enum 2 0
customers_group_show_tax customers_groups enum 2 1
customers_group_tax_exempt customers_groups enum 2 0
customers_id address_book int 11 0
customers.customers_id address_book_ibfk_1
customers_id article_reviews int 11  √  null
customers.customers_id Implied Constraint
customers_id customers int 11  √ 
address_book.customers_id address_book_ibfk_1
article_reviews.customers_id Implied Constraint
coupon_email_track.customer_id_sent coupon_email_track_ibfk_2
coupon_gv_customer.customer_id coupon_gv_customer_ibfk_1
coupon_gv_queue.customer_id coupon_gv_queue_ibfk_1
coupon_redeem_track.customer_id coupon_redeem_track_ibfk_2
customers_basket.customers_id customers_basket_ibfk_1
customers_basket_attributes.customers_id customers_basket_attributes_ibfk_1
customers_info.customers_info_id customers_info_ibfk_1
customers_wishlist.customers_id customers_wishlist_ibfk_2
customers_wishlist_attributes.customers_id customers_wishlist_attributes_ibfk_2
orders.customers_id Implied Constraint
products_notifications.customers_id products_notifications_ibfk_2
reviews.customers_id Implied Constraint
customers_id customers_basket int 11 0
customers.customers_id customers_basket_ibfk_1
customers_id customers_basket_attributes int 11 0
customers.customers_id customers_basket_attributes_ibfk_1
customers_id customers_wishlist int 13 0
customers.customers_id customers_wishlist_ibfk_2
customers_id customers_wishlist_attributes int 11 0
customers.customers_id customers_wishlist_attributes_ibfk_2
customers_id orders int 11 0
customers.customers_id Implied Constraint
customers_id products_notifications int 11 0
customers.customers_id products_notifications_ibfk_2
customers_id reviews int 11  √  null
customers.customers_id Implied Constraint
customers_info_date_account_created customers_info datetime 19  √  null
customers_info_date_account_last_modified customers_info datetime 19  √  null
customers_info_date_of_last_logon customers_info datetime 19  √  null
customers_info_id customers_info int 11 0
customers.customers_id customers_info_ibfk_1
customers_info_number_of_logons customers_info int 5  √  null
customers_lastname customers varchar 32
customers_name article_reviews varchar 64
customers_name orders varchar 64
customers_name reviews varchar 64
customers_newsletter customers char 1  √  null
customers_password customers varchar 40
customers_payment_allowed customers varchar 255
customers_postcode orders varchar 10
customers_selected_template customers varchar 20  √  null
customers_shipment_allowed customers varchar 255
customers_state orders varchar 32  √  null
customers_street_address orders varchar 64
customers_suburb orders varchar 32  √  null
customers_telephone customers varchar 32
customers_telephone orders varchar 32
customers_validation customers char 1 0
customers_validation_code customers varchar 48
customers_wishlist_attributes_id customers_wishlist_attributes int 11  √ 
data_convert_cur data_files varchar 5  √  false
data_cur data_files char 3  √  USD
data_cur_use data_files varchar 5 true
data_files_disc data_files varchar 32 not configured
data_files_id data_files int 11  √ 
data_files_name data_files varchar 64 Not configured
data_files_service data_files varchar 10  √  froogle
data_files_type data_files varchar 11 basic
data_files_type1 data_files varchar 10 product
data_ftp_directory data_files varchar 64  √  null
data_ftp_server data_files varchar 32  √  hedwig.google.com
data_ftp_user_name data_files varchar 32  √  null
data_ftp_user_pass data_files varchar 32  √  null
data_image_url data_files varchar 64  √  null
data_lang_char data_files char 2  √  en
data_lang_use data_files varchar 5 true
data_name data_files varchar 15 No Name
data_product_url data_files varchar 64  √  null
data_status data_files int 1 0
data_tax_class_id data_files int 11  √  null
tax_class.tax_class_id data_files_ibfk_1
date faq date 10 0000-00-00
date_added affiliate_news datetime 19 0000-00-00 00:00:00
date_added affiliate_newsletters datetime 19 0000-00-00 00:00:00
date_added article_reviews datetime 19  √  null
date_added authors datetime 19  √  null
date_added banners datetime 19 0000-00-00 00:00:00
date_added card_blacklist datetime 19  √  null
date_added categories datetime 19  √  null
date_added configuration datetime 19 0000-00-00 00:00:00
date_added email_subjects datetime 19  √  null
date_added events_calendar datetime 19 0000-00-00 00:00:00
date_added geo_zones datetime 19 0000-00-00 00:00:00
date_added infobox_configuration datetime 19 0000-00-00 00:00:00
date_added manufacturers datetime 19  √  null
date_added newsletters datetime 19 0000-00-00 00:00:00
date_added orders_pay_methods datetime 19 0000-00-00 00:00:00
date_added orders_ship_methods datetime 19 0000-00-00 00:00:00
date_added orders_status_history datetime 19 0000-00-00 00:00:00
date_added paypal datetime 19  √  null
date_added paypal_payment_status_history datetime 19 0000-00-00 00:00:00
date_added products_notifications datetime 19 0000-00-00 00:00:00
date_added reviews datetime 19  √  null
date_added tax_class datetime 19 0000-00-00 00:00:00
date_added tax_rates datetime 19 0000-00-00 00:00:00
date_added template datetime 19  √  null
date_added topics datetime 19  √  null
date_added zones_to_geo_zones datetime 19 0000-00-00 00:00:00
date_created coupon_gv_queue datetime 19 0000-00-00 00:00:00
date_created coupons datetime 19 0000-00-00 00:00:00
date_last_click authors_info datetime 19  √  null
date_last_click manufacturers_info datetime 19  √  null
date_modified coupons datetime 19 0000-00-00 00:00:00
date_purchased orders datetime 19  √  null
date_scheduled banners datetime 19  √  null
date_sent affiliate_newsletters datetime 19  √  null
date_sent coupon_email_track datetime 19 0000-00-00 00:00:00
date_sent newsletters datetime 19  √  null
date_status_change banners datetime 19  √  null
date_status_change featured datetime 19  √  null
date_status_change specials datetime 19  √  null
decimal_places currencies char 1  √  null
decimal_point currencies char 1  √  null
delivery_address_format_id orders int 5 0
delivery_city orders varchar 32
delivery_company orders varchar 32  √  null
delivery_country orders varchar 32
delivery_name orders varchar 64
delivery_postcode orders varchar 10
delivery_state orders varchar 32  √  null
delivery_street_address orders varchar 64
delivery_suburb orders varchar 32  √  null
description events_calendar text 65535  √  null
description information text 65535
directory languages varchar 32  √  null
display_in_column infobox_configuration varchar 64 left
distance_k algozone_fraud_queries varchar 10  √ 
distance_m algozone_fraud_queries varchar 10  √ 
download_count orders_products_download int 2 0
download_maxdays orders_products_download int 2 0
dt visual_verify_code timestamp 19  √  CURRENT_TIMESTAMP
edit_customer_greeting_personal template text 65535
edit_customer_greeting_personal_relogon template text 65535
edit_greeting_guest template text 65535
email_subjects_category email_subjects int 1  √  null
email_subjects_id email_subjects int 11  √ 
email_subjects_name email_subjects varchar 64
emailed_to coupon_email_track varchar 32  √  null
end_date events_calendar varchar 20  √  null
entry_city address_book varchar 32
entry_company address_book varchar 32  √  null
entry_company_tax_id address_book varchar 32  √  null
entry_country_id address_book int 11 0
entry_firstname address_book varchar 32
entry_gender address_book char 1
entry_lastname address_book varchar 32
entry_postcode address_book varchar 10
entry_state address_book varchar 32  √  null
entry_street_address address_book varchar 64
entry_suburb address_book varchar 32  √  null
entry_zone_id address_book int 11 0
err_message algozone_fraud_queries varchar 150  √ 
event_id events_calendar int 3  √ 
event_image events_calendar varchar 64  √  null
exchange_rate paypal decimal 4,2  √  null
expires_date banners datetime 19  √  null
expires_date featured datetime 19  √  null
expires_date specials datetime 19  √  null
expires_impressions banners int 7  √  0
expiry sessions int unsigned 11 0
faq_id faq tinyint unsigned 3  √ 
faq_to_categories.faq_id faq_to_categories_ibfk_1
faq_id faq_to_categories tinyint unsigned 3 0
faq.faq_id faq_to_categories_ibfk_1
featured_date_added featured datetime 19  √  null
featured_id featured int 11  √ 
featured_last_modified featured datetime 19  √  null
final_price customers_basket decimal 15,4 0.0000
final_price customers_wishlist decimal 8,2 0.00
final_price orders_products decimal 15,4 0.0000
first_name paypal varchar 32
firstname orders_session_info varchar 32
for_auction paypal varchar 5 false
fraud_level algozone_fraud_queries varchar 5  √ 
full_name whos_online varchar 64
geo_zone_description geo_zones varchar 255
geo_zone_id geo_zones int 11  √ 
zones_to_geo_zones.geo_zone_id zones_to_geo_zones_ibfk_3
geo_zone_id zones_to_geo_zones int 11  √  null
geo_zones.geo_zone_id zones_to_geo_zones_ibfk_3
geo_zone_name geo_zones varchar 32
global_product_notifications customers_info int 1  √  0
group_payment_allowed customers_groups varchar 255
group_shipment_allowed customers_groups varchar 255
http_referer whos_online varchar 255
image languages varchar 64  √  null
include_column_left template varchar 64 yes
include_column_right template varchar 64 yes
info_title information varchar 255
infobox_define infobox_configuration varchar 64 BOX_HEADING_
infobox_display infobox_configuration varchar 5
infobox_file_name infobox_configuration varchar 64
infobox_id infobox_configuration int 11  √ 
infobox_heading.infobox_id infobox_heading_ibfk_1
infobox_id infobox_heading int 11 0
infobox_configuration.infobox_id infobox_heading_ibfk_1
information_id information tinyint unsigned 3  √ 
invoice paypal varchar 64  √  null
ip_address algozone_fraud_queries varchar 30
ip_address whos_online varchar 15
ip_city algozone_fraud_queries varchar 21  √ 
ip_isp algozone_fraud_queries varchar 30  √ 
ip_latitude algozone_fraud_queries varchar 21  √ 
ip_longitude algozone_fraud_queries varchar 21  √ 
ip_org algozone_fraud_queries varchar 30  √ 
ip_region algozone_fraud_queries varchar 21  √ 
ipaddr coupon_gv_queue varchar 32
ipaddy orders varchar 15
ipisp orders varchar 15
is_anonymous_proxy algozone_fraud_queries char 3  √ 
is_bank_name_match algozone_fraud_queries varchar 5  √ 
is_bank_phone_match algozone_fraud_queries varchar 5  √ 
is_bin_match algozone_fraud_queries varchar 5  √ 
is_country_match algozone_fraud_queries char 3  √ 
is_customer_phone_inloc algozone_fraud_queries char 3  √ 
is_free_email algozone_fraud_queries char 3  √ 
is_high_risk_country algozone_fraud_queries varchar 5  √ 
language faq varchar 32
language orders_session_info varchar 32
language_id articles_description int 11 1
languages.languages_id articles_description_ibfk_2
language_id categories_description int 11 1
languages.languages_id categories_description_ibfk_2
language_id coupons_description int 11 0
languages.languages_id coupons_description_ibfk_2
language_id events_calendar int 11 1
languages.languages_id events_calendar_ibfk_1
language_id faq_categories_description int 11 1
languages.languages_id faq_categories_description_ibfk_2
language_id link_categories_description int 11 1
languages.languages_id link_categories_description_ibfk_2
language_id links_description int 11 1
languages.languages_id links_description_ibfk_2
language_id links_status int 11 1
languages.languages_id links_status_ibfk_1
language_id navmenu_categories_description int 11 1
languages.languages_id navmenu_categories_description_ibfk_2
language_id navmenu_links_description int 11 1
languages.languages_id navmenu_links_description_ibfk_2
language_id orders_session_info int 11 1
language_id orders_status int 11 1
languages.languages_id orders_status_ibfk_1
language_id pages_categories_description int 11 1
languages.languages_id pages_categories_description_ibfk_2
language_id pages_description int 11 1
languages.languages_id pages_description_ibfk_2
language_id products_description int 11 1
languages.languages_id products_description_ibfk_2
language_id products_options_text int 11 1
languages.languages_id products_options_text_ibfk_2
language_id products_options_values int 11 1
languages.languages_id products_options_values_ibfk_1
language_id topics_description int 11 1
languages.languages_id topics_description_ibfk_2
languages_id article_reviews_description int 11 0
languages.languages_id article_reviews_description_ibfk_2
languages_id authors_info int 11 0
languages.languages_id authors_info_ibfk_2
languages_id infobox_heading int 11 0
languages.languages_id infobox_heading_ibfk_2
languages_id information int 11 0
languages.languages_id information_ibfk_1
languages_id languages int 11  √ 
affiliate_news_contents.affiliate_news_languages_id affiliate_news_contents_ibfk_2
affiliate_payment_status.affiliate_language_id affiliate_payment_status_ibfk_1
article_reviews_description.languages_id article_reviews_description_ibfk_2
articles_description.language_id articles_description_ibfk_2
authors_info.languages_id authors_info_ibfk_2
categories_description.language_id categories_description_ibfk_2
coupons_description.language_id coupons_description_ibfk_2
events_calendar.language_id events_calendar_ibfk_1
faq_categories_description.language_id faq_categories_description_ibfk_2
infobox_heading.languages_id infobox_heading_ibfk_2
information.languages_id information_ibfk_1
link_categories_description.language_id link_categories_description_ibfk_2
links_description.language_id links_description_ibfk_2
links_status.language_id links_status_ibfk_1
manufacturers_info.languages_id manufacturers_info_ibfk_2
navmenu_categories_description.language_id navmenu_categories_description_ibfk_2
navmenu_links_description.language_id navmenu_links_description_ibfk_2
orders_pay_methods.pay_method_language orders_pay_methods_ibfk_1
orders_ship_methods.ship_method_language orders_ship_methods_ibfk_1
orders_status.language_id orders_status_ibfk_1
pages_categories_description.language_id pages_categories_description_ibfk_2
pages_description.language_id pages_description_ibfk_2
products_description.language_id products_description_ibfk_2
products_extra_fields.languages_id products_extra_fields_ibfk_1
products_options_text.language_id products_options_text_ibfk_2
products_options_values.language_id products_options_values_ibfk_1
reviews_description.languages_id reviews_description_ibfk_2
topics_description.language_id topics_description_ibfk_2
languages_id manufacturers_info int 11 0
languages.languages_id manufacturers_info_ibfk_2
languages_id products_extra_fields int 11 0
languages.languages_id products_extra_fields_ibfk_1
languages_id reviews_description int 11 0
languages.languages_id reviews_description_ibfk_2
languages_in_header template char 3  √  no
last_date_queried algozone_fraud_queries datetime 19  √  0000-00-00 00:00:00
last_modified article_reviews datetime 19  √  null
last_modified authors datetime 19  √  null
last_modified card_blacklist datetime 19  √  null
last_modified categories datetime 19  √  null
last_modified configuration datetime 19  √  null
last_modified email_subjects datetime 19  √  null
last_modified geo_zones datetime 19  √  null
last_modified infobox_configuration datetime 19  √  null
last_modified manufacturers datetime 19  √  null
last_modified orders datetime 19  √  null
last_modified paypal datetime 19  √  null
last_modified reviews datetime 19  √  null
last_modified tax_class datetime 19  √  null
last_modified tax_rates datetime 19  √  null
last_modified template datetime 19  √  null
last_modified topics datetime 19  √  null
last_modified zones_to_geo_zones datetime 19  √  null
last_name paypal varchar 32
last_page_url whos_online varchar 64
last_updated currencies datetime 19  √  null
lastname orders_session_info varchar 32
link events_calendar varchar 255  √  null
link_categories_date_added link_categories datetime 19  √  null
link_categories_description link_categories_description text 65535  √  null
link_categories_id link_categories int 11  √ 
link_categories_description.link_categories_id link_categories_description_ibfk_1
links_to_link_categories.link_categories_id links_to_link_categories_ibfk_2
link_categories_id link_categories_description int 11 0
link_categories.link_categories_id link_categories_description_ibfk_1
link_categories_id links_to_link_categories int 11 0
link_categories.link_categories_id links_to_link_categories_ibfk_2
link_categories_image link_categories varchar 64  √  null
link_categories_last_modified link_categories datetime 19  √  null
link_categories_name link_categories_description varchar 32
link_categories_sort_order link_categories int 3  √  null
link_categories_status link_categories bit 1 0
links_clicked links int 11 0
links_contact_email links varchar 96  √  null
links_contact_name links varchar 64  √  null
links_date_added links datetime 19 0000-00-00 00:00:00
links_description links_description text 65535  √  null
links_id links int 11  √ 
links_description.links_id links_description_ibfk_1
links_to_link_categories.links_id links_to_link_categories_ibfk_1
links_id links_description int 11  √ 
links.links_id links_description_ibfk_1
links_id links_to_link_categories int 11 0
links.links_id links_to_link_categories_ibfk_1
links_image_url links varchar 255  √  null
links_last_modified links datetime 19  √  null
links_rating links bit 1 0
links_reciprocal_url links varchar 255  √  null
links_status links int 11 0
links_status.links_status_id links_ibfk_1
links_status_id links_status int 11 0
links.links_status links_ibfk_1
links_status_name links_status varchar 32
links_title links_description varchar 64
links_url links varchar 255  √  null
location infobox_configuration int 3 0
locked affiliate_newsletters int 1  √  0
locked newsletters int 1  √  0
main_table_border template varchar 6 no
manufacturers_id manufacturers int 11  √ 
manufacturers_info.manufacturers_id manufacturers_info_ibfk_1
products.manufacturers_id products_ibfk_1
manufacturers_id manufacturers_info int 11 0
manufacturers.manufacturers_id manufacturers_info_ibfk_1
manufacturers_id products int 11  √  null
manufacturers.manufacturers_id products_ibfk_1
manufacturers_image manufacturers varchar 64  √  null
manufacturers_name manufacturers varchar 32
manufacturers_url manufacturers_info varchar 255
mc_currency paypal char 3
mc_fee paypal decimal 7,2 0.00
mc_gross paypal decimal 7,2 0.00
memo paypal text 65535  √  null
module affiliate_newsletters varchar 255
module newsletters varchar 255
module_five template varchar 64
module_four template varchar 64
module_one template varchar 64
module_six template varchar 64
module_three template varchar 64
module_two template varchar 64
month counter_history char 8  √  null
name languages varchar 32
news_id affiliate_news int 11  √ 
affiliate_news_contents.affiliate_news_id affiliate_news_contents_ibfk_1
news_status affiliate_news bit 1 0
newsletters_id newsletters int 11  √ 
nmc_date_added navmenu_categories datetime 19  √  null
nmc_id navmenu_categories int 11  √ 
navmenu_categories_description.nmc_id navmenu_categories_description_ibfk_1
navmenu_links_to_categories.nmc_id navmenu_links_to_categories_ibfk_2
nmc_id navmenu_categories_description int 11 0
navmenu_categories.nmc_id navmenu_categories_description_ibfk_1
nmc_id navmenu_links_to_categories int 11 0
navmenu_categories.nmc_id navmenu_links_to_categories_ibfk_2
nmc_name navmenu_categories_description varchar 32
nmc_parent_id navmenu_categories int 11 0
nmc_sort_order navmenu_categories int 3  √  null
nml_date_added navmenu_links datetime 19 0000-00-00 00:00:00
nml_id navmenu_links int 11  √ 
navmenu_links_description.nml_id navmenu_links_description_ibfk_1
navmenu_links_to_categories.nml_id navmenu_links_to_categories_ibfk_1
nml_id navmenu_links_description int 11  √ 
navmenu_links.nml_id navmenu_links_description_ibfk_1
nml_id navmenu_links_to_categories int 11 0
navmenu_links.nml_id navmenu_links_to_categories_ibfk_1
nml_name navmenu_links_description varchar 64
nml_sort_order navmenu_links int 3  √  null
nml_status navmenu_links bit 1 0
nml_url navmenu_links varchar 255
notify_version paypal decimal 2,1 0.0
num_cart_items paypal tinyint unsigned 4 1
options_date_added products_options datetime 19  √  null
options_id products_attributes int 11 0
products_options.products_options_id products_attributes_ibfk_2
options_last_modified products_options datetime 19  √  null
options_length products_options smallint 2 32
options_type products_options int 5 0
options_values_id products_attributes int 11 0
products_options_values.products_options_values_id products_attributes_ibfk_3
options_values_price orders_products_attributes decimal 15,4 0.0000
options_values_price products_attributes decimal 15,4 0.0000
options_values_price products_options_values decimal 15,4 0.0000
order_id algozone_fraud_queries varchar 6
order_id coupon_gv_queue int 5 0
orders.orders_id coupon_gv_queue_ibfk_2
order_id coupon_redeem_track int 11 0
orders_date_finished orders datetime 19  √  null
orders_id orders int 11  √ 
affiliate_sales.affiliate_orders_id affiliate_sales_ibfk_2
coupon_gv_queue.order_id coupon_gv_queue_ibfk_2
orders_products.orders_id orders_products_ibfk_1
orders_products_attributes.orders_id orders_products_attributes_ibfk_1
orders_products_download.orders_id orders_products_download_ibfk_1
orders_session_info.orders_id orders_session_info_ibfk_1
orders_status_history.orders_id Implied Constraint
orders_total.orders_id orders_total_ibfk_1
orders_id orders_products int 11 0
orders.orders_id orders_products_ibfk_1
orders_id orders_products_attributes int 11 0
orders.orders_id orders_products_attributes_ibfk_1
orders_id orders_products_download int 11 0
orders.orders_id orders_products_download_ibfk_1
orders_id orders_session_info int 11 0
orders.orders_id orders_session_info_ibfk_1
orders_id orders_status_history int 11 0
orders.orders_id Implied Constraint
orders_id orders_total int 11 0
orders.orders_id orders_total_ibfk_1
orders_products_attributes_id orders_products_attributes int 11  √ 
orders_products_download_id orders_products_download int 11  √ 
orders_products_filename orders_products_download varchar 255
orders_products_id orders_products int 11  √ 
orders_products_attributes.orders_products_id orders_products_attributes_ibfk_2
orders_products_download.orders_products_id orders_products_download_ibfk_2
orders_products_id orders_products_attributes int 11 0
orders_products.orders_products_id orders_products_attributes_ibfk_2
orders_products_id orders_products_download int 11 0
orders_products.orders_products_id orders_products_download_ibfk_2
orders_status orders int 5 0
orders_status.orders_status_id orders_ibfk_1
orders_status_history_id orders_status_history int 11  √ 
orders_status_id orders_status int 11 0
orders.orders_status orders_ibfk_1
orders_status_id orders_status_history int 5 0
orders_status_name orders_status varchar 32
orders_total_id orders_total int unsigned 10  √ 
oscsid visual_verify_code varchar 32
pages_author pages varchar 255
pages_blurb pages_description text 65535  √  null
pages_body pages_description text 65535  √  null
pages_date_added pages timestamp 19  √  CURRENT_TIMESTAMP
pages_date_modified pages timestamp 19  √  0000-00-00 00:00:00
pages_id pages tinyint unsigned 3  √ 
pages_description.pages_id pages_description_ibfk_1
pages_to_categories.pages_id pages_to_categories_ibfk_1
pages_id pages_description tinyint unsigned 3 0
pages.pages_id pages_description_ibfk_1
pages_id pages_to_categories tinyint unsigned 3 0
pages.pages_id pages_to_categories_ibfk_1
pages_image pages varchar 64  √  null
pages_meta_description pages_description varchar 255  √  null
pages_meta_keywords pages_description varchar 255  √  null
pages_meta_title pages_description varchar 80  √  null
pages_sort_order pages tinyint 3 0
pages_status pages tinyint 3 1
pages_title pages_description varchar 255
parent_id categories int 11 0
parent_id topics int 11 0
parent_txn_id paypal varchar 17  √  null
pay_method orders_pay_methods varchar 255
pay_method_language orders_pay_methods int 11 1
languages.languages_id orders_pay_methods_ibfk_1
pay_method_sort orders_pay_methods int 3 0
pay_methods_id orders_pay_methods int 11  √ 
payer_business_name paypal varchar 64  √  null
payer_email paypal varchar 96
payer_id paypal varchar 32
payer_status paypal varchar 10
payment orders_session_info varchar 32
payment_amount orders_session_info decimal 7,2 0.00
payment_currency orders_session_info char 3
payment_currency_val orders_session_info float 13,8  √  null
payment_date paypal datetime 19  √  null
payment_fee paypal decimal 7,2  √  null
payment_gross paypal decimal 7,2  √  null
payment_id orders int 11 0
payment_info orders text 65535  √  null
payment_method orders varchar 32
payment_status paypal varchar 17
payment_status paypal_payment_status_history varchar 17
payment_status_history_id paypal_payment_status_history int 11  √ 
payment_time_zone paypal varchar 4
payment_title orders_session_info varchar 32
payment_type paypal varchar 7
paypal_id paypal int 11  √ 
paypal_payment_status_history.paypal_id paypal_payment_status_history_ibfk_1
paypal_id paypal_payment_status_history int 11 0
paypal.paypal_id paypal_payment_status_history_ibfk_1
paypal_ipn_id orders int 11 0
pending_reason paypal varchar 14  √  null
pending_reason paypal_payment_status_history varchar 14  √  null
po_number orders varchar 12  √  null
price_prefix orders_products_attributes char 1
price_prefix products_attributes char 1
products_attributes_filename products_attributes_download varchar 255
products_attributes_id products_attributes int 11  √ 
products_attributes_download.products_attributes_id products_attributes_download_ibfk_1
products_attributes_id products_attributes_download int 11 0
products_attributes.products_attributes_id products_attributes_download_ibfk_1
products_attributes_maxcount products_attributes_download int 2  √  0
products_attributes_maxdays products_attributes_download int 2  √  0
products_date_added products datetime 19 0000-00-00 00:00:00
products_date_available products datetime 19  √  null
products_description products_description text 65535  √  null
products_extra_fields_id products_extra_fields int 11  √ 
products_to_products_extra_fields.products_extra_fields_id products_to_products_extra_fields_ibfk_2
products_extra_fields_id products_to_products_extra_fields int 11 0
products_extra_fields.products_extra_fields_id products_to_products_extra_fields_ibfk_2
products_extra_fields_name products_extra_fields varchar 64
products_extra_fields_order products_extra_fields int 3 0
products_extra_fields_status products_extra_fields bit 1 0
products_extra_fields_value products_to_products_extra_fields varchar 64  √  null
products_head_desc_tag products_description longtext 2147483647
products_head_keywords_tag products_description longtext 2147483647
products_head_title_tag products_description varchar 80  √  null
products_id customers_basket tinytext 255
products_id customers_basket_attributes tinytext 255
products_id customers_wishlist int 13 0
products.products_id customers_wishlist_ibfk_1
products_id customers_wishlist_attributes int 11 0
products.products_id customers_wishlist_attributes_ibfk_1
products_id featured int 11 0
products.products_id featured_ibfk_1
products_id orders_products int 11 0
specials_retail_prices.products_id Implied Constraint
products_id products int 11  √ 
affiliate_banners.affiliate_products_id affiliate_banners_ibfk_1
affiliate_clickthroughs.affiliate_products_id affiliate_clickthroughs_ibfk_2
articles_xsell.xsell_id articles_xsell_ibfk_2
customers_wishlist.products_id customers_wishlist_ibfk_1
customers_wishlist_attributes.products_id customers_wishlist_attributes_ibfk_1
featured.products_id featured_ibfk_1
products.products_parent_id products_ibfk_3
products_attributes.products_id products_attributes_ibfk_1
products_description.products_id products_description_ibfk_1
products_groups.products_id products_groups_ibfk_1
products_notifications.products_id products_notifications_ibfk_1
products_to_categories.products_id products_to_categories_ibfk_1
products_to_products_extra_fields.products_id products_to_products_extra_fields_ibfk_1
products_xsell.products_id products_xsell_ibfk_1
products_xsell.xsell_id products_xsell_ibfk_2
reviews.products_id reviews_ibfk_1
specials.products_id specials_ibfk_1
specials_retail_prices.products_id specials_retail_prices_ibfk_1
products_id products_attributes int 11 0
products.products_id products_attributes_ibfk_1
products_id products_description int 11  √ 
products.products_id products_description_ibfk_1
products_id products_groups int 11 0
products.products_id products_groups_ibfk_1
products_id products_notifications int 11 0
products.products_id products_notifications_ibfk_1
products_id products_to_categories int 11 0
products.products_id products_to_categories_ibfk_1
products_id products_to_products_extra_fields int 11 0
products.products_id products_to_products_extra_fields_ibfk_1
products_id products_xsell int 10 1
products.products_id products_xsell_ibfk_1
products_id reviews int 11 0
products.products_id reviews_ibfk_1
products_id specials int 11 0
products.products_id specials_ibfk_1
products_id specials_retail_prices int 11 0
orders_products.products_id Implied Constraint
products.products_id specials_retail_prices_ibfk_1
products_image products varchar 64  √  null
products_image_lrg products varchar 64  √  null
products_image_med products varchar 64  √  null
products_image_sm_1 products varchar 64  √  null
products_image_sm_2 products varchar 64  √  null
products_image_sm_3 products varchar 64  √  null
products_image_sm_4 products varchar 64  √  null
products_image_sm_5 products varchar 64  √  null
products_image_sm_6 products varchar 64  √  null
products_image_xl_1 products varchar 64  √  null
products_image_xl_2 products varchar 64  √  null
products_image_xl_3 products varchar 64  √  null
products_image_xl_4 products varchar 64  √  null
products_image_xl_5 products varchar 64  √  null
products_image_xl_6 products varchar 64  √  null
products_last_modified products datetime 19  √  null
products_model customers_wishlist varchar 13  √  null
products_model orders_products varchar 12  √  null
products_model products varchar 25  √  null
products_name customers_wishlist varchar 64
products_name orders_products varchar 64
products_name products_description varchar 64
products_options orders_products_attributes varchar 32
products_options_id customers_basket_attributes int 11 0
products_options.products_options_id Implied Constraint
products_options_id customers_wishlist_attributes int 11 0
products_options.products_options_id Implied Constraint
products_options_id orders_products_attributes int 11 0
products_options.products_options_id Implied Constraint
products_options_id products_options int 11 0
customers_basket_attributes.products_options_id Implied Constraint
customers_wishlist_attributes.products_options_id Implied Constraint
orders_products_attributes.products_options_id Implied Constraint
products_attributes.options_id products_attributes_ibfk_2
products_options_text.products_options_text_id products_options_text_ibfk_1
products_options_values_to_products_options.products_options_id products_options_values_to_products_options_ibfk_1
products_options_id products_options_values_to_products_options int 11 0
products_options.products_options_id products_options_values_to_products_options_ibfk_1
products_options_instruct products_options_text varchar 64  √  null
products_options_name products_options_text varchar 32
products_options_sort_order products_attributes int 6 0
products_options_sort_order products_options int 4 0
products_options_text_id products_options_text int 11 0
products_options.products_options_id products_options_text_ibfk_1
products_options_value_id customers_basket_attributes int 11 0
products_options_value_id customers_wishlist_attributes int 11 0
products_options_value_text customers_basket_attributes text 65535
products_options_values orders_products_attributes varchar 32
products_options_values_id orders_products_attributes int 11 0
products_options_values_id products_options_values int 11 0
products_attributes.options_values_id products_attributes_ibfk_3
products_options_values_to_products_options.products_options_values_id products_options_values_to_products_options_ibfk_2
products_options_values_id products_options_values_to_products_options int 11 0
products_options_values.products_options_values_id products_options_values_to_products_options_ibfk_2
products_options_values_name products_options_values varchar 64
products_options_values_to_products_options_id products_options_values_to_products_options int 11  √ 
products_ordered products int 11 0
products_parent_id products int 11 0
products.products_id products_ibfk_3
products_price customers_wishlist decimal 8,2 0.00
products_price orders_products decimal 15,4 0.0000
products_price products decimal 15,4 0.0000
products_price1 products decimal 15,4 0.0000
products_price10 products decimal 15,4 0.0000
products_price10_qty products int 11 0
products_price11 products decimal 15,4 0.0000
products_price11_qty products int 11 0
products_price1_qty products int 11 0
products_price2 products decimal 15,4 0.0000
products_price2_qty products int 11 0
products_price3 products decimal 15,4 0.0000
products_price3_qty products int 11 0
products_price4 products decimal 15,4 0.0000
products_price4_qty products int 11 0
products_price5 products decimal 15,4 0.0000
products_price5_qty products int 11 0
products_price6 products decimal 15,4 0.0000
products_price6_qty products int 11 0
products_price7 products decimal 15,4 0.0000
products_price7_qty products int 11 0
products_price8 products decimal 15,4 0.0000
products_price8_qty products int 11 0
products_price9 products decimal 15,4 0.0000
products_price9_qty products int 11 0
products_qty_blocks products int 11 1
products_quantity customers_wishlist int 2 0
products_quantity orders_products int 2 0
products_quantity products int 4 0
products_status products bit 1 0
products_tax orders_products decimal 7,4 0.0000
products_tax_class_id products int 11  √  null
tax_class.tax_class_id products_ibfk_2
products_url products_description varchar 255  √  null
products_viewed products_description int 5  √  0
products_weight products decimal 5,2 0.00
proxy_level algozone_fraud_queries varchar 5  √ 
purchased_without_account customers bit 1 0
purchased_without_account orders bit 1 0
quantity paypal int 11 0
question faq text 65535
reason_code paypal varchar 15  √  null
reason_code paypal_payment_status_history varchar 15  √  null
receiver_email paypal varchar 96
receiver_id paypal varchar 32
redeem_date coupon_redeem_track datetime 19 0000-00-00 00:00:00
redeem_ip coupon_redeem_track varchar 32
release_flag coupon_gv_queue char 1 N
restrict_to_categories coupons varchar 255  √  null
restrict_to_customers coupons text 65535  √  null
restrict_to_products coupons varchar 255  √  null
reviews_id article_reviews int 11  √ 
article_reviews_description.reviews_id article_reviews_description_ibfk_1
reviews.reviews_id Implied Constraint
reviews_id article_reviews_description int 11 0
article_reviews.reviews_id article_reviews_description_ibfk_1
reviews_id reviews int 11  √ 
article_reviews.reviews_id Implied Constraint
reviews_description.reviews_id reviews_description_ibfk_1
reviews_id reviews_description int 11 0
reviews.reviews_id reviews_description_ibfk_1
reviews_rating article_reviews int 1  √  null
reviews_rating reviews int 1  √  null
reviews_read article_reviews int 5 0
reviews_read reviews int 5 0
reviews_text article_reviews_description text 65535
reviews_text reviews_description text 65535
sale_categories_all salemaker_sales varchar 255  √  null
sale_categories_selected salemaker_sales varchar 255  √  null
sale_date_added salemaker_sales date 10 0000-00-00
sale_date_end salemaker_sales date 10 0000-00-00
sale_date_last_modified salemaker_sales date 10 0000-00-00
sale_date_start salemaker_sales date 10 0000-00-00
sale_date_status_change salemaker_sales date 10 0000-00-00
sale_deduction_type salemaker_sales tinyint 4 0
sale_deduction_value salemaker_sales decimal 15,4 0.0000
sale_id salemaker_sales int 11  √ 
sale_name salemaker_sales varchar 30
sale_pricerange_from salemaker_sales decimal 15,4 0.0000
sale_pricerange_to salemaker_sales decimal 15,4 0.0000
sale_specials_condition salemaker_sales tinyint 4 0
sale_status salemaker_sales tinyint 4 0
sendto orders_session_info int 11 1
sent_firstname coupon_email_track varchar 32  √  null
sent_lastname coupon_email_track varchar 32  √  null
session_id whos_online varchar 128
sesskey sessions varchar 32
set_function configuration varchar 255  √  null
settle_amount paypal decimal 7,2  √  null
settle_currency paypal char 3  √  null
ship_method orders_ship_methods varchar 255
ship_method_language orders_ship_methods int 11 1
languages.languages_id orders_ship_methods_ibfk_1
ship_method_sort orders_ship_methods int 3 0
ship_methods_id orders_ship_methods int 11  √ 
show_header_link_buttons template char 3 no
show_heading_title_original template varchar 6 yes
side_box_left_width template int 10  √  1
side_box_right_width template int 10  √  1
site_width template varchar 5 100%
sort_order articles_xsell int unsigned 10 1
sort_order categories int 3  √  null
sort_order configuration int 5  √  null
sort_order configuration_group int 5  √  null
sort_order languages int 3  √  null
sort_order orders_total int 11 0
sort_order products_xsell int unsigned 10 1
sort_order topics int 3  √  null
spam_level algozone_fraud_queries varchar 5  √ 
specials_date_added specials datetime 19  √  null
specials_id specials int 11  √ 
specials_last_modified specials datetime 19  √  null
specials_new_products_price specials decimal 15,4 0.0000
specials_new_products_price specials_retail_prices decimal 15,4 0.0000
start_date events_calendar date 10 0000-00-00
startdate counter char 8  √  null
status affiliate_newsletters int 1  √  null
status banners int 1 1
status featured int 1  √  1
status newsletters int 1  √  null
status specials int 1 1
status specials_retail_prices tinyint 4  √  null
symbol_left currencies varchar 12  √  null
symbol_right currencies varchar 12  √  null
tax paypal decimal 7,2  √  null
tax_class_description tax_class varchar 255
tax_class_id tax_class int 11  √ 
data_files.data_tax_class_id data_files_ibfk_1
products.products_tax_class_id products_ibfk_2
tax_rates.tax_class_id tax_rates_ibfk_1
tax_class_id tax_rates int 11 0
tax_class.tax_class_id tax_rates_ibfk_1
tax_class_title tax_class varchar 32
tax_description tax_rates varchar 255
tax_priority tax_rates int 5  √  1
tax_rate tax_rates decimal 7,4 0.0000
tax_rates_id tax_rates int 11  √ 
tax_zone_id tax_rates int 11 0
template_cellpadding_left template char 3 0
template_cellpadding_main template char 3 0
template_cellpadding_right template char 3 0
template_cellpadding_sub template char 3 0
template_id infobox_configuration int 3 0
template.template_id infobox_configuration_ibfk_1
template_id template int 11  √ 
infobox_configuration.template_id infobox_configuration_ibfk_1
template_image template varchar 64  √  null
template_name template varchar 64  √  0
text orders_total varchar 255
thousands_point currencies char 1  √  null
time_entry whos_online varchar 14
time_last_click whos_online varchar 14
title affiliate_newsletters varchar 255
title currencies varchar 32
title events_calendar varchar 255  √  null
title newsletters varchar 255
title orders_total varchar 255
topics_description topics_description text 65535  √  null
topics_heading_title topics_description varchar 64  √  null
topics_id articles_to_topics int 11 0
topics.topics_id articles_to_topics_ibfk_2
topics_id topics int 11  √ 
articles_to_topics.topics_id articles_to_topics_ibfk_2
topics_description.topics_id topics_description_ibfk_1
topics_id topics_description int 11 0
topics.topics_id topics_description_ibfk_1
topics_image topics varchar 64  √  null
topics_name topics_description varchar 32
txn_id paypal varchar 17
txn_signature orders_session_info varchar 32
txn_type paypal varchar 10
unique_id coupon_email_track int 11  √ 
coupon_redeem_track.unique_id Implied Constraint
unique_id coupon_gv_queue int 5  √ 
unique_id coupon_redeem_track int 11  √ 
coupon_email_track.unique_id Implied Constraint
url_clicked authors_info int 5 0
url_clicked manufacturers_info int 5 0
use_function configuration varchar 255  √  null
user_agent whos_online varchar 255
uses_per_coupon coupons int 5 1
uses_per_user coupons int 5 0
v_order faq tinyint unsigned 3 0
v_order information tinyint unsigned 3 0
value currencies float 13,8  √  null
value orders_total decimal 15,4 0.0000
value sessions text 65535
verify_sign paypal varchar 128
visible configuration_group int 1  √  1
visible faq enum 2 1
visible information enum 2 1
wishlist_name customers_wishlist varchar 64  √  null
xsell_id articles_xsell int 10 1
products.products_id articles_xsell_ibfk_2
xsell_id products_xsell int 10 1
products.products_id products_xsell_ibfk_2
zone_code zones varchar 32
zone_country_id zones int 11 0
countries.countries_id zones_ibfk_1
zone_country_id zones_to_geo_zones int 11 0
countries.countries_id zones_to_geo_zones_ibfk_2
zone_id zones int 11  √ 
zones_to_geo_zones.zone_id zones_to_geo_zones_ibfk_1
zone_id zones_to_geo_zones int 11  √  null
zones.zone_id zones_to_geo_zones_ibfk_1
zone_name zones varchar 32