app_tool_sitepolicy_localised_policy

0 rows


Description

A policy in a particular language

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_tool_sitepolicy_localised_policy_id_seq'::regclass)
app_tool_sitepolicy_localised_consent.localisedpolicyid Defined in XML R
language varchar 30 ''::character varying
title varchar 1333 ''::character varying
policytext text 2147483647 √ null
policytextformat int2 5 √ 1
whatsnew text 2147483647 √ null
whatsnewformat int2 5 √ 1
timecreated int8 19 √ null
isprimary int2 5 √ null
authorid int8 19 √ null
app_user.id Defined in XML R
policyversionid int8 19 √ null
app_tool_sitepolicy_policy_version.id Defined in XML R

Indexes

Constraint Name Type Sort Column(s)
app_toolsitelocapoli_id_pk Primary key Asc id
app_toolsitelocapoli_aut_ix Performance Asc authorid
app_toolsitelocapoli_pol_ix Performance Asc policyversionid

Relationships

Close relationships within degrees of separation