Tool Sitepolicy Localised Consent Table Schema (tool_sitepolicy_localised_consent)


Description

The options which the user can choose from in a localised policy

tool_sitepolicy_localised_consent table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
statement LONGTEXT 2147483647 null

The question/statement the user can answer
consentoption VARCHAR 1333

The option the user selects to consent
nonconsentoption VARCHAR 1333

The option the user selects to not consent
localisedpolicyid BIGINT 19 √ null
tool_sitepolicy_localised_policy.id toolsitelocacons_loc2_fk R

Which localised policy these statements relate to
consentoptionid BIGINT 19 √ null
tool_sitepolicy_consent_options.id toolsitelocacons_con2_fk R

Which consent option of version it relates to

Table contained -1 rows

tool_sitepolicy_localised_consent table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolsitelocacons_con_ix Performance Asc consentoptionid
toolsitelocacons_loc_ix Performance Asc localisedpolicyid

tool_sitepolicy_localised_consent table relationships

Close relationships within degrees of separation