Tool Dataprivacy Request Table Schema (tool_dataprivacy_request)


Description

Table for data requests

tool_dataprivacy_request table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
type BIGINT 19 0

Data request type
comments LONGTEXT 2147483647 √ null

More details about the request
commentsformat TINYINT 3 0
userid BIGINT 19 0
user.id tooldatarequ_use3_fk R

The user ID the request is being made for
requestedby BIGINT 19 0
user.id tooldatarequ_req2_fk R

The user ID of the one making the request
status TINYINT 3 0

The current status of the data request
dpo BIGINT 19 √ 0
user.id tooldatarequ_dpo2_fk R

The user ID of the Data Protection Officer who is reviewing th request
dpocomment LONGTEXT 2147483647 √ null

DPO's comments (e.g. reason for rejecting the request, etc.)
dpocommentformat TINYINT 3 0
systemapproved SMALLINT 5 0
usermodified BIGINT 19 0
user.id tooldatarequ_use4_fk R

The user who created/modified this request object
timecreated BIGINT 19 0

The time this data request was created
timemodified BIGINT 19 0

The last time this data request was updated
creationmethod BIGINT 19 0

The type of the creation method of the data request

Table contained -1 rows

tool_dataprivacy_request table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tooldatarequ_dpo_ix Performance Asc dpo
tooldatarequ_req_ix Performance Asc requestedby
tooldatarequ_use2_ix Performance Asc usermodified
tooldatarequ_use_ix Performance Asc userid

tool_dataprivacy_request table relationships

Close relationships within degrees of separation