Tool Sitepolicy Consent Options Table Schema (tool_sitepolicy_consent_options)


Description

Manages localised consents

tool_sitepolicy_consent_options table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
tool_sitepolicy_localised_consent.consentoptionid toolsitelocacons_con2_fk R
tool_sitepolicy_user_consent.consentoptionid toolsiteusercons_con2_fk R
mandatory BIT 1 √ null

If the consent option requires consent to use the site
idnumber VARCHAR 255 √ null

Custom identification of consent option
policyversionid BIGINT 19 √ null
tool_sitepolicy_policy_version.id toolsiteconsopti_pol2_fk R

Which policy these consent options belong to

Table contained -1 rows

tool_sitepolicy_consent_options table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolsiteconsopti_pol_ix Performance Asc policyversionid

tool_sitepolicy_consent_options table relationships

Close relationships within degrees of separation