SchemaSpy Analysis of master_kaltura - Anomalies Kaltura 1 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:
  Anomaly not detected

• Tables without indexes:

  Table	Rows
  tmp	0

  1 instance of anomaly detected

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

  Column
  partner_activity.activity
  partner_activity.activity_date
  partner_activity.partner_id
  partner_activity.sub_activity
  unique_visitors_cookie.date
  unique_visitors_cookie.uv_id
  unique_visitors_ip.date
  unique_visitors_ip.ip

  8 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  blocked_email	email

  1 instance of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  kshow
  kwidget_log
  partner
  partner_activity
  partner_stats
  widget_log

  6 instances 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