moodle数据库结构

Moodle数据字典编写：小东前言TheMoodledatabasehasaround200tables,andcanbequitedauntingatfirstsight.Moodle在线教学系统，有大约200多张表，第一次看到这样的场面，心里肯定会打鼓的。DOCSonmoodle.org::Database_schema_introduction【注释】点击链接可以查看表结构【注释】如果没有特别说明，中文对应的解释是从官网对应位置翻译过来，仅供参考。Moodle系统基本结构图表结构详细分析Configuration//参数配置相关tfmdl_configtfmdl_config_pluginsUsersandtheirprofiles//用户相关tfmdl_usertfmdl_user_info_categorytfmdl_user_info_datatfmdl_user_info_fieldtfmdl_user_lastaccess基本模块扩展模块管理系统系统外观用户管理活动、资源语言扩展用户验证个人资料Moodle内置任何人开发的符合标准的主题内置作业|聊天|讨论|各种课件|各种模式|考试|扩展的各种标准内置en_au,扩展包En_us,zh_cn_tf8等等…邮箱验证|LDAP|其他…..内置个人博客系统…Mysql(默认)数据库其他知名数据库…由于性能上的考虑，将tfmdl_user_lastaccess这张表与user表分开设计，单独成为一张表。tfmdl_user_preferencestfmdl_user_private_keyTherolesandcapabilitessystem//角色和权限系统tfmdl_roletfmdl_role_allow_assigntfmdl_role_allow_overridetfmdl_role_assignmentstfmdl_role_capabilitiestfmdl_role_namestfmdl_role_sortorderroledefinesarole,itsname,etc.Otherpartsoftheroledefinitionarestoredintherole_capabilitiesandrole_context_levelstables.定义一种角色（含角色名称等等），角色定义的其它详细部分，存放在role_capabilites和role_context_levels两张表中。capabilitesthevariouspermissionsthatcanbegranted.各种各样的权限列表。contextacontextisascopeinMoodle,forexamplethewholesystem,acourse,aparticularactivity.Thetypeisgivenbycontextlevel,anddependingoncontextlevel,instanceidpointstooneofanumberofdifferenttables.指定某个角色在某个特定的范围内拥有某种权限。role_allow_assignwhichrolescanassignwhichotherroles指定角色能够为哪些其它角色授权（授予某种权限）。例子：老师可以选择某些用户，作为自己任教课程的学生，课程设计老师可以任用某个老师作为自己设计的某个课程的任课老师。role_allow_overridewhichrolescanoverridewhichotherroles角色的层级管理。某个角色可以剔除另一种角色（在允许的范围内）。role_allow_switchwhichrolescanswitchtowhichotherroles(Moodle2.0onwards.)列出用户拥有的角色，使其可在这些角色中自由转换。role_assignmentswhichusersareassignedwhichrolesinwhichcontexts存储了某个用户被指定了某种角色。role_capabilitiesthepermissionforeachcapabilityineitheraroledefinition(ifcontextidpointstothesystemcontext)oraroleoverride(ifcontextidpointstosomeothercontext)记录每种权限的功能。共550多种权限。ORZ…..role_context_levelsthecontextlevelsatwhicheachrolecanbeassigned.(Moodle2.0onwards)role_namesusedtoimplementthefeaturewhererolescanbegivendifferentnamesindifferentcourses(or,moregererally,contexts)记录自定义角色的名称，可以新增角色的名称，或者更改现有的角色的名称。role_sortorderisnotactuallyusedanywhereinthecode!似乎~~这个表是一张从来没有用过的表。Thefollowingdiagramshowsthetableswiththeircolumnsandtherelationshipsbetweenthem,andothertablesinMoodle.Coursesandtheirorganisationintocategories//课程相关tfmdl_coursetfmdl_course_allowed_modulestfmdl_course_categoriestfmdl_course_displaytfmdl_course_metatfmdl_course_modulestfmdl_course_requesttfmdl_course_sectionsActivitiesandtheirarrangementwithincourses//课程安排modules//现有支持的课程安排记录了已经支持的一些课程设计，老师在管理自己的课程时，可以选择到的功能，比如创建一份在线文档，发布一个公共讨论课题，发布作业，上传一份资源等等。course_allowed_modulescourse_modulescourse_sectionsSeealsothetablesbelongingtoparticularactivitymodules.Forexampleforum_*,quiz_*,etc.Groupsandgroupings//组、班级表tfmdl_groupingstfmdl_groupings_groupstfmdl_groupstfmdl_groups_membersTheloggingsystem//归档系统tfmdl_logtfmdl_log_displayBlockssystem//tfmdl_blocktfmdl_block_instancetfmdl_block_pinnedtfmdl_block_rss_clienttfmdl_block_search_documentsSomeparticularblocksalsohavetheirowndatabasetables.Forexampleblock_rss_client.Events//作业系统event_*Backupandrestore//备份和恢复tfmdl_backup_configtfmdl_backup_coursestfmdl_backup_filestfmdl_backup_idstfmdl_backup_logStatistics//统计表tfmdl_stats_dailytfmdl_stats_monthlytfmdl_stats_user_dailytfmdl_stats_user_monthlytfmdl_stats_user_weeklytfmdl_stats_weeklyTags//标签标签是允许其他人用哪些词找到自己。tfmdl_tagtfmdl_tag_correlationtfmdl_tag_instanceGradebook//成绩系统tfmdl_grade_categoriestfmdl_grade_categories_history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_settingsQuestionbankandquestionengine//问题设置系统。IndividualquestiontypesThefollowingcorequestiontypeshavetheirowndatabasetables:Calculated//计算题Matching//选择题Multiplechoice//多选Multi-answer(Cloze)//NumericalRandomshort-answermatching//Shortanswer//简答True/false//正误判断tfmdl_questiontfmdl_question_answerstfmdl_question_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_unitstfmdl_question_randomsamatchtfmdl_question_sessionstfmdl_question_shortanswertfmdl_question_statestfmdl_question_truefalseSeealsothetablesforindividualquestiontypes,whichallstartquestion_.Messagingsystem//message_*MoodleNetworkmnet_*////获得网络支持的。Caching//缓存cache_*Miscellaneous//其他一些设定项目scalescale_historysessions2//设置session的前缀timezone//设置时区postActivitymodulesAssignmentChatChoiceDataFeedbackForumGlossaryHotpotLabelLessonQuizResourceSCORMSurveyWikiAuthenticationplugins...Blocks...Enrolme