Table schema_generation.affiliate_banners
InnoDB free: 7168 kB; (`affiliate_products_id`) REFER `schema_generation/product

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
affiliate_banners_id int 11  √ 
affiliate_banners_history.affiliate_banners_id Implied Constraint
affiliate_banners_title varchar 64
affiliate_products_id int 11  √  null
products.products_id affiliate_banners_ibfk_1
affiliate_category_id int 11  √  null
categories.categories_id affiliate_banners_ibfk_2
affiliate_banners_image varchar 64
affiliate_banners_group varchar 10
affiliate_banners_html_text text 65535  √  null
affiliate_expires_impressions int 7  √  0
affiliate_expires_date datetime 19  √  null
affiliate_date_scheduled datetime 19  √  null
affiliate_date_added datetime 19 0000-00-00 00:00:00
affiliate_date_status_change datetime 19  √  null
affiliate_status int 1 1

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

Indexes:
Column(s) Type Sort Constraint Name
affiliate_banners_id Primary key Asc PRIMARY
affiliate_category_id Performance Asc affiliate_category_id
affiliate_products_id Performance Asc affiliate_products_id

Close relationships  within one two degrees of separation :