SchemaSpy Analysis of iliasRelease_4_0_x_branch◀  ilDoc Overview Generated by
SchemaSpy
Generated by SchemaSpy on Wed Apr 27 19:42 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
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
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 4 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 5 0
cal_categories_hidden 2 0
cal_categories_seq 1 0
cal_entries 15 0
cal_entries_seq 1 0
cal_entry_responsible 2 0
cal_recurrence_rules 14 0
cal_recurrence_rules_seq 1 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
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 6 0
cmi_interaction 10 0
cmi_interaction_seq 1 0
cmi_node 43 0
cmi_node_seq 1 0
cmi_objective 13 0
cmi_objective_seq 1 0
conditions 10 0
conditions_seq 1 0
container_reference 2 0
container_settings 3 0
container_sorting 5 0
container_sorting_set 2 0
content_object 22 0
copy_wizard_options 3 0
cp_auxilaryresource 3 0
cp_condition 5 0
cp_dependency 2 0
cp_file 2 0
cp_hidelmsui 2 0
cp_item 10 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 10 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_members 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 34 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 690
ctrl_classfile 5 620
ctrl_structure 4 5
data_cache 3 0
dav_lock 9 0
dav_property 5 0
dbk_translations 2 0
desktop_item 4 0
ecs_container_mapping 7 0
ecs_events 4 0
ecs_events_seq 1 0
ecs_export 2 0
ecs_import 3 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_data 3 0
exc_members 11 0
exc_returned 7 0
exc_returned_seq 1 0
exc_usr_tutor 4 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 7 0
frm_thread_access 6 0
frm_threads 13 0
frm_threads_seq 1 0
frm_user_read 4 0
glossary 7 0
glossary_definition 4 0
glossary_definition_seq 1 0
glossary_term 7 0
glossary_term_seq 1 0
grp_settings 16 0
history 8 0
history_seq 1 0
il_block_setting 5 0
il_component 3 60
il_custom_block 7 0
il_custom_block_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 5 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 19 0
il_news_item_seq 1 0
il_news_read 2 0
il_news_subscription 2 0
il_object_def 16 65
il_object_group 3 3
il_object_subobj 3 211
il_plugin 8 0
il_pluginslot 3 8
il_rating 6 0
il_request_token 4 0
il_subscribers 4 0
il_tag 7 0
il_wiki_contributor 4 0
il_wiki_data 6 0
il_wiki_missing_page 3 0
il_wiki_page 3 0
il_wiki_page_seq 1 0
ilinc_data 18 0
ilinc_registration 4 0
int_link 5 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 30 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 10,155
lng_modules 3 59
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 7 0
mail_tree 6 6
map_area 10 0
media_item 14 0
media_item_seq 1 0
member_agreement 4 0
member_usr_settings 2 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 22 Class information of ILIAS Modules
note 11 0
note_seq 1 0
object_data 8 131
object_data_seq 1 1
object_description 2 0
object_reference 3 33
object_reference_seq 1 1
object_translation 5 1
page_anchor 3 0
page_editor_settings 3 0
page_history 8 0
page_layout 5 5
page_layout_seq 1 1
page_object 18 5
page_pc_usage 5 0
page_question 3 0
page_style_usage 6 0
payment_bill_vendor 19 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 3 1
payment_erp 7 2
payment_erps 4 2
payment_news 7 0
payment_news_seq 1 0
payment_objects 8 0
payment_objects_seq 1 0
payment_prices 6 0
payment_prices_seq 1 0
payment_settings 19 0
payment_settings_seq 1 0
payment_shopping_cart 4 0
payment_shopping_cart_seq 1 0
payment_statistic 22 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_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_generic 5 0
qpl_fb_generic_seq 1 0
qpl_fb_imap 5 0
qpl_fb_imap_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_num_range 7 0
qpl_num_range_seq 1 0
qpl_qst_cloze 4 0
qpl_qst_errortext 4 0
qpl_qst_essay 4 0
qpl_qst_fileupload 3 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 5 0
qpl_qst_numeric 2 0
qpl_qst_ordering 4 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 19
rbac_operations 5 58
rbac_operations_seq 1 1
rbac_pa 3 18
rbac_ta 2 434
rbac_templates 4 1,091
rbac_ua 2 2
read_event 6 0
reg_access_limit 6 0
reg_er_assignments 3 1
reg_er_assignments_seq 1 1
remote_course_settings 8 0
role_data 5 6
role_desktop_items 4 0
role_desktop_items_seq 1 0
sahs_lm 19 0
sahs_sc13_seq_assign 2 0
sahs_sc13_seq_cond 5 0
sahs_sc13_seq_course 4 0
sahs_sc13_seq_item 9 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 10 Class information of ILIAS Modules
settings 3 87
settings_deactivated_s 2 0
shib_role_assignment 8 0
shib_role_assignment_seq 1 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 5 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 4 0
svy_constraint_seq 1 0
svy_finished 6 0
svy_finished_seq 1 0
svy_inv_grp_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 4 70
svy_phrase_cat_seq 1 1
svy_phrase_seq 1 1
svy_qblk 5 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_mat_seq 1 0
svy_qst_matrix 18 0
svy_qst_matrixrows 4 0
svy_qst_matrixrows_seq 1 0
svy_qst_mc 2 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 13 0
svy_question_seq 1 0
svy_relation 4 6
svy_relation_seq 1 1
svy_svy 16 0
svy_svy_qst 6 0
svy_svy_qst_seq 1 0
svy_svy_seq 1 0
svy_variable 7 0
svy_variable_seq 1 0
table_properties 4 0
tree 6 33
tst_active 9 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 8 0
tst_qst_solved 3 0
tst_result_cache 9 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 5 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 7 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 55 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 11 0
udf_definition_seq 1 0
udf_text 3 0
usr_data 56 2
usr_pref 3 15
usr_pwassist 4 0
usr_search 8 0
usr_session 6 1
ut_access 14 0
ut_access_seq 1 0
ut_lp_collections 2 0
ut_lp_filter 5 0
ut_lp_marks 5 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
           
575 Tables     2,772 18,906  
0 Views     0