app_tool_sitepolicy_user_consent

0 rows


Description

Answers from the user in the localised policy

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_tool_sitepolicy_user_consent_id_seq'::regclass)
userid int8 19 null
app_user.id Defined in XMLR
timeconsented int8 19 null
hasconsented int2 5 null
consentoptionid int8 19 null
app_tool_sitepolicy_consent_options.id Defined in XMLR
language varchar 30 ''::character varying

Indexes

Constraint Name Type Sort Column(s)
app_toolsiteusercons_id_pk Primary key Asc id
app_toolsiteusercons_con_ix Performance Asc consentoptionid
app_toolsiteusercons_use_ix Performance Asc userid
app_toolsiteusercons_useti_uix Must be unique Asc/Asc/Asc userid + timeconsented + consentoptionid

Relationships