moodle系統(tǒng)數(shù)據(jù)庫(kù)設(shè)計(jì)說(shuō)明書(shū)(編輯修改稿)
2025-06-13 12:09 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 gint19,04groupid群組IDbigint19,05version版本varchar166ipIP地址varchar157firstping第一次發(fā)送的IP地址bigint19,08lastping最后一次發(fā)送的IP地址bigint19,09lastmessageping最后一次發(fā)送信息的IP地址bigint19,010sid發(fā)送varchar3211course課程IDbigint19,012lang語(yǔ)言類型varchar30 mdl_choice描述：投票信息表序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02course課程IDbigint19,03name投票名稱varchar2554text詳細(xì)內(nèi)容text655355format是否格式化tinyint3,06publish公布結(jié)果tinyint3,07showresults是否顯示結(jié)果tinyint3,08display是否顯示smallint5,09allowupdate是否允許修改投票tinyint3,010showunanswered是否顯示未回答的選項(xiàng)tinyint3,011limitanswers是否限制回答tinyint3,012timeopen打開(kāi)投票時(shí)間bigint19,013timeclose關(guān)閉時(shí)間bigint19,014timemodified編輯時(shí)間bigint19,0 mdl_choice_answers描述：投票回答記錄表序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02choiceid投票IDbigint19,03userid用戶IDbigint19,04optionid選項(xiàng)IDbigint19,05timemodified編輯時(shí)間bigint19,0 mdl_choice_options描述：投票選項(xiàng)表序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02choiceid投票IDbigint19,03text投票內(nèi)容說(shuō)明text655354maxanswers課程的最大問(wèn)題數(shù)bigint19,05timemodified編輯時(shí)間bigint19,0 mdl_config描述：配置表序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idIDbigint19,02name參數(shù)名稱varchar2553value值text65535 mdl_config_plugins描述：插件配置表序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idIDbigint19,02plugin插件名稱varchar100core3name參數(shù)名稱varchar1004value值text65535 mdl_context描述：正文級(jí)別與事例對(duì)應(yīng)表序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02contextlevel指明是哪一種：用戶，課程，模塊，還是系統(tǒng)......，bigint19,0否03instanceid事件IDbigint19,0否04path路徑varchar2555depth深度tinyint2否0 mdl_context_rel描述：權(quán)限關(guān)系表序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02c1正文ID1bigint19,0否3c2正文ID2bigint19,0否 mdl_course描述：課程設(shè)置序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1id課程IDbigint19,02category課程分類IDbigint19,03sortorder排序編號(hào)bigint19,04password選課密碼varchar505fullname課程名全稱varchar2546shortname課程名簡(jiǎn)稱varchar1007idnumber課程編碼IDvarchar1008summary課程概要text655359format課程格式varchar10topics10showgrades是否顯示成績(jī)tinyint3,0111modinfo課程頁(yè)顯示的相關(guān)功能模塊代碼信息longtext429496729512newsitems顯示的新聞條目數(shù)mediumint7,0113teacher指定編輯權(quán)限教師varchar100Teacher14teachers無(wú)編輯權(quán)限教師varchar100Teachers15student指定編輯權(quán)限學(xué)生varchar100Student16students無(wú)編輯權(quán)限學(xué)生varchar100Students17guest是否允許訪客進(jìn)入課程tinyint3,018startdate課程開(kāi)始時(shí)間bigint19,019enrolperiod選課時(shí)間限制天數(shù)bigint19,020numsections星期/主題的數(shù)目mediumint7,0121marker課程標(biāo)記bigint19,022maxbytes最大上傳文件bigint19,023showreports是否顯示活動(dòng)報(bào)表smallint5,024visible課程有效性，是否允許學(xué)生學(xué)習(xí)tinyint3,0125hiddensections隱藏的課程內(nèi)容模塊的方式tinyint3,026groupmode小組模式smallint5,027groupmodeforce強(qiáng)制小組模式smallint5,028lang指定課程語(yǔ)言類型varchar3029theme主題varchar5030cost課程費(fèi)用varchar1031currency費(fèi)用貨幣單位varchar3USD32timecreated課程創(chuàng)建時(shí)間bigint19,033timemodified課程修改時(shí)間bigint19,034metacourse該課程是元課程么tinyint3,035requested申請(qǐng)tinyint3,036restrictmodules是否限制模塊tinyint3,037expirynotify選課期滿通告,是否啟用通告tinyint3,038expirythreshold課程到期后期限bigint19,039notifystudents選課期滿通告,是否提醒學(xué)生tinyint3,040enrollable課程是否可以被選修tinyint3,0141enrolstartdate選課開(kāi)始時(shí)間bigint19,042enrolenddate選課結(jié)束時(shí)間bigint19,043enrol選課設(shè)置選課插件varchar2044defaultrole選課設(shè)置默認(rèn)角色bigint19,0 mdl_course_allowed_modules描述：課程允許的模塊序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idIDbigint19,02course課程IDbigint19,03module模塊IDbigint19,0 mdl_course_categories描述：課程分類序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1id分類IDbigint19,02name類別名稱varchar2553description類別描述text655354parent父類別bigint19,05sortorder排序編號(hào)bigint19,06coursecount此類別里的課程數(shù)bigint19,07visible是否可見(jiàn)tinyint3,018timemodified編輯時(shí)間bigint19,09depth分類深度，即幾級(jí)分類bigint19,010path分類路徑varchar255 mdl_course_display描述：課程顯示關(guān)系表序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02course課程IDbigint19,03userid用戶IDbigint19,04display是否顯示bigint19,0 mdl_course_meta描述：課程關(guān)系表序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02Parent_course上一級(jí)課程bigint19,03child_course子課程bigint19,0 mdl_course_modules描述：課程模塊序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idIDbigint19,02course課程IDbigint19,03module模塊IDbigint19,04instance此模塊的第幾個(gè)例子的IDbigint19,05section章節(jié)IDbigint19,06added添加時(shí)間bigint19,07score成績(jī)分?jǐn)?shù)smallint5,08indent縮進(jìn)mediumint7,09visible是否可見(jiàn)tinyint3,0110visibleoldtinyint3,0111groupmode小組模式smallint5,0 mdl_course_request描述：課程請(qǐng)求表序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02fullname完整名字varchar2543shortname短名字varchar154summary摘要text655355reason原因text655356requester申請(qǐng)者bigint19,07password密碼varchar50 mdl_course
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1