SchemaSpy Analysis of transmart.i2b2demodata - 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
  archive_observation_fact.patient_num	patient_dimension.patient_num
  archive_observation_fact.upload_id	upload_status.upload_id
  async_job.id	storage_system.id
  code_lookup.upload_id	upload_status.upload_id
  encounter_mapping.upload_id	upload_status.upload_id
  jms_roles.userid	jms_users.userid
  linked_file_collection.id	storage_system.id
  observation_fact.patient_num	patient_dimension.patient_num
  observation_fact.sample_cd	sample_dimension.sample_cd
  observation_fact.upload_id	upload_status.upload_id
  patient_dimension.upload_id	upload_status.upload_id
  patient_mapping.patient_num	patient_dimension.patient_num
  patient_mapping.upload_id	upload_status.upload_id
  provider_dimension.upload_id	upload_status.upload_id
  qt_analysis_plugin_result_type.plugin_id	qt_analysis_plugin.plugin_id
  qt_pdo_query_master.query_master_id	qt_query_master.query_master_id
  qt_privilege.plugin_id	qt_analysis_plugin.plugin_id
  qt_query_master.plugin_id	qt_analysis_plugin.plugin_id
  relation_type.id	set_type.id
  ricerca.concept_path	concept_dimension.concept_path
  sample_categories.sample_cd	sample_dimension.sample_cd
  set_upload_status.source_cd	source_master.source_cd
  supported_workflow.id	storage_system.id
  upload_status.source_cd	source_master.source_cd
  visit_dimension.upload_id	upload_status.upload_id

  25 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  cd	0
  counter	0
  crc_db_lookup	0
  datamart_report	0
  dimloader	0
  hilosequences	0
  jms_transactions	0
  map	0
  modifier_metadata	0
  news_updates	0
  patient_trial	0
  qt_breakdown_path	0
  qt_patient_sample_collection	0
  qt_privilege	6
  ricerca	0
  sample_categories	0

  16 instances of anomaly detected

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

• Tables that contain a single column:

  Table	Column
  jms_transactions	txid
  sample_dimension	sample_cd

  2 instances of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  sample_categories

  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