tool_policy_acceptances

0 rows


Description

Tracks users accepting the policy versions

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
policyversionid BIGINT 19 null
tool_policy_versions.id toolpoliacce_pol2_fkR

ID of the policy document version

userid BIGINT 19 null
user.id toolpoliacce_use3_fkR

ID of the user this acceptance is relevant to

status BIT 1 null

Acceptance status: 1 - accepted, 0 - not accepted

lang VARCHAR 30

Code of the language the user had when the policy document was displayed

usermodified BIGINT 19 null
user.id toolpoliacce_use4_fkR

ID of the user who last modified the acceptance record

timecreated BIGINT 19 null

Timestamp of when the acceptance record was created

timemodified BIGINT 19 null

Timestamp of when the acceptance record was last modified

note LONGTEXT 2147483647 null

Plain text note describing how the actual consent has been obtained if the policy has been accepted on other user's behalf.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolpoliacce_pol4_ix Performance Asc policyversionid
toolpoliacce_poluse2_uix Must be unique Asc/Asc policyversionid + userid
toolpoliacce_use6_ix Performance Asc userid
toolpoliacce_use8_ix Performance Asc usermodified

Relationships