Table openx.ox_clients 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
clientid mediumint 7  √ 
ox_campaigns.clientid Implied Constraint
ox_trackers.clientid Implied Constraint
agencyid mediumint 7 0
ox_agency.agencyid Defined in XML
clientname varchar 255
contact varchar 255  √  null
email varchar 64
report enum 2 t
reportinterval mediumint 7 7
reportlastdate date 0 0000-00-00
reportdeactivate enum 2 t
comments text 65535  √  null
updated datetime 0
lb_reporting bit 0 0
an_adnetwork_id int 10  √  null
as_advertiser_id int 10  √  null
account_id mediumint 7  √  null
ox_accounts.account_id Defined in XML
advertiser_limitation bit 0 0

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

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

Close relationships  within of separation: