SchemaSpy Analysis of iliasRelease_4_3_x_branch◀  ilDoc Overview Generated by
SchemaSpy
Generated by SchemaSpy on Sun Apr 24 00:38 CEST 2016
Database Type: MySQL - 5.5.47-0+deb7u1 SourceForge.net


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

Table Children Parents Columns Rows Comments
abstraction_progress 2 4,810
acc_access_key 3 0
acc_cache 3 0
acc_user_access_key 3 0
acl_ws 3 0
addressbook 6 0
addressbook_mlist 6 0
addressbook_mlist_ass 3 0
addressbook_mlist_ass_seq 1 0
addressbook_mlist_seq 1 0
addressbook_seq 1 0
adl_shared_data 4 0
adm_set_templ_hide_tab 2 0
adm_set_templ_value 4 0
adm_settings_template 4 0
adm_settings_template_seq 1 0
adv_md_record 5 0
adv_md_record_objs 2 0
adv_md_record_seq 1 0
adv_md_substitutions 4 0
adv_md_values 4 0
adv_mdf_definition 10 0
adv_mdf_definition_seq 1 0
aicc_course 15 0
aicc_object 7 0
aicc_object_seq 1 0
aicc_units 12 0
aicc_units_seq 1 0
ass_log 9 0 Logging of Test&Assessment object changes
ass_log_seq 1 0
benchmark 5 0
booking_entry 5 0
booking_entry_seq 1 0
booking_object 9 0
booking_object_seq 1 0
booking_reservation 6 0
booking_reservation_seq 1 0
booking_schedule 8 0
booking_schedule_seq 1 0
booking_schedule_slot 4 0
booking_settings 5 0
booking_user 3 0
bookmark_data 6 1
bookmark_data_seq 1 1
bookmark_social_bm 5 15
bookmark_social_bm_seq 1 1
bookmark_tree 6 1
cache_clob 10 0
cache_text 10 0
cal_auth_token 6 0
cal_cat_assignments 2 0
cal_categories 10 0
cal_categories_hidden 2 0
cal_categories_seq 1 0
cal_ch_settings 2 0
cal_entries 16 0
cal_entries_seq 1 0
cal_entry_responsible 2 0
cal_notification 5 0
cal_notification_seq 1 0
cal_rec_exclusion 3 0
cal_rec_exclusion_seq 1 0
cal_recurrence_rules 14 0
cal_recurrence_rules_seq 1 0
cal_registrations 4 0
cal_shared 4 0
cal_shared_status 3 0
catch_write_events 3 0
chat_blocked 2 0
chat_invitations 5 0
chat_record_data 4 0
chat_record_data_seq 1 0
chat_records 8 0
chat_records_seq 1 0
chat_room_messages 5 0
chat_room_messages_seq 1 0
chat_rooms 4 0
chat_rooms_seq 1 0
chat_smilies 3 0
chat_smilies_seq 1 0
chat_user 5 0
chatroom_admconfig 4 0
chatroom_admconfig_seq 1 0
chatroom_bans 4 0
chatroom_history 4 0
chatroom_proomaccess 2 0
chatroom_prooms 7 0
chatroom_prooms_seq 1 0
chatroom_psessions 4 0
chatroom_sessions 5 0
chatroom_settings 11 2
chatroom_settings_seq 1 1
chatroom_smilies 3 0
chatroom_smilies_seq 1 0
chatroom_uploads 6 0
chatroom_uploads_seq 1 0
chatroom_users 4 0
cmi_comment 6 0
cmi_comment_seq 1 0
cmi_correct_response 3 0
cmi_correct_response_seq 1 0
cmi_custom 6 0
cmi_gobjective 11 0
cmi_interaction 10 0
cmi_interaction_seq 1 0
cmi_node 44 0
cmi_node_seq 1 0
cmi_objective 13 0
cmi_objective_seq 1 0
conditions 12 0
conditions_seq 1 0
container_reference 3 0
container_settings 3 0
container_sorting 5 0
container_sorting_set 2 0
content_object 23 0
copy_wizard_options 3 0
cp_auxilaryresource 3 0
cp_condition 5 0
cp_datamap 6 0
cp_dependency 2 0
cp_file 2 0
cp_hidelmsui 2 0
cp_item 12 0
cp_manifest 7 0
cp_mapinfo 6 0
cp_node 3 0
cp_node_seq 1 0
cp_objective 5 0
cp_organization 6 0
cp_package 11 0
cp_resource 6 0
cp_rule 7 0
cp_sequencing 33 0
cp_suspend 3 0
cp_tree 6 0
crs_archives 7 0
crs_archives_seq 1 0
crs_f_definitions 6 0
crs_f_definitions_seq 1 0
crs_file 5 0
crs_file_seq 1 0
crs_groupings 4 0
crs_items 12 0
crs_lm_history 5 0
crs_objective_lm 5 0
crs_objective_lm_seq 1 0
crs_objective_qst 5 0
crs_objective_qst_seq 1 0
crs_objective_status 3 0
crs_objective_status_p 2 0
crs_objective_tst 6 0
crs_objective_tst_seq 1 0
crs_objectives 6 0
crs_objectives_seq 1 0
crs_settings 38 0
crs_start 3 0
crs_start_seq 1 0
crs_timings_planed 4 0
crs_timings_usr_accept 5 0
crs_user_data 3 0
crs_waiting_list 3 0
ctrl_calls 3 1,090
ctrl_classfile 5 845
ctrl_structure 4 5
data_cache 3 0
dav_lock 9 0
dav_property 5 0
dbk_translations 2 0
desktop_item 4 0
didactic_tpl_a 3 0
didactic_tpl_a_seq 1 0
didactic_tpl_abr 2 0
didactic_tpl_alp 4 0
didactic_tpl_alr 2 0
didactic_tpl_fp 6 0
didactic_tpl_fp_seq 1 0
didactic_tpl_objs 3 0
didactic_tpl_sa 2 0
didactic_tpl_settings 6 0
didactic_tpl_settings_seq 1 0
ecs_cmap_rule 10 0
ecs_cmap_rule_seq 1 0
ecs_cms_data 9 0
ecs_cms_data_seq 1 0
ecs_cms_tree 6 0
ecs_community 5 0
ecs_container_mapping 7 0
ecs_container_mapping_seq 1 0
ecs_course_assignments 8 0
ecs_course_assignments_seq 1 0
ecs_crs_mapping_atts 4 0
ecs_crs_mapping_atts_seq 1 0
ecs_data_mapping 4 0
ecs_events 5 0
ecs_events_seq 1 0
ecs_export 3 0
ecs_import 7 0
ecs_node_mapping_a 9 0
ecs_part_settings 7 0
ecs_server 21 0
ecs_server_seq 1 0
event 11 0
event_appointment 7 0
event_appointment_seq 1 0
event_file 5 0
event_file_seq 1 0
event_items 2 0
event_participants 6 0
event_seq 1 0
exc_assignment 9 0
exc_assignment_seq 1 0
exc_data 8 0
exc_mem_ass_status 13 0
exc_members 11 0
exc_returned 8 0
exc_returned_seq 1 0
exc_usr_tutor 5 0
export_file_info 6 0
export_options 6 0
feedback_items 15 0
feedback_items_seq 1 0
feedback_results 5 0
file_based_lm 3 0
file_data 6 0
file_usage 4 0
frm_data 13 0
frm_data_seq 1 0
frm_notification 7 0
frm_notification_seq 1 0
frm_posts 15 0
frm_posts_seq 1 0
frm_posts_tree 8 0
frm_posts_tree_seq 1 0
frm_settings 11 0
frm_thread_access 6 0
frm_threads 13 0
frm_threads_seq 1 0
frm_user_read 4 0
glossary 10 0
glossary_definition 5 0
glossary_definition_seq 1 0
glossary_term 7 0
glossary_term_seq 1 0
grp_settings 19 0
help_map 6 0
help_module 2 0
help_module_seq 1 0
help_tooltip 6 0
help_tooltip_seq 1 0
history 8 0
history_seq 1 0
il_block_setting 5 0
il_blog 8 0
il_blog_posting 6 0
il_blog_posting_seq 1 0
il_certificate 1 0
il_component 3 87
il_custom_block 7 0
il_custom_block_seq 1 0
il_dcl_data 7 0
il_dcl_data_seq 1 0
il_dcl_datatype 4 9
il_dcl_datatype_prop 4 10
il_dcl_field 8 0
il_dcl_field_prop 4 0
il_dcl_field_prop_seq 1 0
il_dcl_field_seq 1 0
il_dcl_record 6 0
il_dcl_record_field 3 0
il_dcl_record_field_seq 1 0
il_dcl_record_seq 1 0
il_dcl_stloc1_value 3 0
il_dcl_stloc1_value_seq 1 0
il_dcl_stloc2_value 3 0
il_dcl_stloc2_value_seq 1 0
il_dcl_stloc3_value 3 0
il_dcl_stloc3_value_seq 1 0
il_dcl_table 12 0
il_dcl_table_seq 1 0
il_dcl_view 4 0
il_dcl_view_seq 1 0
il_dcl_viewdefinition 4 0
il_event_handling 3 37
il_exc_team 3 0
il_exc_team_log 5 0
il_exc_team_seq 1 0
il_external_feed_block 2 0
il_external_feed_block_seq 1 0
il_html_block 2 0
il_log 4 0
il_md_cpr_selections 7 6
il_md_cpr_selections_seq 1 1
il_media_cast_data 7 0
il_media_cast_data_ord 3 0
il_meta_annotation 8 0
il_meta_annotation_seq 1 0
il_meta_classification 7 0
il_meta_classification_seq 1 0
il_meta_contribute 8 0
il_meta_contribute_seq 1 0
il_meta_description 8 0
il_meta_description_seq 1 0
il_meta_educational 12 0
il_meta_educational_seq 1 0
il_meta_entity 7 0
il_meta_entity_seq 1 0
il_meta_format 5 0
il_meta_format_seq 1 0
il_meta_general 9 0
il_meta_general_seq 1 0
il_meta_identifier 8 0
il_meta_identifier_ 8 0
il_meta_identifier__seq 1 0
il_meta_identifier_seq 1 0
il_meta_keyword 8 0
il_meta_keyword_seq 1 0
il_meta_language 7 0
il_meta_language_seq 1 0
il_meta_lifecycle 7 0
il_meta_lifecycle_seq 1 0
il_meta_location 8 0
il_meta_location_seq 1 0
il_meta_meta_data 6 0
il_meta_meta_data_seq 1 0
il_meta_relation 5 0
il_meta_relation_seq 1 0
il_meta_requirement 13 0
il_meta_requirement_seq 1 0
il_meta_rights 8 0
il_meta_rights_seq 1 0
il_meta_tar 10 0
il_meta_tar_seq 1 0
il_meta_taxon 9 0
il_meta_taxon_path 8 0
il_meta_taxon_path_seq 1 0
il_meta_taxon_seq 1 0
il_meta_technical 10 0
il_meta_technical_seq 1 0
il_news_item 20 0
il_news_item_seq 1 0
il_news_read 2 0
il_news_subscription 2 0
il_object_def 20 90
il_object_group 3 8
il_object_subobj 3 303
il_plugin 8 0
il_pluginslot 3 8
il_poll 8 0
il_poll_answer 4 0
il_poll_answer_seq 1 0
il_poll_vote 3 0
il_rating 8 0
il_rating_cat 5 0
il_rating_cat_seq 1 0
il_request_token 4 0
il_subscribers 4 0
il_tag 7 0
il_verification 4 0
il_wiki_contributor 4 0
il_wiki_data 12 0
il_wiki_imp_pages 4 0
il_wiki_missing_page 3 0
il_wiki_page 5 0
il_wiki_page_seq 1 0
ilinc_data 18 0
ilinc_registration 4 0
int_link 5 0
item_group_item 2 0
last_visited 6 0
ldap_attribute_mapping 4 0
ldap_rg_mapping 9 0
ldap_rg_mapping_seq 1 0
ldap_role_assignments 12 0
ldap_role_assignments_seq 1 0
ldap_server_settings 32 0
ldap_server_settings_seq 1 0
license_data 4 0
link_check 6 0
link_check_report 2 0
lm_data 10 1
lm_data_seq 1 1
lm_menu 7 0
lm_menu_seq 1 0
lm_tree 6 0
lng_data 6 13,022
lng_modules 3 96
lo_access 5 0
loginname_history 3 0
mail 16 0
mail_attachment 2 0
mail_obj_data 4 6
mail_obj_data_seq 1 1
mail_options 5 1
mail_saved 10 0
mail_seq 1 0
mail_template 8 0
mail_tree 6 6
map_area 12 0
media_item 14 0
media_item_seq 1 0
member_agreement 4 0
mep_data 3 0
mep_item 4 1
mep_item_seq 1 1
mep_tree 6 0
mob_parameter 3 0
mob_usage 4 0
module_class 3 29 Class information of ILIAS Modules
note 12 0
note_seq 1 0
note_settings 4 0
notification 5 0
notification_channels 6 2
notification_data 2 0
notification_data_seq 1 0
notification_listener 4 0
notification_osd 6 0
notification_osd_seq 1 0
notification_queue 3 0
notification_types 5 2
notification_usercfg 3 3
obj_lp_stat 11 0
obj_members 7 0
obj_stat 11 0
obj_stat_log 11 0
obj_stat_tmp 11 0
obj_type_stat 8 0
obj_user_stat 6 0
object_data 8 162
object_data_seq 1 1
object_description 2 0
object_reference 3 43
object_reference_seq 1 1
object_reference_ws 3 0
object_reference_ws_seq 1 0
object_translation 5 1
openid_provider 5 1
openid_provider_seq 1 1
org_unit_assignments 6 0
org_unit_data 4 1
org_unit_data_seq 1 1
org_unit_tree 6 1
page_anchor 3 0
page_editor_settings 3 0
page_history 8 0
page_layout 9 5
page_layout_seq 1 1
page_object 19 5
page_pc_usage 5 0
page_qst_answer 5 0
page_question 3 0
page_style_usage 6 0
payment_coupons 13 0
payment_coupons_codes 3 0
payment_coupons_codes_seq 1 0
payment_coupons_obj 2 0
payment_coupons_seq 1 0
payment_coupons_track 4 0
payment_coupons_track_seq 1 0
payment_currencies 5 0
payment_currencies_seq 1 0
payment_erp 7 2
payment_erps 4 2
payment_news 7 0
payment_news_seq 1 0
payment_objects 10 0
payment_objects_seq 1 0
payment_paymethods 4 4
payment_paymethods_seq 1 1
payment_prices 11 0
payment_prices_seq 1 0
payment_settings 3 32
payment_shopping_cart 5 0
payment_shopping_cart_seq 1 0
payment_statistic 27 0
payment_statistic_coup 3 0
payment_statistic_seq 1 0
payment_topic_usr_sort 3 0
payment_topics 5 0
payment_topics_seq 1 0
payment_trustees 5 0
payment_vats 3 0
payment_vats_seq 1 0
payment_vendors 2 0
personal_clipboard 7 0
personal_pc_clipboard 4 0
qpl_a_cloze 11 0
qpl_a_cloze_seq 1 0
qpl_a_errortext 6 0
qpl_a_errortext_seq 1 0
qpl_a_essay 4 0
qpl_a_essay_seq 1 0
qpl_a_imagemap 8 0
qpl_a_imagemap_seq 1 0
qpl_a_matching 5 0
qpl_a_matching_seq 1 0
qpl_a_mc 8 0
qpl_a_mc_seq 1 0
qpl_a_mdef 5 0
qpl_a_mdef_seq 1 0
qpl_a_mterm 4 0
qpl_a_mterm_seq 1 0
qpl_a_ordering 6 0
qpl_a_ordering_seq 1 0
qpl_a_sc 7 0
qpl_a_sc_seq 1 0
qpl_a_textsubset 6 0
qpl_a_textsubset_seq 1 0
qpl_fb_cloze 5 0
qpl_fb_cloze_seq 1 0
qpl_fb_errortext 5 0
qpl_fb_errortext_seq 1 0
qpl_fb_essay 5 0
qpl_fb_essay_seq 1 0
qpl_fb_generic 5 0
qpl_fb_generic_seq 1 0
qpl_fb_imap 5 0
qpl_fb_imap_seq 1 0
qpl_fb_matching 5 0
qpl_fb_matching_seq 1 0
qpl_fb_mc 5 0
qpl_fb_mc_seq 1 0
qpl_fb_sc 5 0
qpl_fb_sc_seq 1 0
qpl_hint_tracking 5 0
qpl_hint_tracking_seq 1 0
qpl_hints 5 0
qpl_hints_seq 1 0
qpl_num_range 7 0
qpl_num_range_seq 1 0
qpl_qst_cloze 4 0
qpl_qst_errortext 4 0
qpl_qst_essay 6 0
qpl_qst_fileupload 4 0
qpl_qst_flash 5 0
qpl_qst_horder 3 0
qpl_qst_imagemap 2 0
qpl_qst_javaapplet 3 0
qpl_qst_matching 5 0
qpl_qst_mc 6 0
qpl_qst_numeric 2 0
qpl_qst_ordering 6 0
qpl_qst_sc 5 0
qpl_qst_textsubset 3 0
qpl_qst_type 3 14
qpl_questionpool 5 0
qpl_questionpool_seq 1 0
qpl_questions 15 0
qpl_questions_seq 1 0
qpl_sol_sug 8 0
qpl_sol_sug_seq 1 0
rbac_fa 4 22
rbac_log 5 0
rbac_operations 5 68
rbac_operations_seq 1 1
rbac_pa 3 20
rbac_ta 2 574
rbac_templates 4 1,361
rbac_ua 2 2
rcat_settings 5 0
read_event 8 0
reg_access_limit 6 0
reg_er_assignments 3 1
reg_er_assignments_seq 1 1
reg_registration_codes 5 0
reg_registration_codes_seq 1 0
remote_course_settings 8 0
rfil_settings 7 0
rglo_settings 6 0
rgrp_settings 8 0
rlm_settings 6 0
role_data 5 7
role_desktop_items 4 0
role_desktop_items_seq 1 0
rtst_settings 8 0
rwik_settings 6 0
sahs_lm 33 0
sahs_sc13_sco 2 0
sahs_sc13_seq_assign 2 0
sahs_sc13_seq_cond 5 0
sahs_sc13_seq_course 4 0
sahs_sc13_seq_item 10 0
sahs_sc13_seq_mapinfo 6 0
sahs_sc13_seq_node 3 0
sahs_sc13_seq_node_seq 1 0
sahs_sc13_seq_obj 6 0
sahs_sc13_seq_rule 7 0
sahs_sc13_seq_seq 34 0
sahs_sc13_seq_templ 2 0
sahs_sc13_seq_templts 3 4
sahs_sc13_seq_templts_seq 1 1
sahs_sc13_seq_tree 6 0
sahs_sc13_tree 6 0
sahs_sc13_tree_node 7 1
sahs_sc13_tree_node_seq 1 1
sc_item 11 0
sc_manifest 4 0
sc_organization 3 0
sc_organizations 2 0
sc_resource 6 0
sc_resource_dependen 4 0
sc_resource_dependen_seq 1 0
sc_resource_file 4 0
sc_resource_file_seq 1 0
sc_resources 2 0
scorm_object 4 0
scorm_object_seq 1 0
scorm_tracking 6 0
scorm_tree 6 0
search_command_queue 7 0
search_data 5 0
search_data_seq 1 0
search_tree 6 0
service_class 3 17 Class information of ILIAS Modules
settings 3 136
settings_deactivated_s 2 0
shib_role_assignment 8 0
shib_role_assignment_seq 1 0
skl_assigned_material 6 0
skl_level 7 0
skl_level_seq 1 0
skl_personal_skill 2 0
skl_self_eval 5 0
skl_self_eval_level 6 0
skl_self_eval_seq 1 0
skl_templ_ref 2 0
skl_tree 6 1
skl_tree_node 8 1
skl_tree_node_seq 1 1
skl_user_has_level 7 0
skl_user_skill_level 9 0
style_char 4 0
style_color 3 0
style_data 5 0
style_folder_styles 2 0
style_parameter 7 0
style_parameter_seq 1 0
style_setting 3 0
style_template 5 0
style_template_class 3 0
style_template_seq 1 0
style_usage 2 0
svy_anonymous 7 0
svy_anonymous_seq 1 0
svy_answer 7 0
svy_answer_seq 1 0
svy_category 6 35
svy_category_seq 1 1
svy_constraint 5 0
svy_constraint_seq 1 0
svy_finished 7 0
svy_finished_seq 1 0
svy_inv_usr 4 0
svy_inv_usr_seq 1 0
svy_material 10 0
svy_material_seq 1 0
svy_phrase 5 22
svy_phrase_cat 6 70
svy_phrase_cat_seq 1 1
svy_phrase_seq 1 1
svy_qblk 6 0
svy_qblk_qst 4 0
svy_qblk_qst_seq 1 0
svy_qblk_seq 1 0
svy_qpl 4 0
svy_qpl_seq 1 0
svy_qst_constraint 4 0
svy_qst_constraint_seq 1 0
svy_qst_matrix 18 0
svy_qst_matrixrows 6 0
svy_qst_matrixrows_seq 1 0
svy_qst_mc 5 0
svy_qst_metric 2 0
svy_qst_oblig 5 0 Contains the obligatory state of questions in a survey
svy_qst_oblig_seq 1 0
svy_qst_sc 2 0
svy_qst_text 4 0
svy_qtype 3 5
svy_qtype_seq 1 1
svy_question 14 0
svy_question_seq 1 0
svy_relation 4 6
svy_relation_seq 1 1
svy_settings 5 0
svy_settings_seq 1 0
svy_svy 21 0
svy_svy_qst 6 0
svy_svy_qst_seq 1 0
svy_svy_seq 1 0
svy_times 4 0
svy_variable 9 0
svy_variable_seq 1 0
syst_style_cat 4 0
table_properties 4 0
table_templates 4 0
tax_data 2 0
tax_node 7 1
tax_node_assignment 4 0
tax_node_seq 1 1
tax_tree 6 0
tax_usage 2 0
tree 6 43
tree_workspace 6 0
tst_active 10 0
tst_active_seq 1 0
tst_invited_user 4 0
tst_manual_fb 6 0
tst_manual_fb_seq 1 0
tst_mark 7 0 Mark steps of mark schemas
tst_mark_seq 1 0
tst_pass_result 11 0
tst_qst_solved 3 0
tst_result_cache 12 0
tst_rnd_cpy 4 0
tst_rnd_cpy_seq 1 0
tst_rnd_qpl_title 4 0
tst_rnd_qpl_title_seq 1 0
tst_sequence 6 0
tst_solutions 8 0 Test and Assessment solutions
tst_solutions_seq 1 0
tst_test_defaults 6 0
tst_test_defaults_seq 1 0
tst_test_question 6 0 Relation table for questions in tests
tst_test_question_seq 1 0
tst_test_random 6 0 Questionpools taken for a random test
tst_test_random_seq 1 0
tst_test_result 10 0 Test and Assessment user results for test questions
tst_test_result_seq 1 0
tst_test_rnd_qst 6 0 Relation table for random questions in tests
tst_test_rnd_qst_seq 1 0
tst_tests 78 0 Tests in ILIAS Assessment
tst_tests_seq 1 0
tst_times 6 0 Editing times of an assessment test
tst_times_seq 1 0
udf_clob 3 0
udf_data 1 2
udf_definition 15 0
udf_definition_seq 1 0
udf_text 3 0
usr_account_codes 5 0
usr_account_codes_seq 1 0
usr_data 60 2
usr_ext_profile_page 4 0
usr_ext_profile_page_seq 1 0
usr_form_settings 3 0
usr_portf_acl 3 0
usr_portfolio 8 0
usr_portfolio_page 5 0
usr_portfolio_page_seq 1 0
usr_pref 3 15
usr_pwassist 4 0
usr_search 9 0
usr_sess_istorage 4 0
usr_session 9 1
usr_session_log 3 0
usr_session_stats 15 0
usr_session_stats_raw 6 0
ut_access 14 0
ut_access_seq 1 0
ut_lp_collections 5 0
ut_lp_marks 9 0
ut_lp_settings 4 0
ut_lp_user_status 4 0
ut_online 3 0
webr_items 11 0
webr_items_seq 1 0
webr_params 5 0
webr_params_seq 1 0
write_event 6 25
write_event_seq 1 1
xhtml_page 3 0
xhtml_page_seq 1 0
xmlnestedset 5 0
xmlnestedsettmp 6 0
xmlparam 3 0
xmltags 3 0
xmltags_seq 1 0
xmlvalue 3 0
xmlvalue_seq 1 0
           
780 Tables     3,776 23,236  
0 Views     0