SchemaSpy Analysis of studip22◀  Stud.IP Docs Overview Generated by
SchemaSpy
Generated by SchemaSpy on Do Aug 02 14:25 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_group 5 0
admission_seminar_studiengang 3 0
admission_seminar_user 8 0
archiv 17 0
archiv_user 3 0
auth_extern 7 0
auth_user_md5 13 5
auto_insert_sem 2 0
auto_insert_user 3 0
aux_lock_rules 5 1
banner_ads 13 0
calendar_events 28 0
chat_data 3 0
comments 6 0
config 14 115
contact 5 0
contact_userinfo 5 0
datafields 11 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 9 10
guestbook 5 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
lit_catalog 21 5
lit_list 9 1
lit_list_content 8 5
lock_rules 7 0
log_actions 6 53
log_events 8 0
media_cache 4 0
message 9 0
message_user 10 0
news 11 1
news_range 2 2
news_rss_range 3 1
object_contentmodules 6 0
object_rate 3 0
object_user 4 0
object_user_visits 5 0
object_views 3 0
plugins 8 0
plugins_activated 3 0
plugins_default_activations 2 0 default activations of standard plugins
px_topics 12 4
range_tree 7 8
resources_assign 15 23
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 1
resources_requests_properties 5 0
resources_temporary_events 9 0
resources_user_resources 3 0
roles 3 7
roles_plugins 2 0
roles_studipperms 2 8
roles_user 2 1
rss_feeds 9 2
schedule 8 0
schedule_seminare 5 0
schema_version 2 1
scm 7 2
sem_tree 7 6
semester_data 8 2
semester_holiday 6 1
seminar_cycle_dates 12 2
seminar_inst 2 0
seminar_sem_tree 2 3
seminar_user 12 4
seminar_userdomains 2 0
seminare 39 2
session_data 3 0
siteinfo_details 5 6
siteinfo_rubrics 3 2
smiley 10 0
statusgruppe_user 5 3
statusgruppen 9 8
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
teilnehmer_view 3 0
termin_related_persons 2 0
termine 13 24
themen 8 0
themen_termine 2 0
user_config 8 0
user_data 3 0
user_info 24 5
user_inst 10 4
user_studiengang 4 2
user_token 3 0
user_userdomains 2 0
user_visibility 8 1
userdomains 2 0
vote 18 1
vote_user 3 0
voteanswers 6 21
voteanswers_user 3 0
webservice_access_rules 5 0
wiki 6 0
wiki_links 3 0
wiki_locks 4 0
           
132 Tables     942 488  
0 Views     0