SchemaSpy Analysis of studip30◀  Stud.IP Docs Overview Generated by
SchemaSpy
Generated by SchemaSpy on Do Aug 02 15:05 GMT+01:00 2018
Database Type: MySQL - 5.5.60-0+deb7u1 SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table Children Parents Columns Rows Comments
abschluss 5 2
admission_condition 3 0
admission_seminar_user 7 0
admissionfactor 6 0
admissionrule_inst 3 0
admissionrules 4 6
api_consumer_permissions 4 0
api_consumers 18 0
api_oauth_user_mapping 3 0
api_user_permissions 5 0
archiv 17 0
archiv_user 3 0
auth_extern 7 0
auth_user_md5 13 5
auto_insert_sem 3 0
auto_insert_user 3 0
aux_lock_rules 5 0
banner_ads 13 0
blubber 12 0
blubber_events_queue 3 0
blubber_external_contact 7 0
blubber_follower 3 0
blubber_mentions 4 0
blubber_reshares 4 0
blubber_streams 16 0
blubber_tags 2 0
calendar_events 28 0
comments 6 0
conditionaladmissions 7 0
config 14 135
contact 5 0
contact_userinfo 5 0
courseset_factorlist 3 0
courseset_institute 4 0
courseset_rule 4 0
coursesets 9 0
cronjobs_logs 7 0
cronjobs_schedules 19 7
cronjobs_tasks 6 7
datafields 13 1
datafields_entries 6 0
deputies 5 0
dokumente 16 1
eval 12 0
eval_group_template 3 0
eval_range 2 0
eval_templates 13 0
eval_templates_eval 2 0
eval_templates_user 3 0
eval_user 2 0
evalanswer 8 30
evalanswer_user 2 0
evalgroup 8 0
evalquestion 6 7
ex_termine 14 0
extern_config 8 0
folder 10 7
forum_abo_users 2 0
forum_categories 4 0
forum_categories_entries 3 0
forum_entries 17 0
forum_entries_issues 2 0
forum_favorites 2 0
forum_likes 2 0
forum_visits 4 0
his_abschl 16 0
his_abstgv 12 0
his_pvers 7 0
his_stg 5 0 Studienfaecher aus der HIS DB
Institute 16 7
kategorien 7 0
limitedadmissions 7 0
lit_catalog 21 5
lit_list 9 1
lit_list_content 8 5
lock_rules 7 0
lockedadmissions 4 0
log_actions 9 53
log_events 8 0
mail_queue_entries 8 0
media_cache 4 0
message 9 0
message_user 9 0
news 11 1
news_range 2 2
news_rss_range 3 1
oauth_consumer_registry 12 0
oauth_consumer_token 9 0
oauth_log 12 0
oauth_server_nonce 5 0
oauth_server_registry 17 0
oauth_server_token 12 0
object_contentmodules 6 0
object_rate 3 0
object_user 4 0
object_user_visits 5 0
object_views 3 0
opengraphdata 10 0
participantrestrictedadmissions 5 0
passwordadmissions 7 0
personal_notifications 6 0
personal_notifications_user 3 0
plugins 8 2
plugins_activated 3 2
plugins_default_activations 2 0 default activations of standard plugins
priorities 6 0
px_topics 12 0
range_tree 7 8
resources_assign 16 37
resources_categories 6 4
resources_categories_properties 4 19
resources_locks 4 0
resources_objects 13 12
resources_objects_properties 3 39
resources_properties 6 11
resources_requests 12 2
resources_requests_properties 5 2
resources_temporary_events 6 0
resources_user_resources 3 0
roles 3 7
roles_plugins 2 14
roles_studipperms 2 8
roles_user 3 1
rss_feeds 9 2
schedule 8 0
schedule_seminare 5 0
schema_version 2 1
scm 8 1
sem_classes 40 4
sem_tree 7 6
sem_types 5 14
semester_data 8 2
semester_holiday 6 1
seminar_courseset 3 0
seminar_cycle_dates 12 2
seminar_inst 2 1
seminar_sem_tree 2 3
seminar_user 11 4
seminar_userdomains 2 0
seminare 34 2
session_data 3 0
siteinfo_details 5 6
siteinfo_rubrics 3 2
smiley 10 0
statusgruppe_user 5 5
statusgruppen 11 6
stm_abstract 9 0 abstrakte Module
stm_abstract_assign 8 0 Zuordnung abstrakte Module <-> Studienprogramme
stm_abstract_elements 9 0 Bestandteile eines Abstrakten Moduls (Elemente)
stm_abstract_text 7 0 (mehrsprachige) Texte der abstrakten Module
stm_abstract_types 4 0 Typen abstrakter Module
stm_element_types 4 0 Typen von m
stm_instances 8 0 Instanzen der abstrakten Module
stm_instances_elements 3 0
stm_instances_text 6 0 (mehrsprachige) Texte der instanziierten abstrakten Module
studiengaenge 5 2
termin_related_groups 2 0
termin_related_persons 2 0
termine 13 14
themen 8 0
themen_termine 2 0
timedadmissions 6 0
user_config 8 0
user_factorlist 3 0
user_info 23 5
user_inst 10 4
user_online 2 0
user_studiengang 4 2
user_token 3 0
user_userdomains 2 0
user_visibility 7 0
user_visibility_settings 8 34
userdomains 2 0
userfilter 3 0
userfilter_fields 7 0
userlimits 5 0
vote 18 1
vote_user 3 0
voteanswers 6 27
voteanswers_user 3 0
webservice_access_rules 5 0
wiki 6 0
wiki_links 3 0
wiki_locks 4 0
           
184 Tables     1.318 602  
0 Views     0