Tool Sitepolicy User Consent Table Schema (tool_sitepolicy_user_consent)


Description

Answers from the user in the localised policy

tool_sitepolicy_user_consent table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
userid BIGINT 19 null
user.id toolsiteusercons_use2_fk R

The user whose answered this is
timeconsented BIGINT 19 √ null

Timestamp of when the user answered
hasconsented BIT 1 √ null

Has the user consented to this option
consentoptionid BIGINT 19 √ null
tool_sitepolicy_consent_options.id toolsiteusercons_con2_fk R

Which option the user consented to
language VARCHAR 30

Language used when user consented

Table contained -1 rows

tool_sitepolicy_user_consent table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolsiteusercons_con_ix Performance Asc consentoptionid
toolsiteusercons_use_ix Performance Asc userid
toolsiteusercons_usetimcon_uix Must be unique Asc/Asc/Asc userid + timeconsented + consentoptionid

tool_sitepolicy_user_consent table relationships

Close relationships within degrees of separation