# tool_policy_versions

0 rows

### Description

Holds versions of the policy documents

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
tool_policy.currentversionid | toolpoli_cur2_fkR
tool_policy_acceptances.policyversionid | toolpoliacce_pol2_fkR
name | VARCHAR | 1333 |  |  |  |  |  | Name of the policy document
type | SMALLINT | 5 |  |  | 0 |  |  | Type of the policy: 0 - Site policy, 1 - Privacy policy, 2 - Third party policy, 99 - Other
audience | SMALLINT | 5 |  |  | 0 |  |  | Who is this policy targeted at: 0 - all users, 1 - logged in users only, 2 - guests only
archived | SMALLINT | 5 |  |  | 0 |  |  | Should the version be considered as archived. All non-archived, non-current versions are considered to be drafts.
usermodified | BIGINT | 19 |  |  | null |  |
user.id | toolpolivers_use2_fkR
| ID of the user who last edited this policy document version.
timecreated | BIGINT | 19 |  |  | null |  |  | Timestamp of when the policy version was created.
timemodified | BIGINT | 19 |  |  | null |  |  | Timestamp of when the policy version was last modified.
policyid | BIGINT | 19 |  |  | null |  |
tool_policy.id | toolpolivers_pol2_fkR
| ID of the policy document we are version of.
agreementstyle | SMALLINT | 5 |  |  | 0 |  |  | How this agreement should flow: 0 - on the consent page, 1 - on a separate page before reaching the consent page.
optional | SMALLINT | 5 |  |  | 0 |  |  | 0 - the policy must be accepted to use the site, 1 - accepting the policy is optional
revision | VARCHAR | 1333 |  |  |  |  |  | Human readable version of the policy document
summary | LONGTEXT | 2147483647 |  |  | null |  |  | Policy text summary
summaryformat | SMALLINT | 5 |  |  | null |  |  | Format of the summary field
content | LONGTEXT | 2147483647 |  |  | null |  |  | Full policy text
contentformat | SMALLINT | 5 |  |  | null |  |  | Format of the content field

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
toolpolivers_pol_ix | Performance | Asc | policyid
toolpolivers_use_ix | Performance | Asc | usermodified

### Relationships