Tool Sitepolicy Localised Policy Table Schema (tool_sitepolicy_localised_policy)


Description

A policy in a particular language

tool_sitepolicy_localised_policy table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
tool_sitepolicy_localised_consent.localisedpolicyid toolsitelocacons_loc2_fk R
language VARCHAR 30

Language of the policy
title VARCHAR 1333

Title of the policy
policytext LONGTEXT 2147483647 √ null

The contents of the policy
policytextformat TINYINT 3 √ 1

The format of the policytext field
whatsnew LONGTEXT 2147483647 √ null

Field to put what has changed since the previous version
whatsnewformat TINYINT 3 √ 1

The format of the whatsnew field
timecreated BIGINT 19 √ null

Timestamp of when the langauge version of the policy was created
isprimary BIT 1 √ null

If the localised policy is the Admin's primary version
authorid BIGINT 19 √ null
user.id toolsitelocapoli_aut2_fk R

Who wrote the localised policy
policyversionid BIGINT 19 √ null
tool_sitepolicy_policy_version.id toolsitelocapoli_pol2_fk R

Which policy the localised policy is related to

Table contained -1 rows

tool_sitepolicy_localised_policy table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolsitelocapoli_aut_ix Performance Asc authorid
toolsitelocapoli_pol_ix Performance Asc policyversionid

tool_sitepolicy_localised_policy table relationships

Close relationships within degrees of separation