Tables


SchemaSpy Analysis of studip25

Generated on Mon Nov 18 07:03 CET 2019

XML Representation
Insertion Order Deletion Order
TABLES 153
VIEWS 0
COLUMNS 1108
Constraints 0
Anomalies 46
Routines 0

Database Properties

Database Type: MySQL - 5.5.5-10.1.41-MariaDB-0+deb9u1

Tables

Table / View Children Parents Columns Rows Type Comments
statusgruppen 0 1 9 0 Table
schedule_seminare 0 0 5 0 Table
evalgroup 0 1 8 0 Table
seminare 0 0 39 0 Table
semester_data 0 0 8 2 Table
news_range 0 0 2 2 Table
resources_objects_properties 0 0 3 0 Table
semester_holiday 0 0 6 1 Table
lit_list_content 0 0 8 0 Table
eval_user 0 0 2 0 Table
termin_related_persons 0 0 2 0 Table
resources_properties 0 0 6 11 Table
resources_requests 0 0 12 0 Table
dokumente 0 1 16 0 Table
object_rate 0 0 3 0 Table
teilnehmer_view 0 0 3 0 Table
archiv_user 0 0 3 0 Table
message_user 0 0 10 0 Table
stm_instances_elements 0 0 3 0 Table
admission_seminar_studiengang 0 0 3 0 Table
deputies 0 0 5 0 Table
session_data 0 0 3 0 Table
plugins_default_activations 0 0 2 0 Table

default activations of standard plugins

forum_abo_users 0 0 2 0 Table
termine 0 2 13 0 Table
vote_user 0 0 3 0 Table
user_inst 0 0 10 0 Table
themen_termine 0 0 2 0 Table
datafields 0 0 13 0 Table
his_abschl 0 0 16 0 Table
resources_categories_properties 0 0 4 19 Table
px_topics 0 2 12 0 Table
roles 0 0 3 7 Table
cronjobs_tasks 1 0 6 6 Table
object_user 0 0 4 0 Table
resources_objects 0 3 13 0 Table
seminar_user 0 0 12 0 Table
voteanswers_user 0 0 3 0 Table
seminar_cycle_dates 0 0 12 0 Table
userdomains 0 0 2 0 Table
comments 0 0 6 0 Table
stm_abstract_elements 0 1 9 0 Table

Bestandteile eines Abstrakten Moduls (Elemente)

his_abstgv 0 0 12 0 Table
resources_locks 0 0 4 0 Table
stm_instances 0 1 8 0 Table

Instanzen der abstrakten Module

forum_categories_entries 0 0 3 0 Table
forum_likes 0 0 2 0 Table
message 0 2 9 0 Table
lit_list 0 1 9 0 Table
sem_types 0 0 5 14 Table
evalquestion 0 1 6 7 Table
resources_assign 0 0 16 0 Table
plugins_activated 0 0 3 0 Table
blubber_mentions 0 0 4 0 Table
blubber 0 2 12 0 Table
eval_group_template 0 0 3 0 Table
blubber_tags 0 0 2 0 Table
siteinfo_rubrics 1 0 3 2 Table
forum_favorites 0 0 2 0 Table
log_actions 0 0 6 53 Table
forum_entries 0 0 15 0 Table
personal_notifications_user 0 0 3 0 Table
smiley 0 0 10 0 Table
admission_group 0 0 5 0 Table
roles_plugins 0 0 2 14 Table
kategorien 0 1 7 0 Table
roles_studipperms 0 0 2 8 Table
eval_templates 0 1 13 0 Table
user_studiengang 0 0 4 0 Table
datafields_entries 0 0 6 0 Table
calendar_events 0 3 28 0 Table
auth_extern 0 0 7 0 Table
media_cache 43 0 4 0 Table
user_visibility 0 0 7 0 Table
rss_feeds 0 0 9 0 Table
banner_ads 0 0 13 0 Table
contact 0 1 5 0 Table
seminar_userdomains 0 0 2 0 Table
user_token 0 0 3 0 Table
archiv 0 2 17 0 Table
object_contentmodules 0 0 6 0 Table
user_visibility_settings 0 0 8 0 Table
schema_version 0 0 2 1 Table
config 0 1 14 122 Table
user_userdomains 0 0 2 0 Table
wiki 0 0 6 0 Table
ex_termine 0 2 14 0 Table
schedule 0 0 8 0 Table
resources_requests_properties 0 0 5 0 Table
folder 0 1 9 0 Table
news_rss_range 0 0 3 0 Table
resources_categories 0 0 6 4 Table
stm_instances_text 0 0 6 0 Table

(mehrsprachige) Texte der instanziierten abstrakten Module

seminar_sem_tree 0 0 2 0 Table
user_config 0 1 8 0 Table
object_views 0 0 3 0 Table
stm_abstract_text 0 0 7 0 Table

(mehrsprachige) Texte der abstrakten Module

his_stg 0 0 5 0 Table

Studienfaecher aus der HIS DB

themen 0 1 8 0 Table
user_info 0 0 23 1 Table
wiki_locks 0 0 4 0 Table
Institute 0 1 16 0 Table
his_pvers 0 0 7 0 Table
cronjobs_schedules 1 1 19 6 Table
eval_range 0 0 2 0 Table
forum_categories 0 0 4 0 Table
user_online 0 0 2 0 Table
eval 0 1 12 0 Table
evalanswer_user 0 0 2 0 Table
object_user_visits 0 0 5 0 Table
roles_user 0 0 2 1 Table
stm_abstract_assign 0 1 8 0 Table

Zuordnung abstrakte Module <-> Studienprogramme

statusgruppe_user 0 0 5 0 Table
extern_config 0 0 8 0 Table
sem_classes 0 0 40 4 Table
vote 0 2 18 0 Table
seminar_inst 0 0 2 0 Table
forum_entries_issues 0 0 2 0 Table
stm_element_types 0 0 4 0 Table

Typen von m?glichen Bestandteilen eines abstrakten Moduls

voteanswers 0 0 6 0 Table
studiengaenge 0 0 5 0 Table
wiki_links 0 0 3 0 Table
lock_rules 0 0 7 0 Table
blubber_streams 0 0 16 0 Table
auto_insert_sem 0 0 3 0 Table
resources_user_resources 0 0 3 0 Table
stm_abstract_types 0 0 4 0 Table

Typen abstrakter Module

webservice_access_rules 0 0 5 0 Table
eval_templates_user 0 0 3 0 Table
blubber_external_contact 0 0 7 0 Table
abschluss 0 0 5 0 Table
eval_templates_eval 0 0 2 0 Table
personal_notifications 0 0 6 0 Table
aux_lock_rules 0 0 5 0 Table
siteinfo_details 0 1 5 6 Table
blubber_follower 0 0 3 0 Table
cronjobs_logs 0 1 7 0 Table
contact_userinfo 0 0 5 0 Table
auth_user_md5 0 0 13 1 Table
evalanswer 0 1 8 30 Table
plugins 0 0 8 2 Table
resources_temporary_events 0 0 6 0 Table
lit_catalog 0 0 21 0 Table
sem_tree 0 1 7 0 Table
auto_insert_user 0 0 3 0 Table
news 0 0 11 1 Table
forum_visits 0 0 4 0 Table
stm_abstract 0 0 9 0 Table

abstrakte Module

blubber_events_queue 0 0 3 0 Table
scm 0 1 8 0 Table
range_tree 0 1 7 0 Table
admission_seminar_user 0 0 8 0 Table
log_events 0 2 8 0 Table