Tables


SchemaSpy Analysis of studip40

Generated on Sat Nov 16 07:04 CET 2019

XML Representation
Insertion Order Deletion Order
TABLES 228
VIEWS 0
COLUMNS 1738
Constraints 0
Anomalies 12
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 0 13 0 Table
schedule_seminare 0 0 5 0 Table
seminare 0 0 37 0 Table
help_tour_user 0 0 4 0 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 7 11 Table
mvv_modul 0 0 25 0 Table
archiv_user 0 0 3 0 Table
conditionaladmissions 0 0 7 0 Table
message_user 0 0 7 0 Table
mvv_modulteil_stgteilabschnitt 0 0 8 0 Table
deputies 0 0 5 0 Table
forum_abo_users 0 0 2 0 Table
termine 0 0 13 0 Table
mvv_stgteilabschnitt_modul 0 0 11 0 Table
user_inst 0 0 10 0 Table
mvv_lvgruppe 0 0 9 0 Table
datafields 0 0 16 0 Table
resources_categories_properties 0 0 5 19 Table
courseset_rule 0 0 4 0 Table
roles 0 0 3 14 Table
i18n 0 0 5 0 Table
fach 0 0 12 0 Table
resources_objects 0 0 14 0 Table
seminar_user 0 0 11 0 Table
file_refs 0 0 10 0 Table
help_tour_audiences 0 0 3 0 Table
message_tags 0 0 5 0 Table
resources_locks 0 0 4 0 Table
forum_likes 0 0 2 0 Table
message 0 0 6 0 Table
admissionrule_compat 0 0 4 41 Table
lit_list 0 0 9 0 Table
plugins_activated 0 0 3 0 Table
resources_assign 0 0 16 0 Table
mvv_fach_inst 0 0 7 0 Table
cache_operations 0 0 5 0 Table
admissionrule_inst 0 0 3 0 Table
participantrestrictedadmissions 0 0 5 0 Table
blubber_tags 0 0 2 0 Table
mvv_stgteilabschnitt 0 0 14 0 Table
siteinfo_rubrics 1 0 3 2 Table
mvv_abschl_zuord 0 0 7 0 Table
oauth_log 0 0 12 0 Table
personal_notifications_user 0 0 3 0 Table
smiley 0 0 10 0 Table
roles_studipperms 0 0 2 8 Table
etask_task_tags 0 0 3 0 Table
admission_conditiongroup 0 0 2 0 Table
datafields_entries 0 0 6 0 Table
priorities 0 0 6 0 Table
userlimits 0 0 5 0 Table
etask_assignment_attempts 0 1 6 0 Table
help_tour_settings 0 0 3 36 Table
auth_extern 0 0 7 0 Table
etask_test_tags 0 0 3 0 Table
user_visibility 0 0 7 0 Table
user_token 0 0 3 0 Table
api_user_permissions 0 0 5 0 Table
lockedadmissions 0 0 4 0 Table
object_contentmodules 0 0 6 0 Table
user_visibility_settings 0 0 8 0 Table
mvv_modulteil_language 0 0 7 0 Table
schema_version 0 0 2 1 Table
user_userdomains 0 0 2 0 Table
mvv_lvgruppe_seminar 0 0 6 0 Table
courseset_factorlist 0 0 3 0 Table
resources_requests_properties 0 0 5 0 Table
etask_assignments 0 1 9 0 Table
userfilter 0 0 3 0 Table
news_rss_range 2 0 3 0 Table
resources_categories 0 0 6 4 Table
file_urls 0 0 3 0 Table
termin_related_groups 0 0 2 0 Table
user_config 0 0 8 0 Table
calendar_user 0 0 5 0 Table
mvv_studiengang 0 0 22 0 Table
themen 0 0 8 0 Table
mvv_stgteilversion 0 0 16 0 Table
user_info 0 0 22 1 Table
wiki_locks 0 0 4 0 Table
forum_categories 0 0 4 0 Table
mvv_dokument 0 0 12 0 Table
admission_condition 0 0 4 0 Table
help_tours 0 0 13 36 Table
eval 0 0 12 0 Table
object_user_visits 0 0 5 0 Table
roles_user 0 0 3 1 Table
mvv_modul_deskriptor 0 0 25 0 Table
statusgruppe_user 0 0 5 0 Table
extern_config 0 0 8 0 Table
sem_classes 0 0 43 4 Table
oauth_consumer_token 0 0 9 0 Table
seminar_inst 0 0 2 0 Table
forum_entries_issues 0 0 2 0 Table
resources_requests_user_status 0 0 3 0 Table
resources_user_resources 0 0 3 0 Table
webservice_access_rules 0 0 5 0 Table
blubber_external_contact 0 0 7 0 Table
abschluss 0 0 11 0 Table
eval_templates_eval 0 0 2 0 Table
mvv_stgteil 0 0 10 0 Table
personal_notifications 0 0 7 0 Table
activities 0 0 11 0 Table
aux_lock_rules 0 0 5 0 Table
limitedadmissions 0 0 7 0 Table
mail_queue_entries 0 0 8 0 Table
siteinfo_details 0 1 5 6 Table
auth_user_md5 0 0 13 1 Table
mvv_lvgruppe_modulteil 0 0 8 0 Table
opengraphdata 0 0 11 0 Table
auto_insert_user 0 0 3 0 Table
news 0 0 11 1 Table
seminar_courseset 0 0 3 0 Table
admission_seminar_user 0 0 7 0 Table
log_events 0 0 8 0 Table
oauth_server_token 0 0 12 0 Table
calendar_event 0 0 5 0 Table
evalgroup 0 0 8 0 Table
semester_data 0 0 8 2 Table
news_range 0 0 2 2 Table
questionnaire_anonymous_answers 0 0 5 0 Table
resources_objects_properties 0 0 3 0 Table
semester_holiday 0 0 6 1 Table
resources_requests 0 0 14 0 Table
mvv_modulteil 0 0 22 0 Table
event_data 0 0 27 0 Table
plugin_assets 0 0 8 0 Table
session_data 0 0 3 0 Table
plugins_default_activations 0 0 2 0 Table
studygroup_invitations 0 0 3 0 Table
mvv_stgteil_bez 0 0 10 0 Table
questionnaire_questions 0 0 6 0 Table
themen_termine 0 0 2 0 Table
widget_default 0 0 4 24 Table
timedadmissions 0 0 6 0 Table
loginbackgrounds 0 0 5 2 Table
etask_responses 0 1 12 0 Table
cronjobs_tasks 1 0 6 8 Table
passwordadmissions 0 0 7 0 Table
admissionrules 0 0 5 8 Table
seminar_cycle_dates 0 0 13 0 Table
userdomains 0 0 2 0 Table
content_terms_of_use_entries 0 0 10 5 Table
comments 0 0 6 0 Table
help_tour_steps 0 0 13 280 Table
questionnaire_assignments 0 0 7 0 Table
prefadmission_condition 0 0 4 0 Table
forum_categories_entries 0 0 3 0 Table
sem_types 0 0 5 14 Table
etask_tasks 0 1 9 0 Table
evalquestion 0 0 6 7 Table
api_consumers 1 0 18 0 Table
blubber_mentions 0 0 4 0 Table
user_factorlist 0 0 3 0 Table
blubber 0 0 12 0 Table
etask_test_tasks 0 0 5 0 Table
blubber_reshares 0 0 4 0 Table
eval_group_template 0 0 3 0 Table
forum_favorites 0 0 2 0 Table
log_actions 0 0 9 138 Table
courseset_institute 0 0 4 0 Table
forum_entries 0 0 17 0 Table
roles_plugins 0 0 2 63 Table
kategorien 0 0 7 0 Table
eval_templates 0 0 13 0 Table
user_studiengang 0 0 5 0 Table
coursememberadmissions 0 0 8 0 Table
media_cache 0 0 4 0 Table
userfilter_fields 0 0 7 0 Table
banner_ads 0 0 13 0 Table
contact 0 0 2 0 Table
coursesets 0 0 9 0 Table
seminar_userdomains 0 0 2 0 Table
help_content 0 0 13 170 Table
admissionfactor 0 0 6 0 Table
archiv 0 0 18 0 Table
config 0 0 14 171 Table
wiki 0 0 6 0 Table
etask_assignment_ranges 0 1 5 0 Table
ex_termine 0 0 14 0 Table
schedule 0 0 8 0 Table
mvv_modulteil_deskriptor 0 0 18 0 Table
questionnaire_answers 0 0 6 0 Table
coursewizardsteps 0 0 7 4 Table
etask_tests 0 1 7 0 Table
mvv_fachberater 0 0 7 0 Table
seminar_sem_tree 0 0 2 0 Table
object_views 0 0 3 0 Table
files 0 0 9 0 Table
Institute 0 0 16 0 Table
api_oauth_user_mapping 0 1 3 0 Table
folders 0 0 11 0 Table
oauth_server_registry 0 0 17 0 Table
cronjobs_schedules 1 1 19 7 Table
mvv_dokument_zuord 0 0 10 0 Table
eval_range 0 0 2 0 Table
mvv_modul_inst 0 0 8 0 Table
user_online 5 0 2 0 Table
evalanswer_user 0 0 3 0 Table
oauth_server_nonce 0 0 5 0 Table
mvv_modul_user 0 0 8 0 Table
wiki_links 0 0 3 0 Table
prefadmissions 0 0 4 0 Table
lock_rules 0 0 7 0 Table
blubber_streams 0 0 16 0 Table
auto_insert_sem 0 0 3 0 Table
mvv_modul_language 0 0 7 0 Table
eval_templates_user 0 0 3 0 Table
mvv_stg_stgteil 0 0 8 0 Table
blubber_follower 0 0 3 0 Table
cronjobs_logs 0 1 7 0 Table
oauth_consumer_registry 0 0 12 0 Table
evalanswer 0 0 8 30 Table
plugins 1 0 10 9 Table
resources_temporary_events 0 0 6 0 Table
lit_catalog 0 0 21 0 Table
sem_tree 0 0 7 0 Table
widget_user 0 1 5 0 Table
questionnaires 0 0 13 0 Table
mvv_abschl_kategorie 0 0 12 0 Table
forum_visits 0 0 4 0 Table
blubber_events_queue 0 0 3 0 Table
scm 0 0 8 0 Table
range_tree 0 0 7 0 Table
api_consumer_permissions 0 1 4 1 Table