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_pur2_ix Performance Asc purposeid
tooldatapurp_purrol2_uix Must be unique Asc/Asc purposeid + roleid
tooldatapurp_rol2_ix Performance Asc roleid

Relationships