tool_dataprivacy_purposerole

0 rows


Description

Data purpose overrides for a specific role

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
purposeid BIGINT 19 null
tool_dataprivacy_purpose.id tooldatapurp_pur2_fkR
roleid BIGINT 19 null
role.id tooldatapurp_rol2_fkR
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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tooldatapurp_pur4_ix Performance Asc purposeid
tooldatapurp_purrol2_uix Must be unique Asc/Asc purposeid + roleid
tooldatapurp_rol4_ix Performance Asc roleid

Relationships

Close relationships within degrees of separation