Tool Sitepolicy Policy Version Table Schema (tool_sitepolicy_policy_version)


Description

Record of all versions of a policy, including not yet published

tool_sitepolicy_policy_version table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
tool_sitepolicy_consent_options.policyversionid toolsiteconsopti_pol2_fk R
tool_sitepolicy_localised_policy.policyversionid toolsitelocapoli_pol2_fk R
versionnumber BIGINT 19 √ null

Version number of the policy
timecreated BIGINT 19 √ null

Timestamp of when the policy version was created
timepublished BIGINT 19 √ null

Timestamp of when the policy was published
timearchived BIGINT 19 √ null

Timestamp of when the policy was archived
sitepolicyid BIGINT 19 √ null
tool_sitepolicy_site_policy.id toolsitepolivers_sit2_fk R

The id of the policy
publisherid BIGINT 19 √ null
user.id toolsitepolivers_pub2_fk R

Who published the policy

Table contained -1 rows

tool_sitepolicy_policy_version table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolsitepolivers_pub_ix Performance Asc publisherid
toolsitepolivers_sit_ix Performance Asc sitepolicyid

tool_sitepolicy_policy_version table relationships

Close relationships within degrees of separation