Tool Dataprivacy Purpose Table Schema (tool_dataprivacy_purpose)


Description

Data purposes

tool_dataprivacy_purpose table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
tool_dataprivacy_ctxinstance.purposeid tooldatactxi_pur2_fk R
tool_dataprivacy_ctxlevel.purposeid tooldatactxl_pur2_fk R
tool_dataprivacy_purposerole.purposeid tooldatapurp_pur2_fk R
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

Table contained -1 rows

tool_dataprivacy_purpose table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

tool_dataprivacy_purpose table relationships

Close relationships within degrees of separation