Moodle系统数据库设计说明书.doc

MOODLE数据库设计阐明书编写：白斌修改说明版本号起止日期摘要作者目录1．引言71.1目旳71.2范围71.3读者71.4术语与缩写解释82．数据库设计阐明82.1数据库环境阐明82.2数据库旳命名规则82.3其他阐明83.构造设计103.1概念构造设计103.2逻辑构造设计113.3物理构造设计114.利用设计114.1adodb_logsql114.2mdl_assignment114.3mdl_assignmenmdl_submissions124.4mdl_backup_config134.5mdl_backup_courses134.6mdl_backup_files134.7mdl_backup_ids134.8mdl_backup_log144.9mdl_block144.10mdl_block_instance144.11mdl_block_pinned154.12mdl_block_rss_client154.13mdl_blog_tag_instance154.14mdl_cache_filters164.15mdl_cache_text164.16mdl_capabilities164.17mdl_chat164.18mdl_chat_messages174.19mdl_chat_users174.20mdl_choice174.21mdl_choice_answers184.22mdl_choice_options184.23mdl_config184.24mdl_config_plugins194.25mdl_context194.26mdl_context_rel194.27mdl_course194.28mdl_course_allowed_modules214.29mdl_course_categories214.30mdl_course_display214.31mdl_course_meta214.32mdl_course_modules224.33mdl_course_request224.34mdl_course_sections224.35mdl_data234.36mdl_data_comments234.37mdl_data_content244.38mdl_data_fields244.39mdl_data_ratings254.40mdl_data_records254.41mdl_enrol_authorize254.42mdl_enrol_authorize_refunds264.43mdl_enrol_paypal264.44mdl_event274.45mdl_forum274.46mdl_forum_discussions284.47mdl_forum_posts284.48mdl_forum_queue294.49mdl_forum_ratings294.50mdl_forum_read294.51mdl_forum_subscriptions304.52mdl_forum_track_prefs304.53mdl_glossary304.54mdl_glossary_alias314.55mdl_glossary_categories314.56mdl_glossary_comments314.57mdl_glossary_entries314.58mdl_glossary_entries_categories324.59mdl_glossary_formats324.60mdl_glossary_ratings334.61mdl_grade_category334.62mdl_grade_exceptions334.63mdl_grade_item334.64mdl_grade_letter344.65mdl_grade_preferences344.66mdl_groups344.67mdl_groups_courses_groupings354.68mdl_groups_courses_groups354.69mdl_groups_groupings354.70mdl_groups_groupings_groups364.71mdl_groups_members364.72mdl_hotpot364.73mdl_hotpot_attempts374.74mdl_hotpot_details374.75mdl_hotpot_questions374.76mdl_hotpot_responses384.78mdl_hotpot_strings384.79mdl_journal384.80mdl_journal_entries394.81mdl_label394