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