SchemaSpy Analysis of clean.public - Anomalies

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
  audit_log_event.audit_id	audit_event.audit_id
  audit_user_login.id	study_module_status.id
  authorities.id	study_module_status.id
  coding_dictionary.id	study_module_status.id
  configuration.id	study_module_status.id
  dyn_item_form_metadata.id	study_module_status.id
  dyn_item_group_metadata.id	study_module_status.id
  entity_type.id	databasechangeloglock.id
  group_auth_definition.id	study_module_status.id
  locale_based_description.id	study_module_status.id
  measurement_unit.id	study_module_status.id
  oc_qrtz_fired_triggers.instance_name	oc_qrtz_scheduler_state.instance_name
  oc_qrtz_fired_triggers.trigger_group	oc_qrtz_paused_trigger_grps.trigger_group
  oc_qrtz_triggers.calendar_name	oc_qrtz_calendars.calendar_name
  oc_qrtz_triggers.trigger_group	oc_qrtz_paused_trigger_grps.trigger_group
  openclinica_version.id	study_module_status.id
  permission.id	study_module_status.id
  role.id	study_module_status.id
  role_permission.id	study_module_status.id
  rule.id	study_module_status.id
  rule_action.id	study_module_status.id
  rule_action_property.id	study_module_status.id
  rule_action_run.id	study_module_status.id
  rule_action_run_log.id	study_module_status.id
  rule_expression.id	study_module_status.id
  rule_set.id	study_module_status.id
  rule_set_audit.id	study_module_status.id
  rule_set_rule.id	study_module_status.id
  rule_set_rule_audit.id	study_module_status.id
  scd_item_metadata.id	study_module_status.id
  thesaurus.id	study_module_status.id
  usage_statistics_data.id	study_module_status.id
  user_role_access.id	study_module_status.id

  33 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  audit_event_values	0
  authorities	1
  role_privilege_map	0
  versioning_map	0

  4 instances of anomaly detected

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

  Column
  configuration.key
  permission.access_parameters
  permission.access_url
  study_parameter.handle

  4 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  oc_qrtz_locks	lock_name
  oc_qrtz_paused_trigger_grps	trigger_group

  2 instances of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:
  Anomaly not detected

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