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 0 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