Moodle LMS 3.9
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
Tool Dataprivacy Purposerole Table Schema (tool_dataprivacy_purposerole)
Description
Data purpose overrides for a specific role
tool_dataprivacy_purposerole table columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
BIGINT
19
√
null
purposeid
BIGINT
19
null
tool_dataprivacy_purpose
.id
tooldatapurp_pur2_fk
R
roleid
BIGINT
19
null
role
.id
tooldatapurp_rol2_fk
R
lawfulbases
LONGTEXT
2147483647
√
null
sensitivedatareasons
LONGTEXT
2147483647
√
null
retentionperiod
VARCHAR
255
protected
BIT
1
√
null
usermodified
BIGINT
19
null
timecreated
BIGINT
19
null
timemodified
BIGINT
19
null
Showing 1 to 10 of 10 entries
Table contained
-1
rows
tool_dataprivacy_purposerole table indexes
Search:
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
id
tooldatapurp_pur_ix
Performance
Asc
purposeid
tooldatapurp_purrol_uix
Must be unique
Asc
/
Asc
purposeid + roleid
tooldatapurp_rol_ix
Performance
Asc
roleid
Showing 1 to 4 of 4 entries
tool_dataprivacy_purposerole table relationships
Close relationships within degrees of separation
One
Two degrees
One implied
Two implied