Tool Dataprivacy Purposerole Table Schema (tool_dataprivacy_purposerole)


Description

Data purpose overrides for a specific role

tool_dataprivacy_purposerole table columns

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

Table contained -1 rows

tool_dataprivacy_purposerole table indexes

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

tool_dataprivacy_purposerole table relationships

Close relationships within degrees of separation