moodle数据库结构.docx

Moodle数据字典编写：小东前言The Moodle database has around 200 tables, and can be quite daunting at first sight.Moodle在线教学系统，有大约200多张表，第一次看到这样的场面，心里肯定会打鼓的。DOCS on :/en/Development:Database_schema_introduction【注释】点击链接可以查看表结构【注释】如果没有特别说明，中文对应的解释是从官网对应位置翻译过来，仅供参考。Moodle系统基本结构图表结构详细分析Configuration //参数配置相关tfmdl_config tfmdl_config_plugins Users and their profiles // 用户相关tfmdl_user tfmdl_user_info_category tfmdl_user_info_data tfmdl_user_info_field tfmdl_user_lastaccess 由于性能上的考虑，将tfmdl_user_lastaccess这张表与user表分开设计，单独成为一张表。tfmdl_user_preferences tfmdl_user_private_key The roles and capabilites system //角色和权限系统tfmdl_role tfmdl_role_allow_assign tfmdl_role_allow_override tfmdl_role_assignments tfmdl_role_capabilities tfmdl_role_names tfmdl_role_sortorder roledefines a role, its name, etc. Other parts of the role definition are stored in the role_capabilities and role_context_levels tables. 定义一种角色（含角色名称等等），角色定义的其它详细部分，存放在role_capabilites 和 role_context_levels两张表中。capabilitesthe various permissions that can be granted. 各种各样的权限列表。contextacontext 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. 指定某个角色在某个特定的范围内拥有某种权限。role_allow_assign which roles can assign which other roles 指定角色能够为哪些其它角色授权（授予某种权限）。例子：老师可以选择某些用户，作为自己任教课程的学生，课程设计老师可以任用某个老师作为自己设计的某个课程的任课老师。role_allow_override which roles can override which other roles 角色的层级管理。某个角色可以剔除另一种角色（在允许的范围内）。role_allow_switch whichroles can switch to which other roles (Moodle 2.0 onwards.) 列出用户拥有的角色，使其可在这些角色中自由转换。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 context) 记录每种权限的功能。共550多种权限。ORZ…..role_context_levels the context levels at which each role can be assigned. (Moodle