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_pol2_ix Performance Asc policyid
toolpolivers_use2_ix Performance Asc usermodified

Relationships

Close relationships within degrees of separation