Tool Sitepolicy Localised Consent Table Schema (tool_sitepolicy_localised_consent)


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

Which localised policy these statements relate to

consentoptionid BIGINT 19 null 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