SchemaSpy Analysis of iliasRelease_3_9_x_branch - 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
  acc_cache.user_id	member_export_user_settings.user_id
  addressbook.user_id	member_export_user_settings.user_id
  addressbook_mailing_lists_assignments.ml_id	addressbook_mailing_lists.ml_id
  adv_md_field_definition.record_id	chat_records.record_id
  adv_md_record_objs.record_id	adv_md_record.record_id
  adv_md_values.field_id	adv_md_field_definition.field_id
  adv_md_values.obj_id	ut_lp_settings.obj_id
  aicc_course.obj_id	ut_lp_settings.obj_id
  aicc_object.obj_id	ut_lp_settings.obj_id
  aicc_units.obj_id	ut_lp_settings.obj_id
  ass_log.question_fi	qpl_question_matching.question_fi
  ass_log.ref_id	object_reference.ref_id
  bookmark_data.obj_id	ut_lp_settings.obj_id
  bookmark_data.user_id	member_export_user_settings.user_id
  chat_blocked.usr_id	ut_lp_filter.usr_id
  chat_invitations.room_id	chat_rooms.room_id
  chat_record_data.record_id	chat_records.record_id
  chat_records.room_id	chat_rooms.room_id
  chat_room_messages.room_id	chat_rooms.room_id
  chat_user.room_id	chat_rooms.room_id
  chat_user.usr_id	ut_lp_filter.usr_id
  cmi_comment.cmi_node_id	cmi_node.cmi_node_id
  cmi_correct_response.cmi_interaction_id	cmi_interaction.cmi_interaction_id
  cmi_gobjective.user_id	member_export_user_settings.user_id
  cmi_interaction.cmi_node_id	cmi_node.cmi_node_id
  cmi_node.cp_node_id	cp_node.cp_node_id
  cmi_node.user_id	member_export_user_settings.user_id
  cmi_objective.cmi_interaction_id	cmi_interaction.cmi_interaction_id
  cmi_objective.cmi_node_id	cmi_node.cmi_node_id
  conditions.id	dp_properties.ID
  container_settings.id	dp_properties.ID
  container_sorting.obj_id	ut_lp_settings.obj_id
  container_sorting_settings.obj_id	ut_lp_settings.obj_id
  content_object.id	dp_properties.ID
  cp_auxilaryResource.cp_node_id	cp_node.cp_node_id
  cp_condition.cp_node_id	cp_node.cp_node_id
  cp_dependency.cp_node_id	cp_node.cp_node_id
  cp_file.cp_node_id	cp_node.cp_node_id
  cp_hidelmsui.cp_node_id	cp_node.cp_node_id
  cp_item.cp_node_id	cp_node.cp_node_id
  cp_manifest.cp_node_id	cp_node.cp_node_id
  cp_mapinfo.cp_node_id	cp_node.cp_node_id
  cp_objective.cp_node_id	cp_node.cp_node_id
  cp_organization.cp_node_id	cp_node.cp_node_id
  cp_package.obj_id	ut_lp_settings.obj_id
  cp_resource.cp_node_id	cp_node.cp_node_id
  cp_rule.cp_node_id	cp_node.cp_node_id
  cp_sequencing.cp_node_id	cp_node.cp_node_id
  cp_suspend.obj_id	ut_lp_settings.obj_id
  cp_suspend.user_id	member_export_user_settings.user_id
  cp_tree.obj_id	ut_lp_settings.obj_id
  crs_defined_field_definitions.field_id	adv_md_field_definition.field_id
  crs_defined_field_definitions.obj_id	ut_lp_settings.obj_id
  crs_file.file_id	file_data.file_id
  crs_items.obj_id	ut_lp_settings.obj_id
  crs_lm_history.usr_id	ut_lp_filter.usr_id
  crs_members.obj_id	ut_lp_settings.obj_id
  crs_members.usr_id	ut_lp_filter.usr_id
  crs_objective_lm.obj_id	ut_lp_settings.obj_id
  crs_objective_lm.objective_id	crs_objectives.objective_id
  crs_objective_lm.ref_id	object_reference.ref_id
  crs_objective_qst.obj_id	ut_lp_settings.obj_id
  crs_objective_qst.objective_id	crs_objectives.objective_id
  crs_objective_qst.question_id	qpl_questions.question_id
  crs_objective_qst.ref_id	object_reference.ref_id
  crs_objective_results.question_id	qpl_questions.question_id
  crs_objective_results.usr_id	ut_lp_filter.usr_id
  crs_objective_status.objective_id	crs_objectives.objective_id
  crs_objective_status.user_id	member_export_user_settings.user_id
  crs_objective_status_pretest.objective_id	crs_objectives.objective_id
  crs_objective_status_pretest.user_id	member_export_user_settings.user_id
  crs_objective_tst.obj_id	ut_lp_settings.obj_id
  crs_objective_tst.objective_id	crs_objectives.objective_id
  crs_objective_tst.ref_id	object_reference.ref_id
  crs_settings.obj_id	ut_lp_settings.obj_id
  crs_subscribers.obj_id	ut_lp_settings.obj_id
  crs_subscribers.usr_id	ut_lp_filter.usr_id
  crs_timings_planed.usr_id	ut_lp_filter.usr_id
  crs_timings_usr_accept.usr_id	ut_lp_filter.usr_id
  crs_user_data.field_id	adv_md_field_definition.field_id
  crs_user_data.usr_id	ut_lp_filter.usr_id
  crs_waiting_list.obj_id	ut_lp_settings.obj_id
  crs_waiting_list.usr_id	ut_lp_filter.usr_id
  ctrl_classfile.class	service_class.class
  dbk_translations.id	dp_properties.ID
  desktop_item.user_id	member_export_user_settings.user_id
  dp_changed_dates.ID	dp_properties.ID
  dp_changed_dates.user_ID	member_export_user_settings.user_id
  dp_dates.ID	dp_properties.ID
  dp_dates.user_ID	member_export_user_settings.user_id
  dp_keyword.ID	dp_properties.ID
  dp_keyword.user_ID	member_export_user_settings.user_id
  dp_keywords.ID	dp_properties.ID
  dp_neg_dates.ID	dp_properties.ID
  dp_neg_dates.user_ID	member_export_user_settings.user_id
  dp_properties.user_ID	member_export_user_settings.user_id
  ecs_export.obj_id	ut_lp_settings.obj_id
  ecs_import.obj_id	ut_lp_settings.obj_id
  event.obj_id	ut_lp_settings.obj_id
  event_appointment.event_id	event.event_id
  event_file.event_id	event.event_id
  event_file.file_id	file_data.file_id
  event_items.event_id	event.event_id
  event_participants.event_id	event.event_id
  event_participants.usr_id	ut_lp_filter.usr_id
  exc_data.obj_id	ut_lp_settings.obj_id
  exc_members.obj_id	ut_lp_settings.obj_id
  exc_members.usr_id	ut_lp_filter.usr_id
  exc_returned.obj_id	ut_lp_settings.obj_id
  exc_returned.user_id	member_export_user_settings.user_id
  exc_usr_tutor.obj_id	ut_lp_settings.obj_id
  exc_usr_tutor.usr_id	ut_lp_filter.usr_id
  feedback_items.obj_id	ut_lp_settings.obj_id
  feedback_items.ref_id	object_reference.ref_id
  feedback_results.fb_id	feedback_items.fb_id
  feedback_results.user_id	member_export_user_settings.user_id
  file_based_lm.id	dp_properties.ID
  file_usage.id	dp_properties.ID
  frm_notification.user_id	member_export_user_settings.user_id
  frm_settings.obj_id	ut_lp_settings.obj_id
  frm_thread_access.obj_id	ut_lp_settings.obj_id
  frm_thread_access.usr_id	ut_lp_filter.usr_id
  frm_user_read.obj_id	ut_lp_settings.obj_id
  frm_user_read.usr_id	ut_lp_filter.usr_id
  glossary.id	dp_properties.ID
  glossary_definition.id	dp_properties.ID
  glossary_term.id	dp_properties.ID
  grp_registration.grp_id	grp_data.grp_id
  grp_registration.user_id	member_export_user_settings.user_id
  history.id	dp_properties.ID
  history.obj_id	ut_lp_settings.obj_id
  history.usr_id	ut_lp_filter.usr_id
  il_custom_block.id	dp_properties.ID
  il_external_feed_block.id	dp_properties.ID
  il_html_block.id	dp_properties.ID
  il_md_copyright_selections.entry_id	chat_room_messages.entry_id
  il_media_cast_data.id	dp_properties.ID
  il_meta_annotation.obj_id	ut_lp_settings.obj_id
  il_meta_classification.obj_id	ut_lp_settings.obj_id
  il_meta_contribute.obj_id	ut_lp_settings.obj_id
  il_meta_description.obj_id	ut_lp_settings.obj_id
  il_meta_educational.obj_id	ut_lp_settings.obj_id
  il_meta_entity.obj_id	ut_lp_settings.obj_id
  il_meta_format.obj_id	ut_lp_settings.obj_id
  il_meta_general.obj_id	ut_lp_settings.obj_id
  il_meta_identifier.obj_id	ut_lp_settings.obj_id
  il_meta_identifier_.obj_id	ut_lp_settings.obj_id
  il_meta_keyword.obj_id	ut_lp_settings.obj_id
  il_meta_language.obj_id	ut_lp_settings.obj_id
  il_meta_lifecycle.obj_id	ut_lp_settings.obj_id
  il_meta_location.obj_id	ut_lp_settings.obj_id
  il_meta_meta_data.obj_id	ut_lp_settings.obj_id
  il_meta_relation.obj_id	ut_lp_settings.obj_id
  il_meta_requirement.obj_id	ut_lp_settings.obj_id
  il_meta_rights.obj_id	ut_lp_settings.obj_id
  il_meta_taxon.obj_id	ut_lp_settings.obj_id
  il_meta_taxon_path.obj_id	ut_lp_settings.obj_id
  il_meta_technical.obj_id	ut_lp_settings.obj_id
  il_meta_typical_age_range.obj_id	ut_lp_settings.obj_id
  il_news_item.id	dp_properties.ID
  il_news_item.user_id	member_export_user_settings.user_id
  il_news_read.user_id	member_export_user_settings.user_id
  il_news_subscription.ref_id	object_reference.ref_id
  il_news_subscription.user_id	member_export_user_settings.user_id
  ilinc_data.obj_id	ilinc_registration.obj_id
  ilinc_registration.usr_id	usr_data.usr_id
  ldap_attribute_mapping.server_id	ldap_server_settings.server_id
  ldap_role_assignments.role_id	role_data.role_id
  ldap_role_assignments.server_id	ldap_server_settings.server_id
  ldap_role_group_mapping.server_id	ldap_server_settings.server_id
  link_check.obj_id	ut_lp_settings.obj_id
  link_check_report.obj_id	ut_lp_settings.obj_id
  link_check_report.usr_id	ut_lp_filter.usr_id
  lm_data.obj_id	ut_lp_settings.obj_id
  lm_menu.id	dp_properties.ID
  lo_access.obj_id	ut_lp_settings.obj_id
  lo_access.usr_id	ut_lp_filter.usr_id
  mail.user_id	member_export_user_settings.user_id
  mail_attachment.mail_id	mail.mail_id
  mail_obj_data.obj_id	ut_lp_settings.obj_id
  mail_obj_data.user_id	member_export_user_settings.user_id
  mail_options.user_id	member_export_user_settings.user_id
  mail_saved.user_id	member_export_user_settings.user_id
  media_item.id	dp_properties.ID
  member_agreement.obj_id	ut_lp_settings.obj_id
  member_agreement.usr_id	ut_lp_filter.usr_id
  meta_data.obj_id	ut_lp_settings.obj_id
  meta_keyword.obj_id	ut_lp_settings.obj_id
  meta_techn_format.tech_id	meta_technical.tech_id
  meta_techn_loc.tech_id	meta_technical.tech_id
  meta_technical.obj_id	ut_lp_settings.obj_id
  mob_usage.id	dp_properties.ID
  module.name	service.name
  module_class.class	service_class.class
  note.id	dp_properties.ID
  note.obj_id	ut_lp_settings.obj_id
  object_data.obj_id	ut_lp_settings.obj_id
  object_description.obj_id	ut_lp_settings.obj_id
  object_reference.obj_id	ut_lp_settings.obj_id
  object_translation.obj_id	ut_lp_settings.obj_id
  payment_objects.pobject_id	payment_bill_vendor.pobject_id
  payment_objects.ref_id	object_reference.ref_id
  payment_objects.vendor_id	payment_vendors.vendor_id
  payment_prices.pobject_id	payment_bill_vendor.pobject_id
  payment_shopping_cart.pobject_id	payment_bill_vendor.pobject_id
  payment_shopping_cart.price_id	payment_prices.price_id
  payment_statistic.pobject_id	payment_bill_vendor.pobject_id
  payment_trustees.vendor_id	payment_vendors.vendor_id
  personal_clipboard.user_id	member_export_user_settings.user_id
  qpl_answer_cloze.answer_id	qpl_answer_ordering.answer_id
  qpl_answer_imagemap.answer_id	qpl_answer_ordering.answer_id
  qpl_answer_matching.answer_id	qpl_answer_ordering.answer_id
  qpl_answer_multiplechoice.answer_id	qpl_answer_ordering.answer_id
  qpl_answer_singlechoice.answer_id	qpl_answer_ordering.answer_id
  qpl_answer_textsubset.answer_id	qpl_answer_ordering.answer_id
  qpl_feedback_generic.feedback_id	qpl_feedback_multiplechoice.feedback_id
  qpl_feedback_generic.question_fi	qpl_question_matching.question_fi
  qpl_feedback_imagemap.feedback_id	qpl_feedback_multiplechoice.feedback_id
  qpl_feedback_imagemap.question_fi	qpl_question_matching.question_fi
  qpl_feedback_multiplechoice.question_fi	qpl_question_matching.question_fi
  qpl_feedback_singlechoice.feedback_id	qpl_feedback_multiplechoice.feedback_id
  qpl_feedback_singlechoice.question_fi	qpl_question_matching.question_fi
  qpl_numeric_range.question_fi	qpl_question_matching.question_fi
  qpl_question_cloze.question_fi	qpl_question_matching.question_fi
  qpl_question_essay.question_fi	qpl_question_matching.question_fi
  qpl_question_flashapp.question_fi	qpl_question_matching.question_fi
  qpl_question_imagemap.question_fi	qpl_question_matching.question_fi
  qpl_question_javaapplet.question_fi	qpl_question_matching.question_fi
  qpl_question_multiplechoice.question_fi	qpl_question_matching.question_fi
  qpl_question_numeric.question_fi	qpl_question_matching.question_fi
  qpl_question_ordering.question_fi	qpl_question_matching.question_fi
  qpl_question_singlechoice.question_fi	qpl_question_matching.question_fi
  qpl_question_textsubset.question_fi	qpl_question_matching.question_fi
  qpl_questionpool.id_questionpool	survey_questionpool.id_questionpool
  qpl_suggested_solutions.question_fi	qpl_question_matching.question_fi
  rbac_pa.ref_id	object_reference.ref_id
  rbac_templates.ops_id	rbac_operations.ops_id
  rbac_ua.usr_id	ut_lp_filter.usr_id
  remote_course_settings.obj_id	ut_lp_settings.obj_id
  role_desktop_items.role_id	role_data.role_id
  sahs_lm.id	dp_properties.ID
  sc_item.obj_id	ut_lp_settings.obj_id
  sc_manifest.obj_id	ut_lp_settings.obj_id
  sc_organization.obj_id	ut_lp_settings.obj_id
  sc_organizations.obj_id	ut_lp_settings.obj_id
  sc_resource.obj_id	ut_lp_settings.obj_id
  sc_resource_dependency.id	dp_properties.ID
  sc_resource_dependency.res_id	crs_objective_results.res_id
  sc_resource_file.id	dp_properties.ID
  sc_resource_file.res_id	crs_objective_results.res_id
  sc_resources.obj_id	ut_lp_settings.obj_id
  scorm_object.obj_id	ut_lp_settings.obj_id
  scorm_tracking.obj_id	ut_lp_settings.obj_id
  scorm_tracking.user_id	member_export_user_settings.user_id
  search_data.obj_id	ut_lp_settings.obj_id
  search_data.user_id	member_export_user_settings.user_id
  style_data.id	dp_properties.ID
  style_parameter.class	service_class.class
  style_parameter.id	dp_properties.ID
  survey_answer.question_fi	qpl_question_matching.question_fi
  survey_constraint.question_fi	qpl_question_matching.question_fi
  survey_material.question_fi	qpl_question_matching.question_fi
  survey_question.question_id	qpl_questions.question_id
  survey_question_constraint.question_fi	qpl_question_matching.question_fi
  survey_question_material.material_id	survey_material.material_id
  survey_question_material.question_fi	qpl_question_matching.question_fi
  survey_question_matrix.question_fi	qpl_question_matching.question_fi
  survey_question_matrix_rows.question_fi	qpl_question_matching.question_fi
  survey_question_metric.question_fi	qpl_question_matching.question_fi
  survey_question_nominal.question_fi	qpl_question_matching.question_fi
  survey_question_obligatory.question_fi	qpl_question_matching.question_fi
  survey_question_ordinal.question_fi	qpl_question_matching.question_fi
  survey_question_text.question_fi	qpl_question_matching.question_fi
  survey_questionblock_question.question_fi	qpl_question_matching.question_fi
  survey_survey_question.question_fi	qpl_question_matching.question_fi
  survey_variable.question_fi	qpl_question_matching.question_fi
  tst_manual_feedback.question_fi	qpl_question_matching.question_fi
  tst_test_question.question_fi	qpl_question_matching.question_fi
  tst_test_random_question.question_fi	qpl_question_matching.question_fi
  user_defined_field_definition.field_id	adv_md_field_definition.field_id
  usr_defined_data.usr_id	ut_lp_filter.usr_id
  usr_pref.usr_id	usr_data.usr_id
  usr_search.usr_id	ut_lp_filter.usr_id
  ut_access.id	dp_properties.ID
  ut_learning_progress.obj_id	ut_lp_settings.obj_id
  ut_learning_progress.user_id	member_export_user_settings.user_id
  ut_lp_collections.obj_id	ut_lp_settings.obj_id
  ut_lp_event_collections.obj_id	ut_lp_settings.obj_id
  ut_lp_marks.obj_id	ut_lp_settings.obj_id
  ut_lp_marks.usr_id	ut_lp_filter.usr_id
  ut_online.usr_id	ut_lp_filter.usr_id
  xhtml_page.id	dp_properties.ID
  xml_attribute_idx.attribute_id	xml_attribute_namespace.attribute_id
  xml_attribute_idx.node_id	xml_cdata.node_id
  xml_attribute_idx.value_id	xml_attribute_value.value_id
  xml_attribute_name.attribute_id	xml_attribute_namespace.attribute_id
  xml_attribute_namespace.node_id	xml_cdata.node_id
  xml_comment.node_id	xml_cdata.node_id
  xml_element_idx.element_id	xml_element_namespace.element_id
  xml_element_idx.node_id	xml_cdata.node_id
  xml_element_name.element_id	xml_element_namespace.element_id
  xml_element_namespace.node_id	xml_cdata.node_id
  xml_entity_reference.element_id	xml_element_namespace.element_id
  xml_entity_reference.node_id	xml_cdata.node_id
  xml_object.ID	dp_properties.ID
  xml_pi_data.node_id	xml_cdata.node_id
  xml_pi_target.leaf_id	xml_pi_data.leaf_id
  xml_pi_target.node_id	xml_cdata.node_id
  xml_text.node_id	xml_cdata.node_id
  xml_tree.node_id	xml_cdata.node_id

  310 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  chat_blocked	0
  feedback_results	0
  grp_registration	0
  link_check	0
  lo_access	0
  mail_saved	0
  mep_tree	0
  meta_keyword	0

  8 instances of anomaly detected

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

  Column
  cmi_gobjective.objective_id
  cmi_gobjective.scope_id
  cmi_gobjective.user_id
  cp_suspend.obj_id
  cp_suspend.user_id

  5 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  usr_defined_data	usr_id

  1 instance of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  ilinc_data
  survey_question_matrix
  survey_variable
  tst_solutions

  4 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