Table schema_generation.products
InnoDB free: 7168 kB; (`manufacturers_id`) REFER `schema_generation/manufacturer

 Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
products_id 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_quantity int 4 0
products_model varchar 25  √  null
products_image varchar 64  √  null
products_image_med varchar 64  √  null
products_image_lrg varchar 64  √  null
products_image_sm_1 varchar 64  √  null
products_image_xl_1 varchar 64  √  null
products_image_sm_2 varchar 64  √  null
products_image_xl_2 varchar 64  √  null
products_image_sm_3 varchar 64  √  null
products_image_xl_3 varchar 64  √  null
products_image_sm_4 varchar 64  √  null
products_image_xl_4 varchar 64  √  null
products_image_sm_5 varchar 64  √  null
products_image_xl_5 varchar 64  √  null
products_image_sm_6 varchar 64  √  null
products_image_xl_6 varchar 64  √  null
products_price decimal 15,4 0.0000
products_date_added datetime 19 0000-00-00 00:00:00
products_last_modified datetime 19  √  null
products_date_available datetime 19  √  null
products_weight decimal 5,2 0.00
products_status bit 1 0
products_tax_class_id int 11  √  null
tax_class.tax_class_id products_ibfk_2
manufacturers_id int 11  √  null
manufacturers.manufacturers_id products_ibfk_1
products_ordered int 11 0
products_parent_id int 11 0
products.products_id products_ibfk_3
products_price1 decimal 15,4 0.0000
products_price2 decimal 15,4 0.0000
products_price3 decimal 15,4 0.0000
products_price4 decimal 15,4 0.0000
products_price5 decimal 15,4 0.0000
products_price6 decimal 15,4 0.0000
products_price7 decimal 15,4 0.0000
products_price8 decimal 15,4 0.0000
products_price9 decimal 15,4 0.0000
products_price10 decimal 15,4 0.0000
products_price11 decimal 15,4 0.0000
products_price1_qty int 11 0
products_price2_qty int 11 0
products_price3_qty int 11 0
products_price4_qty int 11 0
products_price5_qty int 11 0
products_price6_qty int 11 0
products_price7_qty int 11 0
products_price8_qty int 11 0
products_price9_qty int 11 0
products_price10_qty int 11 0
products_price11_qty int 11 0
products_qty_blocks int 11 1

Table contained 0 rows at Mon Jun 18 16:54 CDT 2007

Indexes:
Column(s) Type Sort Constraint Name
products_id Primary key Asc PRIMARY
products_date_added Performance Asc idx_products_date_added
manufacturers_id Performance Asc manufacturers_id
products_parent_id Performance Asc products_parent_id
products_tax_class_id Performance Asc products_tax_class_id

Close relationships  within one two degrees of separation :