Tool Sitepolicy Policy Version Table Schema (tool_sitepolicy_policy_version)


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

The id of the policy

publisherid BIGINT 19 null 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