Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||||
| 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 |
|
|
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 |
|
|
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 |