SchemaSpy Analysis of studip30 - 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_condition.filter_id	userfilter.filter_id
  admission_condition.rule_id	lockedadmissions.rule_id
  admission_seminar_user.seminar_id	archiv.seminar_id
  admission_seminar_user.user_id	auth_user_md5.user_id
  admissionfactor.list_id	lit_list.list_id
  admissionrule_inst.rule_id	lockedadmissions.rule_id
  admissionrules.id	webservice_access_rules.id
  api_consumer_permissions.consumer_id	api_consumers.consumer_id
  api_consumers.url	opengraphdata.url
  api_oauth_user_mapping.user_id	user_online.user_id
  api_user_permissions.consumer_id	api_consumers.consumer_id
  api_user_permissions.user_id	user_online.user_id
  archiv_user.seminar_id	archiv.seminar_id
  archiv_user.user_id	auth_user_md5.user_id
  auto_insert_user.user_id	user_online.user_id
  aux_lock_rules.lock_id	resources_locks.lock_id
  blubber.Seminar_id	archiv.seminar_id
  blubber.topic_id	px_topics.topic_id
  blubber.user_id	auth_user_md5.user_id
  blubber_events_queue.item_id	range_tree.item_id
  blubber_follower.external_contact_id	blubber_external_contact.external_contact_id
  blubber_mentions.topic_id	px_topics.topic_id
  blubber_mentions.user_id	auth_user_md5.user_id
  blubber_reshares.topic_id	px_topics.topic_id
  blubber_reshares.user_id	auth_user_md5.user_id
  blubber_streams.user_id	auth_user_md5.user_id
  blubber_tags.topic_id	px_topics.topic_id
  comments.object_id	object_views.object_id
  comments.user_id	auth_user_md5.user_id
  conditionaladmissions.rule_id	lockedadmissions.rule_id
  contact.user_id	auth_user_md5.user_id
  contact_userinfo.contact_id	contact.contact_id
  courseset_factorlist.set_id	coursesets.set_id
  courseset_institute.set_id	coursesets.set_id
  courseset_rule.rule_id	lockedadmissions.rule_id
  courseset_rule.set_id	coursesets.set_id
  coursesets.user_id	auth_user_md5.user_id
  cronjobs_logs.schedule_id	cronjobs_schedules.schedule_id
  cronjobs_schedules.task_id	cronjobs_tasks.task_id
  datafields_entries.datafield_id	datafields.datafield_id
  deputies.user_id	auth_user_md5.user_id
  dokumente.seminar_id	archiv.seminar_id
  dokumente.url	opengraphdata.url
  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.seminar_id	archiv.seminar_id
  folder.user_id	auth_user_md5.user_id
  forum_abo_users.topic_id	px_topics.topic_id
  forum_abo_users.user_id	auth_user_md5.user_id
  forum_categories.seminar_id	archiv.seminar_id
  forum_categories_entries.category_id	forum_categories.category_id
  forum_categories_entries.topic_id	px_topics.topic_id
  forum_entries.seminar_id	archiv.seminar_id
  forum_entries.topic_id	px_topics.topic_id
  forum_entries.user_id	auth_user_md5.user_id
  forum_entries_issues.issue_id	themen.issue_id
  forum_entries_issues.topic_id	px_topics.topic_id
  forum_favorites.topic_id	px_topics.topic_id
  forum_favorites.user_id	auth_user_md5.user_id
  forum_likes.topic_id	px_topics.topic_id
  forum_likes.user_id	auth_user_md5.user_id
  forum_visits.seminar_id	archiv.seminar_id
  forum_visits.user_id	auth_user_md5.user_id
  his_abstgv.stg	his_stg.stg
  Institute.url	opengraphdata.url
  limitedadmissions.rule_id	lockedadmissions.rule_id
  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
  mail_queue_entries.message_id	message.message_id
  mail_queue_entries.user_id	auth_user_md5.user_id
  message_user.user_id	user_online.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
  object_user_visits.user_id	user_online.user_id
  participantrestrictedadmissions.rule_id	lockedadmissions.rule_id
  passwordadmissions.rule_id	lockedadmissions.rule_id
  plugins_activated.pluginid	plugins.pluginid
  plugins_default_activations.pluginid	plugins.pluginid
  priorities.seminar_id	archiv.seminar_id
  priorities.set_id	coursesets.set_id
  priorities.user_id	auth_user_md5.user_id
  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.category_id	forum_categories.category_id
  resources_categories_properties.category_id	forum_categories.category_id
  resources_categories_properties.property_id	resources_properties.property_id
  resources_objects.category_id	forum_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	forum_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_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	webservice_access_rules.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
  sem_classes.id	webservice_access_rules.id
  sem_types.id	webservice_access_rules.id
  semester_holiday.semester_id	semester_data.semester_id
  seminar_courseset.seminar_id	archiv.seminar_id
  seminar_courseset.set_id	coursesets.set_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_groups.termin_id	ex_termine.termin_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
  timedadmissions.rule_id	lockedadmissions.rule_id
  user_config.user_id	auth_user_md5.user_id
  user_factorlist.list_id	lit_list.list_id
  user_factorlist.user_id	auth_user_md5.user_id
  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
  user_visibility_settings.user_id	auth_user_md5.user_id
  userfilter_fields.filter_id	userfilter.filter_id
  userlimits.rule_id	lockedadmissions.rule_id
  userlimits.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
  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

  203 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