Table openx.ox_audit 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
auditid mediumint 7  √ 
actionid mediumint 7
context varchar 255
contextid mediumint 7  √  null
parentid mediumint 7  √  null
details text 65535
userid mediumint 7 0
username varchar 64  √  null
usertype tinyint 3 0
updated datetime 0  √  null
account_id mediumint 7
ox_accounts.account_id Defined in XML
advertiser_account_id mediumint 7  √  null
ox_accounts.account_id Defined in XML
website_account_id mediumint 7  √  null
ox_accounts.account_id Defined in XML

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

Indexes:
Column(s) Type Sort Constraint Name
auditid Primary key Asc PRIMARY
account_id Performance Asc ox_audit_account_id
advertiser_account_id Performance Asc ox_audit_advertiser_account_id
context + actionid Performance Asc/Asc ox_audit_context_actionid
parentid + contextid Performance Asc/Asc ox_audit_parentid_contextid
updated Performance Asc ox_audit_updated
username Performance Asc ox_audit_username
usertype Performance Asc ox_audit_usertype
website_account_id Performance Asc ox_audit_website_account_id

Close relationships  within of separation: