moodle系統(tǒng)數(shù)據(jù)庫(kù)設(shè)計(jì)說(shuō)明書(shū)-免費(fèi)閱讀
【正文】 adodb_logsql描述：sql執(zhí)行記錄表序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02created創(chuàng)建時(shí)間datetime3sql0SQL語(yǔ)句varchar2504sql1執(zhí)行內(nèi)容text655355params參數(shù)text655356tracer執(zhí)行記錄text655357timer執(zhí)行時(shí)間decimal16,6 mdl_assignment描述：作業(yè)資料表序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1idIDbigint19,02course課程IDbigint19,03name作業(yè)名稱(chēng)varchar2554description作業(yè)描述text655355format格式smallint5,06assignmenttype作業(yè)類(lèi)型varchar507resubmit是否允許學(xué)生刪除作業(yè)tinyint3,08preventlate是否禁止遲交tinyint3,09teachers是否使用 Email 提醒教師tinyint3,010var1允許上傳文件的最大數(shù)目bigint19,011var2是否允許備注bigint19,012var3在作業(yè)開(kāi)始提交前隱藏作業(yè)說(shuō)明bigint19,013var4是否發(fā)送評(píng)分請(qǐng)求bigint19,014var5bigint19,015maxbytes上傳文件大小限制bigint19,010000016timedue截止時(shí)間bigint19,017timeavailable開(kāi)始時(shí)間bigint19,018grade成績(jī)bigint19,019timemodified修改時(shí)間bigint19,0 mdl_assignmenmdl_submissions描述：提交的作業(yè)序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1idIDbigint19,02assignment作業(yè)IDbigint19,03userid用戶IDbigint19,04timecreated作業(yè)創(chuàng)建時(shí)間bigint19,05timemodified作業(yè)提交時(shí)間bigint19,06numfiles上傳文件個(gè)數(shù)，0好像是允許多個(gè)bigint19,07data1作業(yè)信息text655358data2作業(yè)是否提交的相關(guān)信息text655359grade成績(jī)bigint19,010submissionment作業(yè)評(píng)論text6553511format格式smallint5,012teacher老師IDbigint19,013timemarked打分時(shí)間bigint19,014mailed是否發(fā)送 Email 通知作業(yè)回復(fù)情況tinyint3,0 mdl_backup_config描述：配置備份表序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02name備份名稱(chēng)varchar2553value備份值varchar255 mdl_backup_courses描述：課程備份表序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02courseid課程IDbigint19,03laststarttime最近開(kāi)始時(shí)間bigint19,04lastendtime最后結(jié)束時(shí)間bigint19,05laststatus最后的狀態(tài)varchar16nextstarttime下一個(gè)開(kāi)始時(shí)間bigint19,0 mdl_backup_files描述：文件備份表序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02backup_code備份代碼bigint19,03file_type文件類(lèi)型varchar104path備份路徑varchar2555old_id原文件IDbigint19,06new_id新的文件IDbigint19,0 mdl_backup_ids描述：標(biāo)識(shí)備份表序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02backup_code備份代碼bigint19,03table_name表名varchar304old_id原IDbigint19,05new_id新的IDbigint19,06info備份信息mediumtext16777215 mdl_backup_log描述：日志備份表序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02courseid課程IDbigint19,03time創(chuàng)建時(shí)間bigint19,04laststarttime最后開(kāi)始時(shí)間bigint19,05info備份信息說(shuō)明varchar255 mdl_block描述：版塊表序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02name動(dòng)作名稱(chēng)varchar403version版本bigint19,04cron是否計(jì)劃任務(wù)bigint19,05lastcron最近一次執(zhí)行bigint19,06visible是否可見(jiàn)tinyint3,017multiple多個(gè)tinyint3,0 mdl_block_instance描述：版塊實(shí)例表序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02blockid動(dòng)作IDbigint19,03pageid頁(yè)面IDbigint19,04pagetype頁(yè)碼類(lèi)型varchar205position定位varchar106weight加權(quán)smallint5,07visible是否可見(jiàn)tinyint3,08configdata配置數(shù)據(jù)內(nèi)容text65535 mdl_block_pinned描述：固定版塊表序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02blockid動(dòng)作IDbigint19,03pagetype頁(yè)碼類(lèi)型varchar204position位置varchar105weight加權(quán)smallint5,06visible是否可見(jiàn)tinyint3,07configdata配置數(shù)據(jù)text65535 mdl_block_rss_client描述：版塊RSS客戶端表序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02userid用戶IDbigint19,03title標(biāo)題text655354preferredtitle首先標(biāo)題varchar645description描述text655356shared是否分享tinyint3,07url分享地址varchar255 mdl_blog_tag_instance描述：版塊標(biāo)簽實(shí)例表序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02entryid條目IDbigint19,03tagid標(biāo)簽IDbigint19,04groupid群組IDbigint19,05courseid課程IDbigint19,06userid用戶IDbigint19,07timemodified編輯時(shí)間bigint19,0 mdl_cache_filters描述：緩存過(guò)濾表序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02filter過(guò)濾器名varchar323version版本bigint19,04md5keyMD5加密密鑰varchar325rawtext原內(nèi)容text655356timemodified編輯時(shí)間bigint19,0 mdl_cache_text描述：緩存文本表序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02md5keyMD5加密密鑰varchar323formattedtext格式化后的內(nèi)容longtext42949672954timemodified編輯時(shí)間bigint19,0 mdl_capabilities描述：能力表 序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02name名稱(chēng)varchar2553captype能力類(lèi)型varchar504contextlevel權(quán)限級(jí)別bigint19,05ponent組件varchar1006riskbitmaskbigint19,0 mdl_chat描述：聊天室序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02course課程IDbigint19,03name聊天室名varchar2554intro簡(jiǎn)介text655355keepdays保持天數(shù)bigint19,06studentlogs每個(gè)人都可以查看過(guò)去的會(huì)話smallint5,07chattime聊天時(shí)間bigint19,08schedule附表smallint5,09timemodified編輯時(shí)間bigint19,0 mdl_chat_messages描述：聊天信息表序號(hào)字段名稱(chēng)字段描述字段類(lèi)型長(zhǎng)度允許空缺省值1id自增量編號(hào)bigint19,02chatid聊天對(duì)話IDbigint19,03userid用戶IDbigint19,04groupid群組IDbigint19,
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1