Table openx.ox_accounts 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
account_id mediumint 7  √ 
ox_account_preference_assoc.account_id Defined in XML
ox_account_user_assoc.account_id Defined in XML
ox_account_user_permission_assoc.account_id Defined in XML
ox_affiliates.account_id Defined in XML
ox_audit.account_id Defined in XML
ox_audit.advertiser_account_id Defined in XML
ox_audit.website_account_id Defined in XML
ox_clients.account_id Defined in XML
ox_ext_market_assoc_data.account_id Defined in XML
ox_users.default_account_id Defined in XML
account_type varchar 16
account_name varchar 255  √  null
m2m_password varchar 32  √  null
m2m_ticket varchar 32  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
account_id Primary key Asc PRIMARY
account_type Performance Asc ox_accounts_account_type

Close relationships  within of separation: