【正文】 nt19,010teacherentry教師入口tinyint3,011sourceglossaryid詞匯來源IDbigint19,012usedynalink是否允許自動(dòng)鏈接詞條tinyint3,0113casesensitive區(qū)分大小寫tinyint3,014fullmatch整詞匹配tinyint3,0115approved是否批準(zhǔn)tinyint3,01 mdl_glossary_entries_categories描述：條目分類ID序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02categoryid詞匯分類IDbigint19,03entryid條目IDbigint19,0 mdl_glossary_formats描述：詞匯格式化序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02name格式名稱varchar503popupformatname彈出格式名稱varchar504visible是否可見tinyint3,015showgroup是否顯示組tinyint3,016defaultmode默認(rèn)模式varchar507defaulthook選擇第一次瀏覽詞匯表時(shí)顯示的缺省節(jié)varchar508sortkey排序主鍵varchar509sortorder排序方式varchar50 mdl_glossary_ratings描述：詞匯評(píng)分表序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1id自增量編號(hào)big。這與收款人的推薦號(hào)相同varchar2555item_name項(xiàng)目名稱varchar2556courseid課程IDbigint19,07userid用戶IDbigint19,08memo備忘varchar2559tax對(duì)付款收取的稅費(fèi)金額varchar25510option_name1選項(xiàng)1名稱（由您申請(qǐng)）varchar25511option_selection1_x選項(xiàng)1選擇（由客戶輸入varchar25512option_name2選項(xiàng)2名稱（由您申請(qǐng)varchar25513option_selection2_x選項(xiàng)2選擇（由客戶輸入varchar25514payment_status支付狀態(tài)，詳細(xì)看paypal資料varchar25515pending_reason只有在payment_status=Pending時(shí)，才會(huì)設(shè)置此變量varchar25516reason_code撤銷原因varchar3017txn_idPayPal系統(tǒng)生成的唯一交易號(hào)。各子系統(tǒng)數(shù)據(jù)字典說明如下所述。數(shù)據(jù)字典定義了本系統(tǒng)操作的所有數(shù)據(jù)庫(kù)以及各數(shù)據(jù)庫(kù)中的表、字段等。 其他說明數(shù)據(jù)庫(kù)操作工具使用sqlyogent，其主畫面如下：3. 結(jié)構(gòu)設(shè)計(jì) 本數(shù)據(jù)庫(kù)為獨(dú)立數(shù)據(jù)庫(kù)結(jié)構(gòu)，未升級(jí)進(jìn)行服務(wù)器及數(shù)據(jù)集群配置。 數(shù)據(jù)庫(kù)的命名規(guī)則1．?dāng)?shù)據(jù)庫(kù)表名以t開頭加_加上具體實(shí)體名，如果有實(shí)體操作分類，即mdl_實(shí)體名_類型，例如mdl_project _stat，表示此表是基于project的基礎(chǔ)上統(tǒng)計(jì)表。數(shù)據(jù)庫(kù)有表和序列構(gòu)成。本文的讀者是MOODLE平臺(tái)增補(bǔ)系統(tǒng)的系統(tǒng)設(shè)計(jì)人員、開發(fā)人員和客戶。本文包括了MOODLE儲(chǔ)備管理系統(tǒng)的數(shù)據(jù)結(jié)構(gòu)設(shè)計(jì)和數(shù)據(jù)字典設(shè)計(jì)，重點(diǎn)是描述清楚每個(gè)使用的實(shí)體數(shù)據(jù)項(xiàng)。本文檔著重描述MOODLE平臺(tái)增補(bǔ)系統(tǒng)的數(shù)據(jù)庫(kù)系統(tǒng)設(shè)計(jì)，旨在描述符合系統(tǒng)業(yè)務(wù)需求數(shù)據(jù)庫(kù)系統(tǒng)設(shè)計(jì)。. . . . .MOODLE數(shù)據(jù)庫(kù)設(shè)計(jì)說明書編寫： 白斌 審核： 批準(zhǔn)： 修 改 說 明版 本 號(hào)起 止 日 期摘 要作 者目 錄1．引言 7 7 7 7 82．?dāng)?shù)據(jù)庫(kù)設(shè)計(jì)說明 8 數(shù)據(jù)庫(kù)環(huán)境說明 8 數(shù)據(jù)庫(kù)的命名規(guī)則 8 其他說明 83. 結(jié)構(gòu)設(shè)計(jì) 10 10 11 114. 運(yùn)用設(shè)計(jì) 11 adodb_logsql 11 mdl_assignment 11 mdl_assignmenmdl_submissions 12 mdl_backup_config 13 mdl_backup_courses 13 mdl_backup_files 13 mdl_backup_ids 13 mdl_backup_log 14 mdl_block 14 mdl_block_instance 14 mdl_block_pinned 15 mdl_block_rss_client 15 mdl_blog_tag_instance 15 mdl_cache_filters 16 mdl_cache_text 16 mdl_capabilities 16 mdl_chat 16 mdl_chat_messages 17 mdl_chat_users 17 mdl_choice 17 mdl_choice_answers 18 mdl_choice_options 18 mdl_config 18 mdl_config_plugins 19 mdl_context 19 mdl_context_rel 19 mdl_course 19 mdl_course_allowed_modules 21 mdl_course_categories 21 mdl_course_display 21 mdl_course_meta 21 mdl_course_modules 22 mdl_course_request 22 mdl_course_sections 22 mdl_data 23 mdl_data_ments 23 mdl_data_content 24 mdl_data_fields 24 mdl_data_ratings 25 mdl_data_records 25 mdl_enrol_authorize 25 mdl_enrol_authorize_refunds 26 mdl_enrol_paypal 26 mdl_event 27 mdl_forum 27 mdl_forum_discussions 28 mdl_forum_posts 28 mdl_forum_queue 29 mdl_forum_ratings 29 mdl_forum_read 29 mdl_forum_subscriptions 30 mdl_forum_track_prefs 30 mdl_glossary 30 mdl_glossary_alias 31 mdl_glossary_categories 31 mdl_glossary_ments 31 mdl_glossary_entries 31 mdl_glossary_entries_categories 32 mdl_glossary_formats 32 mdl_glossary_ratings 33 mdl_grade_category 33 mdl_grade_exceptions 33 mdl_grade_item 33 mdl_grade_letter 34 mdl_grade_preferences 34 mdl_groups 34 mdl_groups_courses_groupings 35 mdl_groups_courses_groups 35 mdl_groups_groupings 35 mdl_groups_groupings_groups 36 mdl_groups_members 36 mdl_hotpot 36 mdl_hotpot_attempts 37 mdl_hotpot_details 37 mdl_hotpot_questions 37 mdl_hotpot_responses 38 mdl_hotpot_strings 38 mdl_journal 38 mdl_journal_entries 39 mdl_label 39 mdl_lams 39 mdl_lesson 40 mdl_lesson_answers 41 mdl_lesson_attempts 41 mdl_lesson_branch 41 mdl_lesson_default 42 mdl_lesson_grades 43 mdl_lesson_high_scores 43 mdl_lesson_pages 43 mdl_lesson_timer 44 mdl_log 44 mdl_log_display 44 mdl_message 45 mdl_message_contacts 45 mdl_message_read 45 mdl_mnet_enrol_assignments 45 mdl_mnet_enrol_course 46 mdl_mnet_host 46 mdl_mnet_host2service 47 mdl_mnet_log 47 mdl_mnet_rpc 47 mdl_mnet_service 48 mdl_mnet_service2rpc 48 mdl_mnet_session 48 mdl_mnet_sso_access_control 49 mdl_modules 49 mdl_post 49 mdl_question 50 mdl_question_answers 50 mdl_question_attempts 51 mdl_question_calculated 51 mdl_question_categories 51 mdl_question_datasets 51 mdl_question_dataset_definitions 52 mdl_question_dataset_items 52 mdl_question_match 52 mdl_question_match_sub 52 mdl_question_multianswer 53 mdl_question_multichoice 53 mdl_question_numerical 53 mdl_question_numerical_units 53 mdl_question_randomsamatch 54 mdl_question_rqp 54 mdl_question_rqp_servers 54 mdl_question_rqp_states 55 mdl_question_rqp_types 55 mdl_question_sessions 55 mdl_question_shortanswer 55 mdl_question_states 56 mdl_question_truefalse 56 mdl_quiz 56 mdl_quiz_attempts 57 mdl_quiz_feedback 57 mdl_quiz_grades 58 mdl_quiz_question_instances 58 mdl_quiz_question_versions 58 mdl_resource 58 mdl_role 59 mdl_role_allow_assign 59 mdl_role_allow_override 59 mdl_role_assignments 60 mdl_role_capabilities 60 mdl_role_names 60 mdl_scale 61 mdl_scorm 61 mdl_scorm_scoes 62 mdl_scorm_scoes_data 62 mdl_scorm_scoes_track 62 mdl_scorm_seq_mapinfo 63 mdl_scorm_seq_objective 63 mdl_scorm_seq_rolluprule 63 mdl_scorm_seq