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
name VARCHAR 100
description LONGTEXT 2147483647 null
descriptionformat BIT 0 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 0 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