tool_dataprivacy_purpose

0 rows


Description

Data purposes

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
tool_dataprivacy_ctxinstance.purposeid tooldatactxi_pur2_fkR
tool_dataprivacy_ctxlevel.purposeid tooldatactxl_pur2_fkR
tool_dataprivacy_purposerole.purposeid tooldatapurp_pur2_fkR
name VARCHAR 100
description LONGTEXT 2147483647 null
descriptionformat BIT 1 null
lawfulbases LONGTEXT 2147483647 null

Comma-separated IDs matching records in tool_dataprivacy_lawfulbasis

sensitivedatareasons LONGTEXT 2147483647 null

Comma-separated IDs matching records in tool_dataprivacy_sensitive

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

Relationships