dp_permissions table columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| templateid | BIGINT | 19 | null |
|
|
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
Close relationships within degrees of separation
