Table openx.ox_users 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
user_id mediumint 7  √ 
ox_account_user_assoc.user_id Defined in XML
ox_account_user_permission_assoc.user_id Defined in XML
ox_password_recovery.user_id Defined in XML
ox_userlog.userid Defined in XML
contact_name varchar 255
email_address varchar 64
username varchar 64  √  null
password varchar 64  √  null
language varchar 5  √  null
default_account_id mediumint 7  √  null
ox_accounts.account_id Defined in XML
comments text 65535  √  null
active bit 0 1
sso_user_id int 10  √  null
date_created datetime 0  √  null
date_last_login datetime 0  √  null
email_updated datetime 0  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
user_id Primary key Asc PRIMARY  
sso_user_id Must be unique Asc ox_users_sso_user_id This unique column is also nullable
username Must be unique Asc ox_users_username This unique column is also nullable

Close relationships  within of separation: