moodle系统数据库设计说明书

《moodle系统数据库设计说明书》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、数据库表结构说明文档MOODLE数据库设计说明书编写：白斌审核：批准：修改说明版本号起止日期摘要作者第77页共77页数据库表结构说明文档目录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_sub

2、missions124.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.1

3、5mdl_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_course1

4、9第77页共77页数据库表结构说明文档4.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_content

5、244.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

6、_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_categories32

7、4.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

8、.69mdl_groups_groupings354.70mdl_groups_groupings_groups364.71mdl_groups_members36第77页共77页数据库表结构说明文档4.72mdl_hotpot364.73mdl_hotpot_attempts374.74mdl_hotpot_details374.75mdl_hotpot_questions374.76mdl_hotpot_responses384.78mdl_hotp