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

Generated by
SchemaSpy
Implied relationships 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_id int 11 0
affiliate_affiliate.affiliate_id affiliate_sales_ibfk_1
affiliate_date datetime 19 0000-00-00 00:00:00
affiliate_browser varchar 100
affiliate_ipaddress varchar 20
affiliate_orders_id int 11 0
orders.orders_id affiliate_sales_ibfk_2
affiliate_value decimal 15,2 0.00
affiliate_payment decimal 15,2 0.00
affiliate_clickthroughs_id int 11 0
affiliate_billing_status int 5 0
affiliate_payment_date datetime 19 0000-00-00 00:00:00
affiliate_payment_id int 11 0
affiliate_payment.affiliate_payment_id Implied Constraint
affiliate_percent decimal 4,2 0.00
affiliate_salesman int 11 0

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

Indexes:
Column(s) Type Sort Constraint Name
affiliate_orders_id + affiliate_id Primary key Asc/Asc PRIMARY
affiliate_id Performance Asc affiliate_id

Close relationships  within one two degrees of separation :