Table openx.ox_affiliates Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
affiliateid mediumint 7  √ 
ox_affiliates_extra.affiliateid Defined in XML
ox_ext_market_website_pref.affiliateid Defined in XML
ox_variable_publisher.publisher_id Defined in XML
ox_zones.affiliateid Defined in XML
agencyid mediumint 7 0
ox_agency.agencyid Defined in XML
name varchar 255
ox_ext_market_general_pref.name Implied Constraint
mnemonic varchar 5
comments text 65535  √  null
contact varchar 255  √  null
email varchar 64
website varchar 255  √  null
updated datetime 0
an_website_id int 10  √  null
oac_country_code char 2
oac_language_id int 10  √  null
oac_category_id int 10  √  null
as_website_id int 10  √  null
account_id mediumint 7  √  null
ox_ext_market_assoc_data.publisher_account_id Defined in XML
ox_accounts.account_id Defined in XML

Table contained 3 rows at Sat Feb 28 16:58 EST 2009

Indexes:
Column(s) Type Sort Constraint Name Anomalies
affiliateid Primary key Asc PRIMARY  
account_id Must be unique Asc ox_affiliates_account_id This unique column is also nullable
agencyid Performance Asc ox_affiliates_agencyid  

Close relationships  within of separation: