tool_dataprivacy_request

0 rows


Description

Table for data requests

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
type BIGINT 19 0
comments LONGTEXT 2147483647 √ null
commentsformat TINYINT 3 0
userid BIGINT 19 0
user.id tooldatarequ_use3_fkR
requestedby BIGINT 19 0
user.id tooldatarequ_req2_fkR
status TINYINT 3 0
dpo BIGINT 19 √ 0
user.id tooldatarequ_dpo2_fkR
dpocomment LONGTEXT 2147483647 √ null
dpocommentformat TINYINT 3 0
systemapproved SMALLINT 5 0
usermodified BIGINT 19 0
user.id tooldatarequ_use4_fkR
timecreated BIGINT 19 0
timemodified BIGINT 19 0
creationmethod BIGINT 19 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tooldatarequ_dpo4_ix Performance Asc dpo
tooldatarequ_req4_ix Performance Asc requestedby
tooldatarequ_use6_ix Performance Asc userid
tooldatarequ_use8_ix Performance Asc usermodified

Relationships

Close relationships within degrees of separation