Moodle系統(tǒng)數(shù)據(jù)庫設(shè)計項目說明書

Moodle系統(tǒng)數(shù)據(jù)庫設(shè)計項目說明書DOCPROPERTY內(nèi)容MOODLE數(shù)據(jù)庫設(shè)計說明書編寫：白斌審核：批準(zhǔn)：修改說明版本號起止日期摘要作者目錄1．引言 7 7 7 7 82．?dāng)?shù)據(jù)庫設(shè)計說明 8數(shù)據(jù)庫環(huán)境說明 8數(shù)據(jù)庫的命名規(guī)則 8其他說明 83.結(jié)構(gòu)設(shè)計 10 10 11 114.運(yùn)用設(shè)計 11adodb_logsql 11mdl_assignment 11mdl_assignmenmdl_submissions 12mdl_backup_config 13mdl_backup_courses 13mdl_backup_files 13mdl_backup_ids 13mdl_backup_log 14mdl_block 14mdl_block_instance 14mdl_block_pinned 15mdl_block_rss_client 15mdl_blog_tag_instance 15mdl_cache_filters 16mdl_cache_text 16mdl_capabilities 16mdl_chat 16mdl_chat_messages 17mdl_chat_users 17mdl_choice 17mdl_choice_answers 18mdl_choice_options 18mdl_config 18mdl_config_plugins 19mdl_context 19mdl_context_rel 19mdl_course 19mdl_course_allowed_modules 21mdl_course_categories 21mdl_course_display 21mdl_course_meta 21mdl_course_modules 22mdl_course_request 22mdl_course_sections 22mdl_data 23mdl_data_comments 23mdl_data_content 24mdl_data_fields 24mdl_data_ratings 25mdl_data_records 25mdl_enrol_authorize 25mdl_enrol_authorize_refunds 26mdl_enrol_paypal 26mdl_event 27mdl_forum 27mdl_forum_discussions 28mdl_forum_posts 28mdl_forum_queue 29mdl_forum_ratings 29mdl_forum_read 29mdl_forum_subscriptions 30mdl_forum_track_prefs 30mdl_glossary 30mdl_glossary_alias 31mdl_glossary_categories 31mdl_glossary_comments 31mdl_glossary_entries 31mdl_glossary_entries_categories 32mdl_glossary_formats 32mdl_glossary_ratings 33mdl_grade_category 33mdl_grade_exceptions 33mdl_grade_item 33mdl_grade_letter 34mdl_grade_preferences 34mdl_groups 34mdl_groups_courses_groupings 35mdl_groups_courses_groups 35mdl_groups_groupings 35mdl_groups_groupings_groups 36mdl_groups_members 36mdl_hotpot 36mdl_hotpot_attempts 37mdl_hotpot_details 37mdl_hotpot_questions 37mdl_hotpot_responses 38mdl_hotpot_strings 38mdl_journal 38mdl_journal_entries 39mdl_label 39mdl_lams 39mdl_lesson 40mdl_lesson_answers 41mdl_lesson_attempts 41mdl_lesson_branch 41mdl_lesson_default 42mdl_lesson_grades 43mdl_lesson_high_scores 43mdl_lesson_pages 43mdl_lesson_timer 44mdl_log 44mdl_log_display 44mdl_message 45mdl_message_contacts 45mdl_message_read 45mdl_mnet_enrol_assignments 45mdl_mnet_enrol_course 46mdl_mnet_host 46mdl_mnet_host2service 47mdl_mnet_log 47mdl_mnet_rpc 47mdl_mnet_service 48mdl_mnet_service2rpc 48mdl_mnet_session 48mdl_mnet_sso_access_control 49mdl_modules 49mdl_post 49mdl_question 50mdl_question_answers 50mdl_question_attempts 51mdl_question_calculated 51mdl_question_categories 51mdl_question_datasets 51mdl_question_dataset_definitions 52mdl_question_dataset_items 52mdl_question_match 52mdl_question_match_sub 52mdl_question_multianswer 53mdl_question_multichoice 53mdl_question_numerical 53mdl_question_numerical_units 53mdl_question_randomsamatch 54mdl_question_rqp 54mdl_question_rqp_servers 54mdl_question_rqp_states 55mdl_question_rqp_types 55mdl_question_sessions 55mdl_question_shortanswer 55mdl_question_states 56mdl_question_truefalse 56mdl_quiz 56mdl_quiz_attempts 57mdl_quiz_feedback 57mdl_quiz_grades 58mdl_quiz_question_instances 58mdl_quiz_question_versions 58mdl_resource 58mdl_role 59mdl_role_allow_assign 59mdl_role_allow_override 59mdl_role_assignments 60mdl_role_capabilities 60mdl_role_names 60mdl_scale 61mdl_scorm 61mdl_scorm_scoes 62mdl_scorm_scoes_data 62mdl_scorm_scoes_track 62mdl_scorm_seq_mapinfo 63mdl_scorm_seq_objective 63mdl_scorm_seq_rolluprule 63mdl_scorm_seq_rolluprulecond 64mdl_scorm_seq_rulecond 64mdl_scorm_seq_ruleconds 64mdl_sessions2 64mdl_stats_daily 65mdl_stats_monthly 65mdl_stats_user_daily 65mdl_stats_user_monthly 66mdl_stats_user_weekly 66mdl_stats_weekly 66mdl_survey 67mdl_survey_analysis 67mdl_survey_answers 67mdl_survey_questions 68mdl_tags 68mdl_timezone 68mdl_user 69mdl_user_info_category 70mdl_user_info_data 70mdl_user_info_field 70mdl_user_lastaccess 71mdl_user_preferences 71mdl_wiki 71mdl_wiki_entries 72mdl_wiki_locks 72mdl_wiki_pages 72mdl_workshop 73mdl_workshop_assessments 74mdl_workshop_comments 74mdl_workshop_elements 75mdl_workshop_grades 75mdl_workshop_rubrics 75mdl_workshop_stockcomments 75mdl_workshop_submissions 765.安全保密設(shè)計 766.優(yōu)化 767.數(shù)據(jù)庫管理與維護(hù)說明 76控制文件的備份 77檢查數(shù)據(jù)庫文件的狀態(tài) 771．引言數(shù)據(jù)庫設(shè)計是軟件系統(tǒng)設(shè)計極為重要的一部分。數(shù)據(jù)模型設(shè)計和數(shù)據(jù)結(jié)構(gòu)設(shè)計是軟件開發(fā)的基礎(chǔ)。本文檔著重描述MOODLE平臺增補(bǔ)系統(tǒng)的數(shù)據(jù)庫系統(tǒng)設(shè)計，旨在描述符合系統(tǒng)業(yè)務(wù)需求數(shù)據(jù)庫系統(tǒng)設(shè)計。系統(tǒng)設(shè)計人員、開發(fā)人員和客戶通過閱讀本文了解MOODLE平臺增補(bǔ)系統(tǒng)的數(shù)據(jù)關(guān)系、數(shù)據(jù)字典和數(shù)據(jù)庫對象(表、視圖、存儲過程等)。本文包括了MOODLE儲備管理系統(tǒng)的數(shù)據(jù)結(jié)構(gòu)設(shè)計和數(shù)據(jù)字典設(shè)計，重點是描述清楚每個使用的實體數(shù)據(jù)項。詳細(xì)規(guī)定數(shù)據(jù)項的使用屬性。本文的讀者是MOODLE平臺增補(bǔ)系統(tǒng)的系統(tǒng)設(shè)計人員、開發(fā)人員和客戶。參考文獻(xiàn)無縮寫、術(shù)語解釋2．?dāng)?shù)據(jù)庫設(shè)計說明數(shù)據(jù)庫環(huán)境說明。數(shù)據(jù)庫有表和序列構(gòu)成。表存儲了應(yīng)用系統(tǒng)中的數(shù)據(jù)，序列用于生成表中行的唯一記錄編號。數(shù)據(jù)庫的命名規(guī)則1．?dāng)?shù)據(jù)庫表名以t開頭加_加上具體實體名，如果有實體操作分類，即mdl_實體名_類型，例如mdl_project_stat，表示此表是基于project的基礎(chǔ)上統(tǒng)計表。2．?dāng)?shù)據(jù)表命名必須遵循下劃線分割的原則，所有表明以"mdl_"開頭，視圖以"v_"開頭，序列用"sequence_"開頭等。其他說明數(shù)據(jù)庫操作工具使用sqlyogent，其主畫面如下：3.結(jié)構(gòu)設(shè)計本數(shù)據(jù)庫為獨立數(shù)據(jù)庫結(jié)構(gòu)，未升級進(jìn)行服務(wù)器及數(shù)據(jù)集群配置。4.運(yùn)用設(shè)計 為了更好地對數(shù)據(jù)進(jìn)行查詢統(tǒng)計，使用戶可以將新的字段或數(shù)據(jù)表加進(jìn)系統(tǒng)中，并及時的收集、整理數(shù)據(jù)，本系統(tǒng)建立了數(shù)據(jù)字典，用來對數(shù)據(jù)進(jìn)行管理。數(shù)據(jù)字典定義了本系統(tǒng)操作的所有數(shù)據(jù)庫以及各數(shù)據(jù)庫中的表、字段等。系統(tǒng)管理程序完成數(shù)據(jù)字典的維護(hù)功能。各子系統(tǒng)數(shù)據(jù)字典說明如下所述。adodb_logsql描述：sql執(zhí)行記錄表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02created創(chuàng)建時間datetime3sql0SQL語句varchar2504sql1執(zhí)行內(nèi)容text655355params參數(shù)text655356tracer執(zhí)行記錄text655357timer執(zhí)行時間decimal16,60.000000mdl_assignment描述：作業(yè)資料表序號字段名稱字段描述字段類型長度允許空缺省值1idIDbigint19,02course課程IDbigint19,03name作業(yè)名稱varchar2554description作業(yè)描述text655355format格式smallint5,06assignmenttype作業(yè)類型varchar507resubmit是否允許學(xué)生刪除作業(yè)tinyint3,08preventlate是否禁止遲交tinyint3,09emailteachers是否使用E-mail提醒教師tinyint3,010var1允許上傳文件的最大數(shù)目bigint19,011var2是否允許備注bigint19,012var3在作業(yè)開始提交前隱藏作業(yè)說明bigint19,013var4是否發(fā)送評分請求bigint19,014var5bigint19,015maxbytes上傳文件大小限制bigint19,010000016timedue截止時間bigint19,017timeavailable開始時間bigint19,018grade成績bigint19,019timemodified修改時間bigint19,0mdl_assignmenmdl_submissions描述：提交的作業(yè)序號字段名稱字段描述字段類型長度允許空缺省值1idIDbigint19,02assignment作業(yè)IDbigint19,03userid用戶IDbigint19,04timecreated作業(yè)創(chuàng)建時間bigint19,05timemodified作業(yè)提交時間bigint19,06numfiles上傳文件個數(shù)，0好像是允許多個bigint19,07data1作業(yè)信息text655358data2作業(yè)是否提交的相關(guān)信息text655359grade成績bigint19,010submissioncomment作業(yè)評論text6553511format格式smallint5,012teacher老師IDbigint19,013timemarked打分時間bigint19,014mailed是否發(fā)送E-mail通知作業(yè)回復(fù)情況tinyint3,0mdl_backup_config描述：配置備份表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02name備份名稱varchar2553value備份值varchar255mdl_backup_courses描述：課程備份表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02courseid課程IDbigint19,03laststarttime最近開始時間bigint19,04lastendtime最后結(jié)束時間bigint19,05laststatus最后的狀態(tài)varchar16nextstarttime下一個開始時間bigint19,0mdl_backup_files描述：文件備份表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02backup_code備份代碼bigint19,03file_type文件類型varchar104path備份路徑varchar2555old_id原文件IDbigint19,06new_id新的文件IDbigint19,0mdl_backup_ids描述：標(biāo)識備份表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02backup_code備份代碼bigint19,03table_name表名varchar304old_id原IDbigint19,05new_id新的IDbigint19,06info備份信息mediumtext16777215mdl_backup_log描述：日志備份表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02courseid課程IDbigint19,03time創(chuàng)建時間bigint19,04laststarttime最后開始時間bigint19,05info備份信息說明varchar255mdl_block描述：版塊表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02name動作名稱varchar403version版本bigint19,04cron是否計劃任務(wù)bigint19,05lastcron最近一次執(zhí)行bigint19,06visible是否可見tinyint3,017multiple多個tinyint3,0mdl_block_instance描述：版塊實例表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02blockid動作IDbigint19,03pageid頁面IDbigint19,04pagetype頁碼類型varchar205position定位varchar106weight加權(quán)smallint5,07visible是否可見tinyint3,08configdata配置數(shù)據(jù)內(nèi)容text65535mdl_block_pinned描述：固定版塊表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02blockid動作IDbigint19,03pagetype頁碼類型varchar204position位置varchar105weight加權(quán)smallint5,06visible是否可見tinyint3,07configdata配置數(shù)據(jù)text65535mdl_block_rss_client描述：版塊RSS客戶端表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02userid用戶IDbigint19,03title標(biāo)題text655354preferredtitle首先標(biāo)題varchar645description描述text655356shared是否分享tinyint3,07url分享地址varchar255mdl_blog_tag_instance描述：版塊標(biāo)簽實例表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02entryid條目IDbigint19,03tagid標(biāo)簽IDbigint19,04groupid群組IDbigint19,05courseid課程IDbigint19,06userid用戶IDbigint19,07timemodified編輯時間bigint19,0mdl_cache_filters描述：緩存過濾表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02filter過濾器名varchar323version版本bigint19,04md5keyMD5加密密鑰varchar325rawtext原內(nèi)容text655356timemodified編輯時間bigint19,0mdl_cache_text描述：緩存文本表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02md5keyMD5加密密鑰varchar323formattedtext格式化后的內(nèi)容longtext42949672954timemodified編輯時間bigint19,0mdl_capabilities描述：能力表 序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02name名稱varchar2553captype能力類型varchar504contextlevel權(quán)限級別bigint19,05component組件varchar1006riskbitmaskbigint19,0mdl_chat描述：聊天室序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02course課程IDbigint19,03name聊天室名varchar2554intro簡介text655355keepdays保持天數(shù)bigint19,06studentlogs每個人都可以查看過去的會話smallint5,07chattime聊天時間bigint19,08schedule附表smallint5,09timemodified編輯時間bigint19,0mdl_chat_messages描述：聊天信息表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02chatid聊天對話IDbigint19,03userid用戶IDbigint19,04groupid群組IDbigint19,05system系統(tǒng)標(biāo)志位tinyint3,06message信息內(nèi)容text655357timestamp編輯時間bigint19,0mdl_chat_users描述：聊天用戶表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02chatid聊天對話IDbigint19,03userid用戶IDbigint19,04groupid群組IDbigint19,05version版本varchar166ipIP地址varchar157firstping第一次發(fā)送的IP地址bigint19,08lastping最后一次發(fā)送的IP地址bigint19,09lastmessageping最后一次發(fā)送信息的IP地址bigint19,010sid發(fā)送varchar3211course課程IDbigint19,012lang語言類型varchar30mdl_choice描述：投票信息表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02course課程IDbigint19,03name投票名稱varchar2554text詳細(xì)內(nèi)容text655355format是否格式化tinyint3,06publish公布結(jié)果tinyint3,07showresults是否顯示結(jié)果tinyint3,08display是否顯示smallint5,09allowupdate是否允許修改投票tinyint3,010showunanswered是否顯示未回答的選項tinyint3,011limitanswers是否限制回答tinyint3,012timeopen打開投票時間bigint19,013timeclose關(guān)閉時間bigint19,014timemodified編輯時間bigint19,0mdl_choice_answers描述：投票回答記錄表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02choiceid投票IDbigint19,03userid用戶IDbigint19,04optionid選項IDbigint19,05timemodified編輯時間bigint19,0mdl_choice_options描述：投票選項表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02choiceid投票IDbigint19,03text投票內(nèi)容說明text655354maxanswers課程的最大問題數(shù)bigint19,05timemodified編輯時間bigint19,0mdl_config描述：配置表序號字段名稱字段描述字段類型長度允許空缺省值1idIDbigint19,02name參數(shù)名稱varchar2553value值text65535mdl_config_plugins描述：插件配置表序號字段名稱字段描述字段類型長度允許空缺省值1idIDbigint19,02plugin插件名稱varchar100core3name參數(shù)名稱varchar1004value值text65535mdl_context描述：正文級別與事例對應(yīng)表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02contextlevel指明是哪一種：用戶，課程，模塊，還是系統(tǒng)，bigint19,0否03instanceid事件IDbigint19,0否04path路徑varchar2555depth深度tinyint2否0mdl_context_rel描述：權(quán)限關(guān)系表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02c1正文ID1bigint19,0否3c2正文ID2bigint19,0否mdl_course描述：課程設(shè)置序號字段名稱字段描述字段類型長度允許空缺省值1id課程IDbigint19,02category課程分類IDbigint19,03sortorder排序編號bigint19,04password選課密碼varchar505fullname課程名全稱varchar2546shortname課程名簡稱varchar1007idnumber課程編碼IDvarchar1008summary課程概要text655359format課程格式varchar10topics10showgrades是否顯示成績tinyint3,0111modinfo課程頁顯示的相關(guān)功能模塊代碼信息longtext429496729512newsitems顯示的新聞條目數(shù)mediumint7,0113teacher指定編輯權(quán)限教師varchar100Teacher14teachers無編輯權(quán)限教師varchar100Teachers15student指定編輯權(quán)限學(xué)生varchar100Student16students無編輯權(quán)限學(xué)生varchar100Students17guest是否允許訪客進(jìn)入課程tinyint3,018startdate課程開始時間bigint19,019enrolperiod選課時間限制天數(shù)bigint19,020numsections星期/主題的數(shù)目mediumint7,0121marker課程標(biāo)記bigint19,022maxbytes最大上傳文件bigint19,023showreports是否顯示活動報表smallint5,024visible課程有效性，是否允許學(xué)生學(xué)習(xí)tinyint3,0125hiddensections隱藏的課程內(nèi)容模塊的方式tinyint3,026groupmode小組模式smallint5,027groupmodeforce強(qiáng)制小組模式smallint5,028lang指定課程語言類型varchar3029theme主題varchar5030cost課程費用varchar1031currency費用貨幣單位varchar3USD32timecreated課程創(chuàng)建時間bigint19,033timemodified課程修改時間bigint19,034metacourse該課程是元課程么tinyint3,035requested申請tinyint3,036restrictmodules是否限制模塊tinyint3,037expirynotify選課期滿通告,是否啟用通告tinyint3,038expirythreshold課程到期后期限bigint19,039notifystudents選課期滿通告,是否提醒學(xué)生tinyint3,040enrollable課程是否可以被選修tinyint3,0141enrolstartdate選課開始時間bigint19,042enrolenddate選課結(jié)束時間bigint19,043enrol選課設(shè)置選課插件varchar2044defaultrole選課設(shè)置默認(rèn)角色bigint19,0mdl_course_allowed_modules描述：課程允許的模塊序號字段名稱字段描述字段類型長度允許空缺省值1idIDbigint19,02course課程IDbigint19,03module模塊IDbigint19,0mdl_course_categories描述：課程分類序號字段名稱字段描述字段類型長度允許空缺省值1id分類IDbigint19,02name類別名稱varchar2553description類別描述text655354parent父類別bigint19,05sortorder排序編號bigint19,06coursecount此類別里的課程數(shù)bigint19,07visible是否可見tinyint3,018timemodified編輯時間bigint19,09depth分類深度，即幾級分類bigint19,010path分類路徑varchar255mdl_course_display描述：課程顯示關(guān)系表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02course課程IDbigint19,03userid用戶IDbigint19,04display是否顯示bigint19,0mdl_course_meta描述：課程關(guān)系表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02Parent_course上一級課程bigint19,03child_course子課程bigint19,0mdl_course_modules描述：課程模塊序號字段名稱字段描述字段類型長度允許空缺省值1idIDbigint19,02course課程IDbigint19,03module模塊IDbigint19,04instance此模塊的第幾個例子的IDbigint19,05section章節(jié)IDbigint19,06added添加時間bigint19,07score成績分?jǐn)?shù)smallint5,08indent縮進(jìn)mediumint7,09visible是否可見tinyint3,0110visibleoldtinyint3,0111groupmode小組模式smallint5,0mdl_course_request描述：課程請求表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02fullname完整名字varchar2543shortname短名字varchar154summary摘要text655355reason原因text655356requester申請者bigint19,07password密碼varchar50mdl_course_sections描述：課程章節(jié)序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02course課程IDbigint19,03section章節(jié)IDbigint19,04summary章節(jié)描述text655355sequence章節(jié)里資源活動的排序text655356visible章節(jié)是否可見tinyint3,01mdl_data描述：MOODLE數(shù)據(jù)配置表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02course課程IDbigint19,03name名稱varchar2554intro簡介text655355comments是否開通評論smallint5,06timeavailablefrom從什么時間開始bigint19,07timeavailableto到什么時間bigint19,08timeviewfrom查看開始時間bigint19,09timeviewto查看到什么時間bigint19,010requiredentries所需條目int10,011requiredentriestoview所需查閱的條目int10,012maxentries最大條目int10,013rssarticlesRSS文章條目smallint5,014singletemplate單模板text6553515listtemplate列表模板text6553516listtemplateheader列表模板頭部text6553517listtemplatefooter列表模板底部text6553518addtemplate增加模板text6553519rsstemplateRss模板text6553520rsstitletemplateRss標(biāo)題模板text6553521csstemplateCss模板text6553522jstemplateJs模板text6553523approval批準(zhǔn)標(biāo)志smallint5,024scale規(guī)模bigint19,025assessed評估bigint19,026defaultsort默認(rèn)排序bigint19,027defaultsortdir默認(rèn)排序目錄smallint5,028editany編輯任何smallint5,0mdl_data_comments描述：數(shù)據(jù)評論表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02userid用戶IDbigint19,03recordid記錄IDbigint19,04content內(nèi)容text655355format格式化標(biāo)志tinyint3,06created創(chuàng)建者bigint19,07modified編輯者bigint19,0mdl_data_content描述：數(shù)據(jù)內(nèi)容表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02fieldid字段IDbigint19,03recordid記錄IDbigint19,04content內(nèi)容0longtext42949672955content1內(nèi)容1longtext42949672956content2內(nèi)容2longtext42949672957content3內(nèi)容3longtext42949672958content4內(nèi)容4longtext4294967295mdl_data_fields描述：數(shù)據(jù)字段表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02dataid數(shù)據(jù)ID，data表bigint19,03type字段類型varchar2554name字段名稱varchar2555description字段描述text655356param1參數(shù)1text655357param2參數(shù)2text655358param3參數(shù)3text655359param4參數(shù)4text6553510param5參數(shù)5text6553511param6參數(shù)6text6553512param7參數(shù)7text6553513param8參數(shù)8text6553514param9參數(shù)9text6553515param10參數(shù)10text65535mdl_data_ratings描述：數(shù)據(jù)評分表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02userid用戶IDbigint19,03recordid記錄IDbigint19,04rating等級/成績bigint19,0mdl_data_records描述：數(shù)據(jù)記錄表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02userid用戶IDbigint19,03groupid分組IDbigint19,04dataid數(shù)據(jù)IDbigint19,05timecreated創(chuàng)建時間bigint19,06timemodified編輯時間bigint19,07approved批準(zhǔn)標(biāo)志smallint5,0mdl_enrol_authorize描述：登記授權(quán)表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02paymentmethod支付方式enum6cc3refundinfo退款信息smallint5,04ccname抄送名稱varchar2555courseid課程IDbigint19,06userid用戶IDbigint19,07transid傳輸ID值bigint19,08status狀態(tài)bigint19,09timecreated創(chuàng)建時間bigint19,010settletime停留時間bigint19,011amount金額varchar1012currency貨幣類型varchar3USDmdl_enrol_authorize_refunds描述：退款表序號字段名稱字段描述字段類型長度允許空缺省值1id自增量編號bigint19,02orderid訂單IDbigint19,03status狀態(tài)tinyint3,04amount金額varchar105transid傳輸IDbigint19,06settletime停留時間bigint19,0mdl_enrol_paypal描述：貝寶支