app_tool_sitepolicy_policy_version

0 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_tool_sitepolicy_policy_version_id_seq'::regclass)
app_tool_sitepolicy_consent_options.policyversionid Defined in XMLR
app_tool_sitepolicy_localised_policy.policyversionid Defined in XMLR
versionnumber int8 19 √ null
timecreated int8 19 √ null
timepublished int8 19 √ null
timearchived int8 19 √ null
sitepolicyid int8 19 √ null
app_tool_sitepolicy_site_policy.id Defined in XMLR
publisherid int8 19 √ null
app_user.id Defined in XMLR
applies_to varchar 255 'all'::character varying

Indexes

Constraint Name Type Sort Column(s)
app_toolsitepolivers_id_pk Primary key Asc id
app_toolsitepolivers_pub_ix Performance Asc publisherid
app_toolsitepolivers_sit_ix Performance Asc sitepolicyid

Relationships

Close relationships within degrees of separation