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
tool_dataprivacy_rqst_ctxlst.requestid tooldatarqstctxl_req2_fk R
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 BIT 0 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
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

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