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_pol4_ix Performance Asc policyid
toolpolivers_use4_ix Performance Asc usermodified

Relationships