moodle數(shù)據(jù)庫結(jié)構(gòu)

1、Moodle數(shù)據(jù)字典編寫：小東前言The Moodle database has around 200 tables, and can be quite daunting at first sight.Moodle在線教學(xué)系統(tǒng)，有大約200多張表，第一次看到這樣的場面，心里肯定會打鼓的。DOCS on : /en/Development:Database_schema_introduction【注釋】點擊鏈接可以查看表結(jié)構(gòu)【注釋】如果沒有特別說明，中文對應(yīng)的解釋是從官網(wǎng)對應(yīng)位置翻譯過來，僅供參考。Moodle系統(tǒng)基本結(jié)構(gòu)圖基本模塊擴

2、展模塊管理系統(tǒng)系統(tǒng)外觀用戶管理活動、資源語言擴展用戶驗證個人資料Moodle內(nèi)置任何人開發(fā)的符合標(biāo)準(zhǔn)的主題內(nèi)置 作業(yè) | 聊天 | 討論 | 各種課件 | 各種模式 | 考試 |擴展的各種標(biāo)準(zhǔn)內(nèi)置en_au, 擴展包En_us, zh_cn_tf8等等郵箱驗證 | LDAP | 其他.內(nèi)置個人博客系統(tǒng)Mysql(默認(rèn))數(shù)據(jù)庫其他知名數(shù)據(jù)庫表結(jié)構(gòu)詳細(xì)分析Configuration /參數(shù)配置相關(guān) tfmdl_config tfmdl_config_plugins Users and their profiles / 用戶相關(guān) tfmdl_user tfmdl_user_info_category

3、 tfmdl_user_info_data tfmdl_user_info_field tfmdl_user_lastaccess 由于性能上的考慮，將tfmdl_user_lastaccess這張表與user表分開設(shè)計，單獨成為一張表。 tfmdl_user_preferences tfmdl_user_private_key The roles and capabilites system /角色和權(quán)限系統(tǒng) tfmdl_role tfmdl_role_allow_assign tfmdl_role_allow_override tfmdl_role_assignments tfmdl_ro

4、le_capabilities tfmdl_role_names tfmdl_role_sortorder role defines a role, its name, etc. Other parts of the role definition are stored in the role_capabilities and role_context_levels tables. 定義一種角色（含角色名稱等等），角色定義的其它詳細(xì)部分，存放在role_capabilites 和 role_context_levels兩張表中。capabilites the various permissio

5、ns that can be granted. 各種各樣的權(quán)限列表。context a context is a scope in Moodle, for example the whole system, a course, a particular activity. The type is given by contextlevel, and depending on context level, instanceid points to one of a number of different tables. 指定某個角色在某個特定的范圍內(nèi)擁有某種權(quán)限。role_allow_assig

6、n which roles can assign which other roles 指定角色能夠為哪些其它角色授權(quán)（授予某種權(quán)限）。 例子：老師可以選擇某些用戶，作為自己任教課程的學(xué)生，課程設(shè)計老師可以任用某個老師作為自己設(shè)計的某個課程的任課老師。role_allow_override which roles can override which other roles 角色的層級管理。某個角色可以剔除另一種角色（在允許的范圍內(nèi)）。role_allow_switch which roles can switch to which other roles (Moodle 2.0 onwards

7、.) 列出用戶擁有的角色，使其可在這些角色中自由轉(zhuǎn)換。role_assignments which users are assigned which roles in which contexts 存儲了某個用戶被指定了某種角色。role_capabilities the permission for each capability in either a role definition (if contextid points to the system context) or a role override (if contextid points to some other contex

8、t) 記錄每種權(quán)限的功能。共550多種權(quán)限。ORZ.role_context_levels the context levels at which each role can be assigned. (Moodle 2.0 onwards) role_names used to implement the feature where roles can be given different names in different courses (or, more gererally, contexts) 記錄自定義角色的名稱，可以新增角色的名稱，或者更改現(xiàn)有的角色的名稱。role_sorto

9、rder is not actually used anywhere in the code! 似乎 這個表是一張從來沒有用過的表。The following diagram shows the tables with their columns and the relationships between them, and other tables in Moodle. Courses and their organisation into categories /課程相關(guān) tfmdl_course tfmdl_course_allowed_modules tfmdl_course_cate

10、gories tfmdl_course_display tfmdl_course_meta tfmdl_course_modules tfmdl_course_request tfmdl_course_sections Activities and their arrangement within courses /課程安排modules / 現(xiàn)有支持的課程安排 記錄了已經(jīng)支持的一些課程設(shè)計，老師在管理自己的課程時，可以選擇到的功能，比如創(chuàng)建一份在線文檔，發(fā)布一個公共討論課題，發(fā)布作業(yè)，上傳一份資源等等。course_allowed_modules course_modules course_

11、sections See also the tables belonging to particular activity modules. For example forum_*, quiz_*, etc. Groups and groupings /組 、班級表 tfmdl_groupings tfmdl_groupings_groups tfmdl_groups tfmdl_groups_members The logging system /歸檔系統(tǒng) tfmdl_log tfmdl_log_display Blocks system / tfmdl_block tfmdl_block_

12、instance tfmdl_block_pinned tfmdl_block_rss_client tfmdl_block_search_documents Some particular blocks also have their own database tables. For example block_rss_client. Events / 作業(yè)系統(tǒng)event_* Backup and restore /備份和恢復(fù) tfmdl_backup_config tfmdl_backup_courses tfmdl_backup_files tfmdl_backup_ids tfmdl_

13、backup_log Statistics /統(tǒng)計表 tfmdl_stats_daily tfmdl_stats_monthly tfmdl_stats_user_daily tfmdl_stats_user_monthly tfmdl_stats_user_weekly tfmdl_stats_weekly Tags /標(biāo)簽標(biāo)簽是允許其他人用哪些詞找到自己。 tfmdl_tag tfmdl_tag_correlation tfmdl_tag_instance Gradebook /成績系統(tǒng) tfmdl_grade_categories tfmdl_grade_categories_histo

14、ry tfmdl_grade_grades tfmdl_grade_grades_history tfmdl_grade_import_newitem tfmdl_grade_import_values tfmdl_grade_items tfmdl_grade_items_history tfmdl_grade_letters tfmdl_grade_outcomes tfmdl_grade_outcomes_courses tfmdl_grade_outcomes_history tfmdl_grade_settings Question bank and question engine/

15、 問題設(shè)置系統(tǒng)。Individual question typesThe following core question types have their own database tables: Calculated /計算題 Matching / 選擇題 Multiple choice /多選 Multi-answer (Cloze) / Numerical Random short-answer matching / Short answer /簡答 True/false /正誤判斷 tfmdl_question tfmdl_question_answers tfmdl_question

16、_attempts tfmdl_question_calculated tfmdl_question_categories tfmdl_question_datasets tfmdl_question_dataset_definitions tfmdl_question_dataset_items tfmdl_question_match tfmdl_question_match_sub tfmdl_question_multianswer tfmdl_question_multichoice tfmdl_question_numerical tfmdl_question_numerical_

17、units tfmdl_question_randomsamatch tfmdl_question_sessions tfmdl_question_shortanswer tfmdl_question_states tfmdl_question_truefalse See also the tables for individual question types, which all start question_. Messaging system /message_* Moodle Networkmnet_* / 獲得網(wǎng)絡(luò)支持的。Caching /緩存cache_* Miscellaneo

18、us /其他一些設(shè)定項目scale scale_history sessions2 / 設(shè)置session 的前綴timezone /設(shè)置時區(qū)post Activity modules Assignment Chat Choice Data Feedback Forum Glossary Hotpot Label Lesson Quiz Resource SCORM Survey Wiki Authentication plugins . Blocks . Enrolment plugins . Question types Calculated Matching Multiple choic

19、e Multi-answer (Cloze) Numerical Random short-answer matching Short answer True/false 數(shù)據(jù)庫表結(jié)構(gòu)注釋：安裝的時候，為表配置了前綴tfmdl表的結(jié)構(gòu) adodb_logsql字段類型Null默認(rèn)idbigint(10) 是NULLcreateddatetime是NULLsql0varchar(250)是sql1text是NULLparamstext是NULLtracertext是NULLtimerdecimal(16,6)是0.表的結(jié)構(gòu) tfmdl_assignment字段類型Null默認(rèn)idbigint(1

20、0) 是NULLcoursebigint(10) 是0namevarchar(255)是descriptiontext是NULLformatsmallint(4) 是0assignmenttypevarchar(50)是resubmittinyint(2) 是0preventlatetinyint(2) 是0emailteacherstinyint(2) 是0var1bigint(10)是0var2bigint(10)是0var3bigint(10)是0var4bigint(10)是0var5bigint(10)是0maxbytesbigint(10) 是timeduebigint(10) 是

21、0timeavailablebigint(10) 是0gradebigint(10)是0timemodifiedbigint(10) 是0表的結(jié)構(gòu) tfmdl_assignment_submissions字段類型Null默認(rèn)idbigint(10) 是NULLassignmentbigint(10) 是0useridbigint(10) 是0timecreatedbigint(10) 是0timemodifiedbigint(10) 是0numfilesbigint(10) 是0data1text是NULLdata2text是NULLgradebigint(11)是0submissioncom

22、menttext是NULLformatsmallint(4) 是0teacherbigint(10) 是0timemarkedbigint(10) 是0mailedtinyint(1) 是0表的結(jié)構(gòu) tfmdl_backup_config字段類型Null默認(rèn)idbigint(10) 是NULLnamevarchar(255)是valuevarchar(255)是表的結(jié)構(gòu) tfmdl_backup_courses字段類型Null默認(rèn)idbigint(10) 是NULLcourseidbigint(10) 是0laststarttimebigint(10) 是0lastendtimebigint(

23、10) 是0laststatusvarchar(1)是0nextstarttimebigint(10) 是0表的結(jié)構(gòu) tfmdl_backup_files字段類型Null默認(rèn)idbigint(10) 是NULLbackup_codebigint(10) 是0file_typevarchar(10)是pathvarchar(255)是old_idbigint(10) 是0new_idbigint(10) 是0表的結(jié)構(gòu) tfmdl_backup_ids字段類型Null默認(rèn)idbigint(10) 是NULLbackup_codebigint(12) 是0table_namevarchar(30)是

24、old_idbigint(10) 是0new_idbigint(10) 是0infomediumtext是NULL表的結(jié)構(gòu) tfmdl_backup_log字段類型Null默認(rèn)idbigint(10) 是NULLcourseidbigint(10) 是0timebigint(10) 是0laststarttimebigint(10) 是0infovarchar(255)是表的結(jié)構(gòu) tfmdl_block字段類型Null默認(rèn)idbigint(10) 是NULLnamevarchar(40)是versionbigint(10) 是0cronbigint(10) 是0lastcronbigint(1

25、0) 是0visibletinyint(1)是1multipletinyint(1)是0表的結(jié)構(gòu) tfmdl_block_instance字段類型Null默認(rèn)idbigint(10) 是NULLblockidbigint(10) 是0pageidbigint(10) 是0pagetypevarchar(20)是positionvarchar(10)是weightsmallint(3)是0visibletinyint(1)是0configdatatext是NULL表的結(jié)構(gòu) tfmdl_block_pinned字段類型Null默認(rèn)idbigint(10) 是NULLblockidbigint(10

26、) 是0pagetypevarchar(20)是positionvarchar(10)是weightsmallint(3)是0visibletinyint(1)是0configdatatext是NULL表的結(jié)構(gòu) tfmdl_block_rss_client字段類型Null默認(rèn)idbigint(10) 是NULLuseridbigint(10) 是0titletext是NULLpreferredtitlevarchar(64)是descriptiontext是NULLsharedtinyint(2) 是0urlvarchar(255)是表的結(jié)構(gòu) tfmdl_block_search_docume

27、nts字段類型Null默認(rèn)idbigint(10) 是NULLdocidvarchar(32)是doctypevarchar(32)是noneitemtypevarchar(32)是standardtitlevarchar(255)是urlvarchar(255)是docdatebigint(10) 是0updatedbigint(10) 是0courseidbigint(10) 是0groupidbigint(10) 是0表的結(jié)構(gòu) tfmdl_cache_filters字段類型Null默認(rèn)idbigint(10) 是NULLfiltervarchar(32)是versionbigint(10

28、) 是0md5keyvarchar(32)是rawtexttext是NULLtimemodifiedbigint(10) 是0表的結(jié)構(gòu) tfmdl_cache_flags字段類型Null默認(rèn)idbigint(10) 是NULLflagtypevarchar(255)是namevarchar(255)是timemodifiedbigint(10) 是0valuemediumtext是NULLexpirybigint(10) 是NULL表的結(jié)構(gòu) tfmdl_cache_text字段類型Null默認(rèn)idbigint(10) 是NULLmd5keyvarchar(32)是formattedtextlo

29、ngtext是NULLtimemodifiedbigint(10) 是0表的結(jié)構(gòu) tfmdl_capabilities字段類型Null默認(rèn)idbigint(10) 是NULLnamevarchar(255)是captypevarchar(50)是contextlevelbigint(10) 是0componentvarchar(100)是riskbitmaskbigint(10) 是0表的結(jié)構(gòu) tfmdl_chat字段類型Null默認(rèn)idbigint(10) 是NULLcoursebigint(10) 是0namevarchar(255)是introtext是NULLkeepdaysbigin

30、t(11)是0studentlogssmallint(4)是0chattimebigint(10) 是0schedulesmallint(4)是0timemodifiedbigint(10) 是0表的結(jié)構(gòu) tfmdl_chat_messages字段類型Null默認(rèn)idbigint(10) 是NULLchatidbigint(10)是0useridbigint(10)是0groupidbigint(10)是0systemtinyint(1) 是0messagetext是NULLtimestampbigint(10) 是0表的結(jié)構(gòu) tfmdl_chat_users字段類型Null默認(rèn)idbigin

31、t(10) 是NULLchatidbigint(11)是0useridbigint(11)是0groupidbigint(11)是0versionvarchar(16)是ipvarchar(15)是firstpingbigint(10) 是0lastpingbigint(10) 是0lastmessagepingbigint(10) 是0sidvarchar(32)是coursebigint(10) 是0langvarchar(30)是表的結(jié)構(gòu) tfmdl_choice字段類型Null默認(rèn)idbigint(10) 是NULLcoursebigint(10) 是0namevarchar(255)

32、是texttext是NULLformattinyint(2) 是0publishtinyint(2) 是0showresultstinyint(2) 是0displaysmallint(4) 是0allowupdatetinyint(2) 是0showunansweredtinyint(2) 是0limitanswerstinyint(2) 是0timeopenbigint(10) 是0timeclosebigint(10) 是0timemodifiedbigint(10) 是0表的結(jié)構(gòu) tfmdl_choice_answers字段類型Null默認(rèn)idbigint(10) 是NULLchoic

33、eidbigint(10) 是0useridbigint(10) 是0optionidbigint(10) 是0timemodifiedbigint(10) 是0表的結(jié)構(gòu) tfmdl_choice_options字段類型Null默認(rèn)idbigint(10) 是NULLchoiceidbigint(10) 是0texttext是NULLmaxanswersbigint(10) 是0timemodifiedbigint(10) 是0表的結(jié)構(gòu) tfmdl_config字段類型Null默認(rèn)idbigint(10) 是NULLnamevarchar(255)是valuetext是NULL表的結(jié)構(gòu) tfm

34、dl_config_plugins字段類型Null默認(rèn)idbigint(10) 是NULLpluginvarchar(100)是corenamevarchar(100)是valuetext是NULL表的結(jié)構(gòu) tfmdl_context字段類型Null默認(rèn)idbigint(10) 是NULLcontextlevelbigint(10) 是0instanceidbigint(10) 是0pathvarchar(255)是NULLdepthtinyint(2) 是0表的結(jié)構(gòu) tfmdl_context_temp字段類型Null默認(rèn)idbigint(10) 是NULLpathvarchar(255)是

35、depthtinyint(2) 是NULL表的結(jié)構(gòu) tfmdl_course字段類型Null默認(rèn)idbigint(10) 是NULLcategorybigint(10) 是0sortorderbigint(10) 是0passwordvarchar(50)是fullnamevarchar(254)是shortnamevarchar(100)是idnumbervarchar(100)是summarytext是NULLformatvarchar(10)是topicsshowgradestinyint(2) 是1modinfolongtext是NULLnewsitemsmediumint(5) 是1

36、teachervarchar(100)是Teacherteachersvarchar(100)是Teachersstudentvarchar(100)是Studentstudentsvarchar(100)是Studentsguesttinyint(2) 是0startdatebigint(10) 是0enrolperiodbigint(10) 是0numsectionsmediumint(5) 是1markerbigint(10) 是0maxbytesbigint(10) 是0showreportssmallint(4) 是0visibletinyint(1) 是1hiddensection

37、stinyint(2) 是0groupmodesmallint(4) 是0groupmodeforcesmallint(4) 是0defaultgroupingidbigint(10) 是0langvarchar(30)是themevarchar(50)是costvarchar(10)是currencyvarchar(3)是USDtimecreatedbigint(10) 是0timemodifiedbigint(10) 是0metacoursetinyint(1) 是0requestedtinyint(1) 是0restrictmodulestinyint(1) 是0expirynotify

38、tinyint(1) 是0expirythresholdbigint(10) 是0notifystudentstinyint(1) 是0enrollabletinyint(1) 是1enrolstartdatebigint(10) 是0enrolenddatebigint(10) 是0enrolvarchar(20)是defaultrolebigint(10) 是0表的結(jié)構(gòu) tfmdl_course_allowed_modules字段類型Null默認(rèn)idbigint(10) 是NULLcoursebigint(10) 是0modulebigint(10) 是0表的結(jié)構(gòu) tfmdl_course

39、_categories字段類型Null默認(rèn)idbigint(10) 是NULLnamevarchar(255)是descriptiontext是NULLparentbigint(10) 是0sortorderbigint(10) 是0coursecountbigint(10) 是0visibletinyint(1)是1timemodifiedbigint(10) 是0depthbigint(10) 是0pathvarchar(255)是themevarchar(50)是NULL表的結(jié)構(gòu) tfmdl_course_display字段類型Null默認(rèn)idbigint(10) 是NULLcourse

40、bigint(10) 是0useridbigint(10) 是0displaybigint(10)是0表的結(jié)構(gòu) tfmdl_course_meta字段類型Null默認(rèn)idbigint(10) 是NULLparent_coursebigint(10) 是0child_coursebigint(10) 是0表的結(jié)構(gòu) tfmdl_course_modules字段類型Null默認(rèn)idbigint(10) 是NULLcoursebigint(10) 是0modulebigint(10) 是0instancebigint(10) 是0sectionbigint(10) 是0idnumbervarchar(

41、100)是NULLaddedbigint(10) 是0scoresmallint(4)是0indentmediumint(5) 是0visibletinyint(1)是1visibleoldtinyint(1)是1groupmodesmallint(4)是0groupingidbigint(10) 是0groupmembersonlysmallint(4) 是0表的結(jié)構(gòu) tfmdl_course_request字段類型Null默認(rèn)idbigint(10) 是NULLfullnamevarchar(254)是shortnamevarchar(15)是summarytext是NULLreasont

42、ext是NULLrequesterbigint(10) 是0passwordvarchar(50)是表的結(jié)構(gòu) tfmdl_course_sections字段類型Null默認(rèn)idbigint(10) 是NULLcoursebigint(10) 是0sectionbigint(10) 是0summarytext是NULLsequencetext是NULLvisibletinyint(1)是1表的結(jié)構(gòu) tfmdl_data字段類型Null默認(rèn)idbigint(10) 是NULLcoursebigint(10) 是0namevarchar(255)是introtext是NULLcommentssmal

43、lint(4) 是0timeavailablefrombigint(10) 是0timeavailabletobigint(10) 是0timeviewfrombigint(10) 是0timeviewtobigint(10) 是0requiredentriesint(8) 是0requiredentriestoviewint(8) 是0maxentriesint(8) 是0rssarticlessmallint(4) 是0singletemplatetext是NULLlisttemplatetext是NULLlisttemplateheadertext是NULLlisttemplatefoo

44、tertext是NULLaddtemplatetext是NULLrsstemplatetext是NULLrsstitletemplatetext是NULLcsstemplatetext是NULLjstemplatetext是NULLasearchtemplatetext是NULLapprovalsmallint(4) 是0scalebigint(10)是0assessedbigint(10) 是0defaultsortbigint(10) 是0defaultsortdirsmallint(4) 是0editanysmallint(4) 是0notificationbigint(10)是NULL

45、表的結(jié)構(gòu) tfmdl_data_comments字段類型Null默認(rèn)idbigint(10) 是NULLuseridbigint(10) 是0recordidbigint(10) 是0contenttext是NULLformattinyint(2) 是0createdbigint(10) 是0modifiedbigint(10) 是0表的結(jié)構(gòu) tfmdl_data_content字段類型Null默認(rèn)idbigint(10) 是NULLfieldidbigint(10) 是0recordidbigint(10) 是0contentlongtext是NULLcontent1longtext是NUL

46、Lcontent2longtext是NULLcontent3longtext是NULLcontent4longtext是NULL表的結(jié)構(gòu) tfmdl_data_fields字段類型Null默認(rèn)idbigint(10) 是NULLdataidbigint(10) 是0typevarchar(255)是namevarchar(255)是descriptiontext是NULLparam1text是NULLparam2text是NULLparam3text是NULLparam4text是NULLparam5text是NULLparam6text是NULLparam7text是NULLparam8text是NULLparam9text是NULLparam10text是NULL表的結(jié)構(gòu) tfmdl_data_ratings字段類型Null默認(rèn)idbigint(10)