Tool Policy Versions Table Schema (tool_policy_versions)


Description

Holds versions of the policy documents

tool_policy_versions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
tool_policy.currentversionid toolpoli_cur2_fk R
tool_policy_acceptances.policyversionid toolpoliacce_pol2_fk R
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_fk R

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_fk R

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

Table contained -1 rows

tool_policy_versions table indexes

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

tool_policy_versions table relationships

Close relationships within degrees of separation