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 3 √ 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 3 √ 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