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 |