SchemaSpy - studip30

Generated by SchemaSpy on Do Aug 02 15:05 GMT+01:00 2018
Database Type: MySQL - 5.5.60-0+deb7u1
XML Representation Insertion Order Deletion Order (for database loading/purging scripts)

Comments

Table	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