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
address_book_id address_book int 11  √ 
address_format_id address_format int 11  √ 
countries.address_format_id countries_ibfk_1
admin_files_id admin_files int 11  √ 
admin_groups_id admin_groups int 11  √ 
admin.admin_groups_id admin_ibfk_1
admin_id admin int 11  √ 
affiliate_banners_history_id affiliate_banners_history int 11  √ 
affiliate_banners_id affiliate_banners int 11  √ 
affiliate_banners_history.affiliate_banners_id Implied Constraint
affiliate_clickthrough_id affiliate_clickthroughs int 11  √ 
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_news_contents_id affiliate_news_contents int 11  √ 
affiliate_newsletters_id affiliate_newsletters int 11  √ 
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_status_history_id affiliate_payment_status_history int 11  √ 
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
association_id zones_to_geo_zones int 11  √ 
authors_id authors int 11  √ 
articles.authors_id articles_ibfk_1
authors_info.authors_id authors_info_ibfk_1
banners_history_id banners_history int 11  √ 
banners_id banners int 11  √ 
banners_history.banners_id Implied Constraint
blacklist_id card_blacklist int 5  √ 
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 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 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
configuration_group_id configuration_group int 11  √ 
configuration.configuration_group_id configuration_ibfk_1
configuration_id configuration int 11  √ 
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
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
currencies_id currencies int 11  √ 
customers_basket_attributes_id customers_basket_attributes int 11  √ 
customers_basket_id customers_basket int 11  √ 
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_wishlist_attributes_id customers_wishlist_attributes int 11  √ 
data_files_id data_files int 11  √ 
email_subjects_id email_subjects int 11  √ 
event_id events_calendar int 3  √ 
faq_id faq tinyint unsigned 3  √ 
faq_to_categories.faq_id faq_to_categories_ibfk_1
featured_id featured int 11  √ 
geo_zone_id geo_zones int 11  √ 
zones_to_geo_zones.geo_zone_id zones_to_geo_zones_ibfk_3
infobox_id infobox_configuration int 11  √ 
infobox_heading.infobox_id infobox_heading_ibfk_1
information_id information tinyint unsigned 3  √ 
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
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
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
manufacturers_id manufacturers int 11  √ 
manufacturers_info.manufacturers_id manufacturers_info_ibfk_1
products.manufacturers_id products_ibfk_1
news_id affiliate_news int 11  √ 
affiliate_news_contents.affiliate_news_id affiliate_news_contents_ibfk_1
newsletters_id newsletters int 11  √ 
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
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
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_products_attributes_id orders_products_attributes int 11  √ 
orders_products_download_id orders_products_download int 11  √ 
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_status_history_id orders_status_history int 11  √ 
orders_total_id orders_total int unsigned 10  √ 
pages_id pages tinyint unsigned 3  √ 
pages_description.pages_id pages_description_ibfk_1
pages_to_categories.pages_id pages_to_categories_ibfk_1
pay_methods_id orders_pay_methods int 11  √ 
payment_status_history_id paypal_payment_status_history int 11  √ 
paypal_id paypal int 11  √ 
paypal_payment_status_history.paypal_id paypal_payment_status_history_ibfk_1
products_attributes_id products_attributes int 11  √ 
products_attributes_download.products_attributes_id products_attributes_download_ibfk_1
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_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_description int 11  √ 
products.products_id products_description_ibfk_1
products_options_values_to_products_options_id products_options_values_to_products_options int 11  √ 
reviews_id article_reviews int 11  √ 
article_reviews_description.reviews_id article_reviews_description_ibfk_1
reviews.reviews_id Implied Constraint
reviews_id reviews int 11  √ 
article_reviews.reviews_id Implied Constraint
reviews_description.reviews_id reviews_description_ibfk_1
sale_id salemaker_sales int 11  √ 
ship_methods_id orders_ship_methods int 11  √ 
specials_id specials int 11  √ 
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_rates_id tax_rates int 11  √ 
template_id template int 11  √ 
infobox_configuration.template_id infobox_configuration_ibfk_1
topics_id topics int 11  √ 
articles_to_topics.topics_id articles_to_topics_ibfk_2
topics_description.topics_id topics_description_ibfk_1
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
zone_id zones int 11  √ 
zones_to_geo_zones.zone_id zones_to_geo_zones_ibfk_1
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_city paypal varchar 32  √  null
address_country paypal varchar 64  √  null
address_format address_format varchar 128
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_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_name admin_groups varchar 64  √  null
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_html_text affiliate_banners text 65535  √  null
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_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_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