SchemaSpy - studip20

Generated by
SchemaSpy

Generated by SchemaSpy on Mon Aug 25 21:10 CEST 2014
Database Type: MySQL - 5.1.73-1
XML Representation Insertion Order Deletion Order (for database loading/purging scripts)

Comments

Table	Columns	Rows	Comments
abschluss	5	0
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
aux_lock_rules	5	1
banner_ads	13	0
calendar_events	26	0
chat_data	3	0
comments	6	0
config	14	103
contact	4	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	15	7
kategorien	7	0
lit_catalog	21	5
lit_list	9	1
lit_list_content	8	5
lock_rules	5	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	24
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	11	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	1
seminar_sem_tree	2	3
seminar_user	10	4
seminar_user_schedule	2	0
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	8	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öglichen Bestandteilen eines abstrakten Moduls
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	0
teilnehmer_view	3	0
termine	13	25
themen	8	0
themen_termine	2	0
user_config	8	0
user_data	3	0
user_info	23	5
user_inst	10	4
user_studiengang	4	0
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
wiki	6	0
wiki_links	3	0
wiki_locks	4	0

129 Tables	921	473
0 Views	0