SchemaSpy Analysis of openx - Anomalies Openx database

Generated by SchemaSpy

Things that might not be 'quite right' about your schema:

• Columns whose name and type imply a relationship to another table's primary key:

  Child Column	Implied Parent Column
  ox_affiliates.name	ox_ext_market_general_pref.name
  ox_agency.account_id	ox_ext_market_assoc_data.account_id
  ox_agency.name	ox_ext_market_general_pref.name
  ox_banners.campaignid	ox_campaigns.campaignid
  ox_campaigns.clientid	ox_clients.clientid
  ox_channel.affiliateid	ox_affiliates_extra.affiliateid
  ox_channel.agencyid	ox_agency.agencyid
  ox_channel.name	ox_ext_market_general_pref.name
  ox_trackers.clientid	ox_clients.clientid

  9 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  ox_ext_market_setting	0
  ox_targetstats	0

  2 instances of anomaly detected

• Columns that are flagged as both 'nullable' and 'must be unique':

  Column
  ox_affiliates.account_id
  ox_agency.account_id
  ox_clients.account_id
  ox_users.sso_user_id
  ox_users.username

  5 instances of anomaly detected

• Tables that contain a single column:
  Anomaly not detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  ox_database_action

  1 instance of anomaly detected

• Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
  Anomaly not detected