Tool Sitepolicy Consent Options Table Schema (tool_sitepolicy_consent_options)


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