Table openx.ox_agency 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
agencyid mediumint 7  √ 
ox_affiliates.agencyid Defined in XML
ox_channel.agencyid Implied Constraint
ox_clients.agencyid Defined in XML
name varchar 255
ox_ext_market_general_pref.name Implied Constraint
contact varchar 255  √  null
email varchar 64
logout_url varchar 255  √  null
active smallint 5  √  0
updated datetime 0
account_id mediumint 7  √  null
ox_ext_market_assoc_data.account_id Implied Constraint

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

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

Close relationships  within of separation: