Tables


SchemaSpy Analysis of studip32

Generated on Tue Nov 12 07:04 CET 2019

XML Representation
Insertion Order Deletion Order
TABLES 188
VIEWS 0
COLUMNS 1315
Constraints 0
Anomalies 179
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
oauth_server_token 0 0 12 0 Table
calendar_event 0 0 5 0 Table
statusgruppen 0 2 11 0 Table
schedule_seminare 0 1 5 0 Table
evalgroup 0 1 8 0 Table
seminare 0 0 34 0 Table
semester_data 0 1 8 2 Table
news_range 0 0 2 2 Table
help_tour_user 0 0 4 0 Table
resources_objects_properties 0 2 3 0 Table
semester_holiday 0 2 6 1 Table
files_backend_studip 0 0 3 0 Table
lit_list_content 0 0 8 0 Table
eval_user 0 0 2 0 Table
termin_related_persons 0 1 2 0 Table
resources_properties 0 1 6 11 Table
resources_requests 0 3 14 0 Table
dokumente 0 1 16 0 Table
doc_usergroup_config 0 0 10 1 Table
archiv_user 0 0 3 0 Table
conditionaladmissions 0 0 7 0 Table
message_user 0 0 7 0 Table
event_data 0 2 27 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
studygroup_invitations 0 1 3 0 Table
termine 0 3 13 0 Table
files_share 0 0 7 0 Table
vote_user 0 1 3 0 Table
user_inst 0 0 10 0 Table
themen_termine 0 1 2 0 Table
widget_default 0 0 4 24 Table
datafields 0 0 14 0 Table
resources_categories_properties 0 1 4 19 Table
timedadmissions 0 0 6 0 Table
courseset_rule 0 0 4 0 Table
roles 0 0 3 7 Table
cronjobs_tasks 0 0 6 7 Table
resources_objects 0 4 13 0 Table
seminar_user 0 0 11 0 Table
voteanswers_user 0 1 3 0 Table
passwordadmissions 0 0 7 0 Table
admissionrules 0 0 4 7 Table
seminar_cycle_dates 0 1 12 0 Table
file_refs 11 0 6 0 Table
userdomains 0 1 2 0 Table
help_tour_audiences 0 0 3 0 Table
message_tags 0 0 5 0 Table
comments 0 0 6 0 Table
help_tour_steps 0 0 13 222 Table
resources_locks 0 0 4 0 Table
forum_categories_entries 0 0 3 0 Table
forum_likes 0 0 2 0 Table
message 0 1 6 0 Table
lit_list 0 1 9 0 Table
sem_types 0 0 5 14 Table
evalquestion 0 1 6 7 Table
api_consumers 0 0 18 0 Table
resources_assign 0 2 16 0 Table
plugins_activated 0 0 3 0 Table
blubber_mentions 0 0 4 0 Table
admissionrule_inst 0 0 3 0 Table
user_factorlist 0 0 3 0 Table
blubber 0 2 12 0 Table
participantrestrictedadmissions 0 0 5 0 Table
blubber_reshares 0 0 4 0 Table
eval_group_template 0 0 3 0 Table
blubber_tags 0 0 2 0 Table
siteinfo_rubrics 0 0 3 2 Table
forum_favorites 0 0 2 0 Table
log_actions 0 0 9 53 Table
courseset_institute 0 0 4 0 Table
oauth_log 0 0 12 0 Table
forum_entries 0 0 17 0 Table
personal_notifications_user 0 0 3 0 Table
smiley 0 0 10 0 Table
roles_plugins 0 0 2 44 Table
kategorien 0 1 7 0 Table
roles_studipperms 0 0 2 8 Table
eval_templates 0 1 13 0 Table
user_studiengang 0 1 4 0 Table
datafields_entries 0 0 6 0 Table
priorities 0 0 6 0 Table
userlimits 0 0 5 0 Table
coursememberadmissions 0 1 8 0 Table
help_tour_settings 0 0 3 29 Table
auth_extern 0 0 7 0 Table
media_cache 88 0 4 0 Table
user_visibility 0 0 7 0 Table
userfilter_fields 0 2 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 1 2 0 Table
help_content 0 1 13 167 Table
user_token 0 0 3 0 Table
api_user_permissions 0 0 5 0 Table
lockedadmissions 0 0 4 0 Table
admissionfactor 0 1 6 0 Table
archiv 0 3 18 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 138 Table
doc_filetype_forbidden 0 0 3 0 Table
user_userdomains 0 1 2 0 Table
wiki 0 1 6 0 Table
ex_termine 0 4 14 0 Table
courseset_factorlist 0 0 3 0 Table
schedule 0 0 8 0 Table
resources_requests_properties 0 2 5 0 Table
userfilter 0 1 3 0 Table
folder 0 1 10 0 Table
news_rss_range 0 1 3 0 Table
resources_categories 0 0 6 4 Table
termin_related_groups 0 0 2 0 Table
seminar_sem_tree 0 1 2 0 Table
user_config 0 2 8 0 Table
object_views 0 0 3 0 Table
calendar_user 0 0 5 0 Table
files 0 2 10 0 Table
themen 0 2 8 0 Table
user_info 0 0 22 1 Table
wiki_locks 0 1 4 0 Table
Institute 0 1 16 0 Table
api_oauth_user_mapping 0 1 3 0 Table
oauth_server_registry 0 0 17 0 Table
cronjobs_schedules 0 0 19 7 Table
eval_range 0 0 2 0 Table
forum_categories 0 0 4 0 Table
user_online 0 1 2 0 Table
admission_condition 0 0 3 0 Table
help_tours 0 0 13 29 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 1 3 1 Table
statusgruppe_user 0 1 5 0 Table
extern_config 0 0 8 0 Table
sem_classes 0 0 40 4 Table
vote 0 3 18 0 Table
doc_filetype 0 0 3 5 Table
oauth_consumer_token 0 0 9 0 Table
seminar_inst 0 0 2 0 Table
forum_entries_issues 0 0 2 0 Table
voteanswers 0 2 6 0 Table
oauth_server_nonce 0 0 5 0 Table
studiengaenge 0 1 5 0 Table
wiki_links 0 0 3 0 Table
lock_rules 0 0 7 0 Table
blubber_streams 0 0 16 0 Table
resources_requests_user_status 0 2 3 0 Table
auto_insert_sem 0 0 3 0 Table
resources_user_resources 0 1 3 0 Table
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
limitedadmissions 0 0 7 0 Table
mail_queue_entries 0 0 8 0 Table
siteinfo_details 0 0 5 6 Table
blubber_follower 0 0 3 0 Table
cronjobs_logs 0 0 7 0 Table
auth_user_md5 0 0 13 1 Table
oauth_consumer_registry 0 0 12 0 Table
opengraphdata 0 0 10 0 Table
evalanswer 0 1 8 30 Table
files_backend_url 0 0 3 0 Table
plugins 0 0 10 7 Table
resources_temporary_events 0 3 6 0 Table
lit_catalog 0 0 21 0 Table
sem_tree 0 2 7 0 Table
widget_user 0 1 5 0 Table
auto_insert_user 0 0 3 0 Table
news 0 0 11 1 Table
seminar_courseset 0 0 3 0 Table
forum_visits 0 0 4 0 Table
blubber_events_queue 0 0 3 0 Table
scm 0 2 8 0 Table
range_tree 0 2 7 0 Table
admission_seminar_user 0 0 7 0 Table
log_events 0 2 8 0 Table
api_consumer_permissions 0 1 4 0 Table