Dp Permissions Table Schema (dp_permissions)


Stores the permission settings for plan templates

dp_permissions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
templateid BIGINT 19 null
dp_template.id dpperm_tem2_fk R

ID of the template that this permission setting is for

role VARCHAR 255 null

Name of a development plan role, not moodle role.

component VARCHAR 255 null

Shortname of component this permission is related to. Same as folder name in components or plan if related to the whole plan.

action VARCHAR 255 null

Shortname of the permission to be set

value SMALLINT 5 null

Integer value representing the permission, or null if not set

Table contained -1 rows

dp_permissions table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dpperm_tem_ix Performance Asc templateid

dp_permissions table relationships