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.

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