Table schema_generation.affiliate_clickthroughs
InnoDB free: 7168 kB; (`affiliate_id`) REFER `schema_generation/affiliate_affili

 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_clickthrough_id int 11  √ 
affiliate_id int 11 0
affiliate_affiliate.affiliate_id affiliate_clickthroughs_ibfk_1
affiliate_clientdate datetime 19 0000-00-00 00:00:00
affiliate_clientbrowser varchar 200  √  Could Not Find This Data
affiliate_clientip varchar 50  √  Could Not Find This Data
affiliate_clientreferer varchar 200  √  None Detected (Perhaps a direct link)
affiliate_products_id int 11  √  0
products.products_id affiliate_clickthroughs_ibfk_2
affiliate_banner_id int 11 0

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

Indexes:
Column(s) Type Sort Constraint Name
affiliate_clickthrough_id Primary key Asc PRIMARY
affiliate_products_id Performance Asc affiliate_products_id
affiliate_id Performance Asc refid

Close relationships  within one two degrees of separation :