Tool Policy Acceptances Table Schema (tool_policy_acceptances)


Description

Tracks users accepting the policy versions

tool_policy_acceptances table columns

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

ID of the policy document version
userid BIGINT 19 null
user.id toolpoliacce_use3_fk R

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

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.

Table contained -1 rows

tool_policy_acceptances table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolpoliacce_pol_ix Performance Asc policyversionid
toolpoliacce_poluse_uix Must be unique Asc/Asc policyversionid + userid
toolpoliacce_use2_ix Performance Asc usermodified
toolpoliacce_use_ix Performance Asc userid

tool_policy_acceptances table relationships

Close relationships within degrees of separation