SchemaSpy Analysis of studip23 - Anomalies◀  Stud.IP Docs Overview

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
  admission_seminar_studiengang.seminar_id	archiv.seminar_id
  admission_seminar_studiengang.studiengang_id	studiengaenge.studiengang_id
  admission_seminar_user.seminar_id	archiv.seminar_id
  admission_seminar_user.studiengang_id	studiengaenge.studiengang_id
  admission_seminar_user.user_id	auth_user_md5.user_id
  archiv_user.seminar_id	archiv.seminar_id
  archiv_user.user_id	auth_user_md5.user_id
  aux_lock_rules.lock_id	resources_locks.lock_id
  comments.object_id	object_views.object_id
  comments.user_id	auth_user_md5.user_id
  contact.user_id	auth_user_md5.user_id
  contact_userinfo.contact_id	contact.contact_id
  datafields_entries.datafield_id	datafields.datafield_id
  deputies.user_id	auth_user_md5.user_id
  dokumente.seminar_id	archiv.seminar_id
  dokumente.user_id	auth_user_md5.user_id
  eval_group_template.evalgroup_id	evalgroup.evalgroup_id
  eval_group_template.user_id	auth_user_md5.user_id
  eval_range.eval_id	eval.eval_id
  eval_templates.user_id	auth_user_md5.user_id
  eval_templates_eval.eval_id	eval.eval_id
  eval_templates_eval.template_id	eval_templates.template_id
  eval_templates_user.eval_id	eval.eval_id
  eval_templates_user.template_id	eval_templates.template_id
  eval_templates_user.user_id	auth_user_md5.user_id
  eval_user.eval_id	eval.eval_id
  eval_user.user_id	auth_user_md5.user_id
  evalanswer_user.evalanswer_id	evalanswer.evalanswer_id
  evalanswer_user.user_id	auth_user_md5.user_id
  evalgroup.template_id	eval_templates.template_id
  ex_termine.metadate_id	seminar_cycle_dates.metadate_id
  ex_termine.resource_id	resources_objects.resource_id
  ex_termine.topic_id	px_topics.topic_id
  extern_config.config_id	config.config_id
  folder.user_id	auth_user_md5.user_id
  guestbook.user_id	auth_user_md5.user_id
  his_abstgv.stg	his_stg.stg
  lit_catalog.user_id	auth_user_md5.user_id
  lit_list.user_id	auth_user_md5.user_id
  lit_list_content.catalog_id	lit_catalog.catalog_id
  lit_list_content.list_id	lit_list.list_id
  lit_list_content.user_id	auth_user_md5.user_id
  lock_rules.lock_id	resources_locks.lock_id
  lock_rules.user_id	auth_user_md5.user_id
  log_events.action_id	log_actions.action_id
  log_events.event_id	calendar_events.event_id
  log_events.user_id	auth_user_md5.user_id
  news.user_id	auth_user_md5.user_id
  news_range.news_id	news.news_id
  object_contentmodules.object_id	object_views.object_id
  object_rate.object_id	object_views.object_id
  object_user.object_id	object_views.object_id
  object_user.user_id	auth_user_md5.user_id
  plugins_activated.pluginid	plugins.pluginid
  plugins_default_activations.pluginid	plugins.pluginid
  px_topics.Seminar_id	archiv.seminar_id
  px_topics.user_id	auth_user_md5.user_id
  resources_assign.resource_id	resources_objects.resource_id
  resources_categories_properties.category_id	resources_categories.category_id
  resources_categories_properties.property_id	resources_properties.property_id
  resources_objects.category_id	resources_categories.category_id
  resources_objects.institut_id	Institute.Institut_id
  resources_objects_properties.property_id	resources_properties.property_id
  resources_objects_properties.resource_id	resources_objects.resource_id
  resources_requests.category_id	resources_categories.category_id
  resources_requests.metadate_id	seminar_cycle_dates.metadate_id
  resources_requests.resource_id	resources_objects.resource_id
  resources_requests.seminar_id	archiv.seminar_id
  resources_requests.termin_id	ex_termine.termin_id
  resources_requests.user_id	auth_user_md5.user_id
  resources_requests_properties.property_id	resources_properties.property_id
  resources_requests_properties.request_id	resources_requests.request_id
  resources_temporary_events.assign_id	resources_assign.assign_id
  resources_temporary_events.event_id	calendar_events.event_id
  resources_temporary_events.resource_id	resources_objects.resource_id
  resources_temporary_events.seminar_id	archiv.seminar_id
  resources_temporary_events.termin_id	ex_termine.termin_id
  resources_user_resources.resource_id	resources_objects.resource_id
  resources_user_resources.user_id	auth_user_md5.user_id
  roles_plugins.pluginid	plugins.pluginid
  roles_plugins.roleid	roles.roleid
  roles_studipperms.roleid	roles.roleid
  roles_user.roleid	roles.roleid
  rss_feeds.user_id	auth_user_md5.user_id
  schedule.id	chat_data.id
  schedule.user_id	auth_user_md5.user_id
  schedule_seminare.metadate_id	seminar_cycle_dates.metadate_id
  schedule_seminare.seminar_id	archiv.seminar_id
  schedule_seminare.user_id	auth_user_md5.user_id
  scm.user_id	auth_user_md5.user_id
  semester_holiday.semester_id	semester_data.semester_id
  seminar_cycle_dates.seminar_id	archiv.seminar_id
  seminar_inst.institut_id	Institute.Institut_id
  seminar_inst.seminar_id	archiv.seminar_id
  seminar_sem_tree.sem_tree_id	sem_tree.sem_tree_id
  seminar_sem_tree.seminar_id	archiv.seminar_id
  seminar_user.Seminar_id	archiv.seminar_id
  seminar_user.user_id	auth_user_md5.user_id
  seminar_userdomains.seminar_id	archiv.seminar_id
  seminar_userdomains.userdomain_id	userdomains.userdomain_id
  seminare.Institut_id	Institute.Institut_id
  seminare.Seminar_id	archiv.seminar_id
  siteinfo_details.rubric_id	siteinfo_rubrics.rubric_id
  statusgruppe_user.statusgruppe_id	statusgruppen.statusgruppe_id
  statusgruppe_user.user_id	auth_user_md5.user_id
  stm_abstract_assign.stg	his_stg.stg
  stm_abstract_assign.stm_abstr_id	stm_abstract.stm_abstr_id
  stm_abstract_elements.stm_abstr_id	stm_abstract.stm_abstr_id
  stm_abstract_text.stm_abstr_id	stm_abstract.stm_abstr_id
  stm_instances.semester_id	semester_data.semester_id
  stm_instances.stm_abstr_id	stm_abstract.stm_abstr_id
  stm_instances_elements.element_id	stm_abstract_elements.element_id
  stm_instances_elements.stm_instance_id	stm_instances.stm_instance_id
  stm_instances_text.stm_instance_id	stm_instances.stm_instance_id
  termin_related_persons.user_id	auth_user_md5.user_id
  termine.metadate_id	seminar_cycle_dates.metadate_id
  termine.termin_id	ex_termine.termin_id
  termine.topic_id	px_topics.topic_id
  themen.seminar_id	archiv.seminar_id
  themen_termine.issue_id	themen.issue_id
  themen_termine.termin_id	ex_termine.termin_id
  user_config.user_id	auth_user_md5.user_id
  user_data.sid	session_data.sid
  user_info.user_id	auth_user_md5.user_id
  user_inst.Institut_id	Institute.Institut_id
  user_inst.user_id	auth_user_md5.user_id
  user_studiengang.abschluss_id	abschluss.abschluss_id
  user_studiengang.studiengang_id	studiengaenge.studiengang_id
  user_studiengang.user_id	auth_user_md5.user_id
  user_token.user_id	auth_user_md5.user_id
  user_userdomains.user_id	auth_user_md5.user_id
  user_userdomains.userdomain_id	userdomains.userdomain_id
  user_visibility.user_id	auth_user_md5.user_id
  vote_user.user_id	auth_user_md5.user_id
  vote_user.vote_id	vote.vote_id
  voteanswers.vote_id	vote.vote_id
  voteanswers_user.answer_id	voteanswers.answer_id
  voteanswers_user.user_id	auth_user_md5.user_id
  webservice_access_rules.id	chat_data.id
  wiki.user_id	auth_user_md5.user_id
  wiki_links.range_id	news_rss_range.range_id
  wiki_locks.user_id	auth_user_md5.user_id

  142 instances of anomaly detected

• Tables without indexes:
  Anomaly not detected

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

• Tables that contain a single column:
  Anomaly not 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