# 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_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

### Relationships