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
user.id tooldatapurp_use2_fkR
timecreated BIGINT 19 null
timemodified BIGINT 19 null

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
tooldatapurp_use_ix Performance Asc usermodified

Relationships