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 0 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