Table schema_generation.affiliate_payment
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_payment_id int 11  √ 
affiliate_payment_status_history.affiliate_payment_id affiliate_payment_status_history_ibfk_1
affiliate_sales.affiliate_payment_id Implied Constraint
affiliate_id int 11 0
affiliate_affiliate.affiliate_id affiliate_payment_ibfk_1
affiliate_payment decimal 15,2 0.00
affiliate_payment_tax decimal 15,2 0.00
affiliate_payment_total decimal 15,2 0.00
affiliate_payment_date datetime 19 0000-00-00 00:00:00
affiliate_payment_last_modified datetime 19 0000-00-00 00:00:00
affiliate_payment_status int 5 0
affiliate_payment_status.affiliate_payment_status_id affiliate_payment_ibfk_2
affiliate_firstname varchar 32
affiliate_lastname varchar 32
affiliate_street_address varchar 64
affiliate_suburb varchar 64
affiliate_city varchar 32
affiliate_postcode varchar 10
affiliate_country varchar 32 0
affiliate_company varchar 60
affiliate_state varchar 32 0
affiliate_address_format_id int 5 0
affiliate_last_modified datetime 19 0000-00-00 00:00:00

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

Indexes:
Column(s) Type Sort Constraint Name
affiliate_payment_id Primary key Asc PRIMARY
affiliate_id Performance Asc affiliate_id
affiliate_payment_status Performance Asc affiliate_payment_status

Close relationships  within one two degrees of separation :