SchemaSpy Analysis of iliasRelease_3_9_x_branch Generated by
SchemaSpy
Generated by SchemaSpy on Fri Dec 13 20:19 CET 2013
Database Type: MySQL - 5.1.72-2 SourceForge.net


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

Table Children Parents Columns Rows Comments
acc_cache 3 0
addressbook 6 0
addressbook_mailing_lists 6 0
addressbook_mailing_lists_assignments 3 0
adv_md_field_definition 10 0
adv_md_record 5 0
adv_md_record_objs 2 0
adv_md_substitutions 4 0
adv_md_values 4 0
aicc_course 15 0
aicc_object 7 0
aicc_units 12 0
ass_log 9 0 Logging of Test&Assessment object changes
benchmark 4 0
bookmark_data 6 1
bookmark_tree 6 1
chat_blocked 2 0
chat_invitations 5 0
chat_record_data 4 0
chat_records 8 0
chat_room_messages 5 0
chat_rooms 4 0
chat_user 5 0
cmi_comment 6 0
cmi_correct_response 3 0
cmi_gobjective 6 0
cmi_interaction 10 0
cmi_node 43 0
cmi_objective 13 0
conditions 10 0
container_settings 3 0
container_sorting 3 0
container_sorting_settings 2 0
content_object 20 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_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_defined_field_definitions 6 0
crs_file 5 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_qst 5 0
crs_objective_results 4 0
crs_objective_status 3 0
crs_objective_status_pretest 2 0
crs_objective_tst 6 0
crs_objectives 6 0
crs_settings 30 0
crs_start 3 0
crs_subscribers 3 0
crs_timings_planed 4 0
crs_timings_usr_accept 5 0
crs_user_data 3 0
crs_waiting_list 3 0
ctrl_calls 2 417
ctrl_classfile 2 118
ctrl_structure 4 5
dbk_translations 2 0
desktop_item 4 0
dp_changed_dates 5 0 Tabelle f?r Anzeige von Ge?nderten Termindaten
dp_dates 11 0 Termin Tabelle
dp_keyword 3 0 Tabelle f?r Schlagw?rter
dp_keywords 3 0 Tabelle f?r die Zuordnung der Schlagw?rter
dp_neg_dates 4 0 Tabelle f?r die negativen Termine
dp_properties 4 0 Tabelle f?r UserEinstellungen
ecs_export 2 0
ecs_import 2 0
event 11 0
event_appointment 5 0
event_file 5 0
event_items 2 0
event_participants 6 0
exc_data 3 0
exc_members 11 0
exc_returned 7 0
exc_usr_tutor 4 0
feedback_items 15 0
feedback_results 5 0
file_based_lm 3 0
file_data 6 0
file_usage 3 0
frm_data 13 0
frm_notification 4 0
frm_posts 15 0
frm_posts_tree 8 0
frm_settings 5 0
frm_thread_access 5 0
frm_threads 13 0
frm_user_read 4 0
glossary 7 0
glossary_definition 4 0
glossary_term 7 0
grp_data 8 0
grp_registration 4 0
history 8 0
il_block_setting 5 0
il_custom_block 7 0
il_external_feed_block 2 0
il_html_block 2 0
il_log 4 0
il_md_copyright_selections 7 6
il_media_cast_data 3 0
il_meta_annotation 8 0
il_meta_classification 7 0
il_meta_contribute 8 0
il_meta_description 8 0
il_meta_educational 12 0
il_meta_entity 7 0
il_meta_format 5 0
il_meta_general 9 0
il_meta_identifier 8 0
il_meta_identifier_ 8 0
il_meta_keyword 8 0
il_meta_language 7 0
il_meta_lifecycle 7 0
il_meta_location 8 0
il_meta_meta_data 6 0
il_meta_relation 5 0
il_meta_requirement 13 0
il_meta_rights 8 0
il_meta_taxon 9 0
il_meta_taxon_path 8 0
il_meta_technical 10 0
il_meta_typical_age_range 10 0
il_news_item 17 0
il_news_read 2 0
il_news_subscription 2 0
ilinc_data 18 0
ilinc_registration 4 0
int_link 5 0
ldap_attribute_mapping 4 0
ldap_role_assignments 9 0
ldap_role_group_mapping 9 0
ldap_server_settings 29 0
link_check 6 0
link_check_report 2 0
lm_data 9 1
lm_menu 7 0
lm_tree 6 0
lng_data 4 7,747
lng_modules 3 40
lo_access 5 0
mail 16 0
mail_attachment 2 0
mail_obj_data 4 6
mail_options 5 1
mail_saved 10 0
mail_tree 6 6
map_area 10 0
media_item 13 0
member_agreement 4 0
member_export_user_settings 2 0
mep_tree 6 0
meta_data 5 0
meta_keyword 4 0
meta_techn_format 3 0
meta_techn_loc 4 0
meta_technical 9 0
mob_parameter 3 0
mob_usage 3 0
module 2 15 ILIAS Modules
module_class 3 18 Class information of ILIAS Modules
note 11 0
note_data 8 0
object_data 8 110
object_description 2 0
object_reference 3 24
object_translation 5 1
page_object 4 0
payment_bill_vendor 19 0
payment_coupons 13 0
payment_coupons_codes 3 0
payment_coupons_objects 2 0
payment_coupons_tracking 4 0
payment_currencies 3 1
payment_objects 5 0
payment_prices 6 0
payment_settings 10 0
payment_shopping_cart 4 0
payment_statistic 14 0
payment_statistic_coupons 3 0
payment_trustees 5 0
payment_vendors 2 0
personal_clipboard 4 0
qpl_answer_cloze 13 0
qpl_answer_imagemap 9 0
qpl_answer_matching 8 0
qpl_answer_multiplechoice 8 0
qpl_answer_ordering 7 0
qpl_answer_singlechoice 7 0
qpl_answer_textsubset 6 0
qpl_feedback_generic 5 0
qpl_feedback_imagemap 5 0
qpl_feedback_multiplechoice 5 0
qpl_feedback_singlechoice 5 0
qpl_numeric_range 7 0
qpl_question_cloze 4 0
qpl_question_essay 4 0
qpl_question_flashapp 3 0
qpl_question_imagemap 2 0
qpl_question_javaapplet 3 0
qpl_question_matching 3 0
qpl_question_multiplechoice 2 0
qpl_question_numeric 2 0
qpl_question_ordering 2 0
qpl_question_singlechoice 2 0
qpl_question_textsubset 3 0
qpl_question_type 2 11
qpl_questionpool 5 0
qpl_questions 14 0
qpl_suggested_solutions 6 0
rbac_fa 4 19
rbac_operations 5 53
rbac_pa 3 18
rbac_ta 2 347
rbac_templates 4 991
rbac_ua 2 2
reg_access_limitation 6 0
reg_email_role_assignments 3 1
remote_course_settings 6 0
role_data 4 6
role_desktop_items 4 0
sahs_lm 8 0
sc_item 11 0
sc_manifest 4 0
sc_organization 3 0
sc_organizations 2 0
sc_resource 6 0
sc_resource_dependency 4 0
sc_resource_file 4 0
sc_resources 2 0
scorm_object 4 0
scorm_tracking 5 0
scorm_tree 6 0
search_data 5 0
search_tree 6 0
service 2 6 ILIAS Modules
service_class 3 6 Class information of ILIAS Modules
settings 3 73
settings_deactivated_styles 2 0
style_data 5 0
style_folder_styles 2 0
style_parameter 6 0
survey_anonymous 5 0
survey_answer 10 0
survey_category 6 35
survey_constraint 4 0
survey_finished 6 0
survey_invited_group 4 0
survey_invited_user 4 0
survey_material 6 0
survey_phrase 5 22
survey_phrase_category 4 70
survey_question 13 0
survey_question_constraint 4 0
survey_question_material 4 0
survey_question_matrix 18 0
survey_question_matrix_rows 4 0
survey_question_metric 2 0
survey_question_nominal 3 0
survey_question_obligatory 5 0 Contains the obligatory state of questions in a survey
survey_question_ordinal 2 0
survey_question_text 4 0
survey_questionblock 5 0
survey_questionblock_question 4 0
survey_questionpool 4 0
survey_questiontype 3 5
survey_relation 4 6
survey_survey 16 0
survey_survey_question 6 0
survey_variable 7 0
tree 6 24
tst_active 11 0
tst_active_qst_sol_settings 3 0
tst_eval_settings 12 0 User settings for statistical evaluation tool
tst_invited_user 4 0
tst_manual_feedback 6 0
tst_mark 7 0 Mark steps of mark schemas
tst_sequence 6 0
tst_solutions 8 0 Test and Assessment solutions
tst_test_defaults 6 0
tst_test_pass_result 4 0
tst_test_question 5 0 Relation table for questions in tests
tst_test_random 5 0 Questionpools taken for a random test
tst_test_random_question 6 0 Relation table for random questions in tests
tst_test_result 6 0 Test and Assessment user results for test questions
tst_tests 47 0 Tests in ILIAS Assessment
tst_times 6 0 Editing times of an assessment test
user_defined_field_definition 10 0
usr_data 50 2
usr_defined_data 1 2
usr_new_account_mail 6 0
usr_pref 3 15
usr_pwassist 4 0
usr_search 6 0
usr_session 5 0
ut_access 13 0
ut_learning_progress 7 0
ut_lp_collections 2 0
ut_lp_event_collections 2 0
ut_lp_filter 5 0
ut_lp_marks 5 0
ut_lp_settings 4 0
ut_online 3 0
webr_items 11 0
webr_params 5 0
xhtml_page 3 0
xml_attribute_idx 3 0
xml_attribute_name 2 0
xml_attribute_namespace 3 0
xml_attribute_value 2 0
xml_cdata 2 0
xml_comment 2 0
xml_element_idx 2 0
xml_element_name 2 0
xml_element_namespace 3 0
xml_entity_reference 3 0
xml_node_type 4 9
xml_object 5 0 Master Table for XML objects
xml_pi_data 3 0
xml_pi_target 3 0
xml_text 2 0
xml_tree 11 0
xmlnestedset 5 0
xmlparam 3 0
xmltags 3 0
xmlvalue 3 0
           
346 Tables     2,139 10,241  
0 Views     0