| SchemaSpy Analysis of schema_generation | Generated by SchemaSpy |
| Generated by SchemaSpy on Mon Jun 18 16:54 CDT 2007 | |
| Database Type: MySQL - 5.0.22 |
Please support this project |
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
123 Tables:
Total rows: 0
| Table | Children | Parents | Rows | Comments |
|---|---|---|---|---|
| address_book | 1 | 0 | InnoDB free: 7168 kB; (`customers_id`) REFER `schema_generation/customers`(`cust | |
| address_format | 1 | 0 | InnoDB free: 7168 kB | |
| admin | 1 | 0 | InnoDB free: 7168 kB; (`admin_groups_id`) REFER `schema_generation/admin_groups` | |
| admin_files | 0 | InnoDB free: 7168 kB | ||
| admin_groups | 1 | 0 | InnoDB free: 7168 kB | |
| affiliate_affiliate | 3 | 0 | InnoDB free: 7168 kB | |
| affiliate_banners | 2 | 0 | InnoDB free: 7168 kB; (`affiliate_products_id`) REFER `schema_generation/product | |
| affiliate_banners_history | 0 | InnoDB free: 7168 kB | ||
| affiliate_clickthroughs | 2 | 0 | InnoDB free: 7168 kB; (`affiliate_id`) REFER `schema_generation/affiliate_affili | |
| affiliate_news | 1 | 0 | InnoDB free: 7168 kB | |
| affiliate_news_contents | 2 | 0 | InnoDB free: 7168 kB; (`affiliate_news_id`) REFER `schema_generation/affiliate_n | |
| affiliate_newsletters | 0 | InnoDB free: 7168 kB | ||
| affiliate_payment | 1 | 2 | 0 | InnoDB free: 7168 kB; (`affiliate_id`) REFER `schema_generation/affiliate_affili |
| affiliate_payment_status | 1 | 1 | 0 | InnoDB free: 7168 kB; (`affiliate_language_id`) REFER `schema_generation/languag |
| affiliate_payment_status_history | 1 | 0 | InnoDB free: 7168 kB; (`affiliate_payment_id`) REFER `schema_generation/affiliat | |
| affiliate_sales | 2 | 0 | InnoDB free: 7168 kB; (`affiliate_id`) REFER `schema_generation/affiliate_affili | |
| algozone_fraud_queries | 0 | InnoDB free: 7168 kB | ||
| article_reviews | 1 | 1 | 0 | InnoDB free: 7168 kB; (`articles_id`) REFER `schema_generation/articles`(`articl |
| article_reviews_description | 2 | 0 | InnoDB free: 7168 kB; (`reviews_id`) REFER `schema_generation/article_reviews`(` | |
| articles | 4 | 1 | 0 | InnoDB free: 7168 kB; (`authors_id`) REFER `schema_generation/authors`(`authors_ |
| articles_description | 2 | 0 | InnoDB free: 7168 kB; (`articles_id`) REFER `schema_generation/articles`(`articl | |
| articles_to_topics | 2 | 0 | InnoDB free: 7168 kB; (`articles_id`) REFER `schema_generation/articles`(`articl | |
| articles_xsell | 2 | 0 | InnoDB free: 7168 kB; (`articles_id`) REFER `schema_generation/articles`(`articl | |
| authors | 2 | 0 | InnoDB free: 7168 kB | |
| authors_info | 2 | 0 | InnoDB free: 7168 kB; (`authors_id`) REFER `schema_generation/authors`(`authors_ | |
| banners | 0 | InnoDB free: 7168 kB | ||
| banners_history | 0 | InnoDB free: 7168 kB | ||
| card_blacklist | 0 | InnoDB free: 7168 kB | ||
| categories | 3 | 0 | InnoDB free: 7168 kB | |
| categories_description | 2 | 0 | InnoDB free: 7168 kB; (`categories_id`) REFER `schema_generation/categories`(`ca | |
| configuration | 1 | 0 | InnoDB free: 7168 kB; (`configuration_group_id`) REFER `schema_generation/config | |
| configuration_group | 1 | 0 | InnoDB free: 7168 kB | |
| counter | 0 | InnoDB free: 7168 kB | ||
| counter_history | 0 | InnoDB free: 7168 kB | ||
| countries | 2 | 1 | 0 | InnoDB free: 7168 kB; (`address_format_id`) REFER `schema_generation/address_for |
| coupon_email_track | 2 | 0 | InnoDB free: 7168 kB; (`coupon_id`) REFER `schema_generation/coupons`(`coupon_id | |
| coupon_gv_customer | 1 | 0 | InnoDB free: 7168 kB; (`customer_id`) REFER `schema_generation/customers`(`custo | |
| coupon_gv_queue | 2 | 0 | InnoDB free: 7168 kB; (`customer_id`) REFER `schema_generation/customers`(`custo | |
| coupon_redeem_track | 2 | 0 | InnoDB free: 7168 kB; (`coupon_id`) REFER `schema_generation/coupons`(`coupon_id | |
| coupons | 3 | 0 | InnoDB free: 7168 kB | |
| coupons_description | 2 | 0 | InnoDB free: 7168 kB; (`coupon_id`) REFER `schema_generation/coupons`(`coupon_id | |
| currencies | 0 | InnoDB free: 7168 kB | ||
| customers | 11 | 0 | InnoDB free: 7168 kB | |
| customers_basket | 1 | 0 | InnoDB free: 7168 kB; (`customers_id`) REFER `schema_generation/customers`(`cust | |
| customers_basket_attributes | 1 | 0 | InnoDB free: 7168 kB; (`customers_id`) REFER `schema_generation/customers`(`cust | |
| customers_groups | 0 | InnoDB free: 7168 kB | ||
| customers_info | 1 | 0 | InnoDB free: 7168 kB; (`customers_info_id`) REFER `schema_generation/customers`( | |
| customers_wishlist | 2 | 0 | InnoDB free: 7168 kB; (`products_id`) REFER `schema_generation/products`(`produc | |
| customers_wishlist_attributes | 2 | 0 | InnoDB free: 7168 kB; (`products_id`) REFER `schema_generation/products`(`produc | |
| data_cat | 0 | InnoDB free: 7168 kB | ||
| data_files | 1 | 0 | InnoDB free: 7168 kB; (`data_tax_class_id`) REFER `schema_generation/tax_class`( | |
| email_subjects | 0 | InnoDB free: 7168 kB | ||
| events_calendar | 1 | 0 | InnoDB free: 7168 kB; (`language_id`) REFER `schema_generation/languages`(`langu | |
| faq | 1 | 0 | InnoDB free: 7168 kB | |
| faq_categories | 2 | 0 | InnoDB free: 7168 kB | |
| faq_categories_description | 2 | 0 | InnoDB free: 7168 kB; (`categories_id`) REFER `schema_generation/faq_categories` | |
| faq_to_categories | 2 | 0 | InnoDB free: 7168 kB; (`faq_id`) REFER `schema_generation/faq`(`faq_id`) ON UPDA | |
| featured | 1 | 0 | InnoDB free: 7168 kB; (`products_id`) REFER `schema_generation/products`(`produc | |
| geo_zones | 1 | 0 | InnoDB free: 7168 kB | |
| infobox_configuration | 1 | 1 | 0 | InnoDB free: 7168 kB; (`template_id`) REFER `schema_generation/template`(`templa |
| infobox_heading | 2 | 0 | InnoDB free: 7168 kB; (`infobox_id`) REFER `schema_generation/infobox_configurat | |
| information | 1 | 0 | InnoDB free: 7168 kB; (`languages_id`) REFER `schema_generation/languages`(`lang | |
| languages | 28 | 0 | InnoDB free: 7168 kB | |
| link_categories | 2 | 0 | InnoDB free: 7168 kB | |
| link_categories_description | 2 | 0 | InnoDB free: 7168 kB; (`link_categories_id`) REFER `schema_generation/link_categ | |
| links | 2 | 1 | 0 | InnoDB free: 7168 kB; (`links_status`) REFER `schema_generation/links_status`(`l |
| links_description | 2 | 0 | InnoDB free: 7168 kB; (`links_id`) REFER `schema_generation/links`(`links_id`) O | |
| links_status | 1 | 1 | 0 | InnoDB free: 7168 kB; (`language_id`) REFER `schema_generation/languages`(`langu |
| links_to_link_categories | 2 | 0 | InnoDB free: 7168 kB; (`links_id`) REFER `schema_generation/links`(`links_id`) O | |
| manufacturers | 2 | 0 | InnoDB free: 7168 kB | |
| manufacturers_info | 2 | 0 | InnoDB free: 7168 kB; (`manufacturers_id`) REFER `schema_generation/manufacturer | |
| navmenu_categories | 2 | 0 | InnoDB free: 7168 kB | |
| navmenu_categories_description | 2 | 0 | InnoDB free: 7168 kB; (`nmc_id`) REFER `schema_generation/navmenu_categories`(`n | |
| navmenu_links | 2 | 0 | InnoDB free: 7168 kB | |
| navmenu_links_description | 2 | 0 | InnoDB free: 7168 kB; (`nml_id`) REFER `schema_generation/navmenu_links`(`nml_id | |
| navmenu_links_to_categories | 2 | 0 | InnoDB free: 7168 kB; (`nml_id`) REFER `schema_generation/navmenu_links`(`nml_id | |
| newsletters | 0 | InnoDB free: 7168 kB | ||
| orders | 7 | 1 | 0 | InnoDB free: 7168 kB; (`orders_status`) REFER `schema_generation/orders_status`( |
| orders_pay_methods | 1 | 0 | InnoDB free: 7168 kB; (`pay_method_language`) REFER `schema_generation/languages | |
| orders_products | 2 | 1 | 0 | InnoDB free: 7168 kB; (`orders_id`) REFER `schema_generation/orders`(`orders_id` |
| orders_products_attributes | 2 | 0 | InnoDB free: 7168 kB; (`orders_id`) REFER `schema_generation/orders`(`orders_id` | |
| orders_products_download | 2 | 0 | InnoDB free: 7168 kB; (`orders_id`) REFER `schema_generation/orders`(`orders_id` | |
| orders_session_info | 1 | 0 | InnoDB free: 7168 kB; (`orders_id`) REFER `schema_generation/orders`(`orders_id` | |
| orders_ship_methods | 1 | 0 | InnoDB free: 7168 kB; (`ship_method_language`) REFER `schema_generation/language | |
| orders_status | 1 | 1 | 0 | InnoDB free: 7168 kB; (`language_id`) REFER `schema_generation/languages`(`langu |
| orders_status_history | 0 | InnoDB free: 7168 kB | ||
| orders_total | 1 | 0 | InnoDB free: 7168 kB; (`orders_id`) REFER `schema_generation/orders`(`orders_id` | |
| pages | 2 | 0 | InnoDB free: 7168 kB | |
| pages_categories | 2 | 0 | InnoDB free: 7168 kB | |
| pages_categories_description | 2 | 0 | InnoDB free: 7168 kB; (`categories_id`) REFER `schema_generation/pages_categorie | |
| pages_description | 2 | 0 | InnoDB free: 7168 kB; (`pages_id`) REFER `schema_generation/pages`(`pages_id`) O | |
| pages_to_categories | 2 | 0 | InnoDB free: 7168 kB; (`pages_id`) REFER `schema_generation/pages`(`pages_id`) O | |
| paypal | 1 | 0 | InnoDB free: 7168 kB | |
| paypal_payment_status_history | 1 | 0 | InnoDB free: 7168 kB; (`paypal_id`) REFER `schema_generation/paypal`(`paypal_id` | |
| products | 18 | 3 | 0 | InnoDB free: 7168 kB; (`manufacturers_id`) REFER `schema_generation/manufacturer |
| products_attributes | 1 | 3 | 0 | InnoDB free: 7168 kB; (`products_id`) REFER `schema_generation/products`(`produc |
| products_attributes_download | 1 | 0 | InnoDB free: 7168 kB; (`products_attributes_id`) REFER `schema_generation/produc | |
| products_description | 2 | 0 | InnoDB free: 7168 kB; (`products_id`) REFER `schema_generation/products`(`produc | |
| products_extra_fields | 1 | 1 | 0 | InnoDB free: 7168 kB; (`languages_id`) REFER `schema_generation/languages`(`lang |
| products_groups | 1 | 0 | InnoDB free: 7168 kB; (`products_id`) REFER `schema_generation/products`(`produc | |
| products_notifications | 2 | 0 | InnoDB free: 7168 kB; (`products_id`) REFER `schema_generation/products`(`produc | |
| products_options | 3 | 0 | InnoDB free: 7168 kB | |
| products_options_text | 2 | 0 | InnoDB free: 7168 kB; (`products_options_text_id`) REFER `schema_generation/prod | |
| products_options_values | 2 | 1 | 0 | InnoDB free: 7168 kB; (`language_id`) REFER `schema_generation/languages`(`langu |
| products_options_values_to_products_options | 2 | 0 | InnoDB free: 7168 kB; (`products_options_id`) REFER `schema_generation/products_ | |
| products_to_categories | 2 | 0 | InnoDB free: 7168 kB; (`products_id`) REFER `schema_generation/products`(`produc | |
| products_to_products_extra_fields | 2 | 0 | InnoDB free: 7168 kB; (`products_id`) REFER `schema_generation/products`(`produc | |
| products_xsell | 2 | 0 | InnoDB free: 7168 kB; (`products_id`) REFER `schema_generation/products`(`produc | |
| reviews | 1 | 1 | 0 | InnoDB free: 7168 kB; (`products_id`) REFER `schema_generation/products`(`produc |
| reviews_description | 2 | 0 | InnoDB free: 7168 kB; (`reviews_id`) REFER `schema_generation/reviews`(`reviews_ | |
| salemaker_sales | 0 | InnoDB free: 7168 kB | ||
| sessions | 0 | InnoDB free: 7168 kB | ||
| specials | 1 | 0 | InnoDB free: 7168 kB; (`products_id`) REFER `schema_generation/products`(`produc | |
| specials_retail_prices | 1 | 0 | InnoDB free: 7168 kB; (`products_id`) REFER `schema_generation/products`(`produc | |
| tax_class | 3 | 0 | InnoDB free: 7168 kB | |
| tax_rates | 1 | 0 | InnoDB free: 7168 kB; (`tax_class_id`) REFER `schema_generation/tax_class`(`tax_ | |
| template | 1 | 0 | InnoDB free: 7168 kB | |
| topics | 2 | 0 | InnoDB free: 7168 kB | |
| topics_description | 2 | 0 | InnoDB free: 7168 kB; (`topics_id`) REFER `schema_generation/topics`(`topics_id` | |
| visual_verify_code | 0 | InnoDB free: 7168 kB | ||
| whos_online | 0 | InnoDB free: 7168 kB | ||
| zones | 1 | 1 | 0 | InnoDB free: 7168 kB; (`zone_country_id`) REFER `schema_generation/countries`(`c |
| zones_to_geo_zones | 3 | 0 | InnoDB free: 7168 kB; (`zone_id`) REFER `schema_generation/zones`(`zone_id`) ON |