Tool Dataprivacy Purpose table / tool_dataprivacy_purpose - Moodle LMS 3.9 Database schema / Zoola Analytics

tool_dataprivacy_purpose table columns

Related columns Constraint Comments

Search:

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

Showing 1 to 11 of 11 entries

Table contained -1 rows

Tool Dataprivacy Purpose Table Schema (tool_dataprivacy_purpose)

Description

tool_dataprivacy_purpose table columns

tool_dataprivacy_purpose table indexes

tool_dataprivacy_purpose table relationships

Close relationships within degrees of separation