t11release
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
app_tool_sitepolicy_policy_version
0
rows
Description
Record of all versions of a policy, including not yet published
Columns
Related columns
Constraint
Comments
Search:
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 XML
R
app_tool_sitepolicy_localised_policy
.policyversionid
Defined in XML
R
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 XML
R
publisherid
int8
19
√
null
app_user
.id
Defined in XML
R
Showing 1 to 7 of 7 entries
Previous
1
Next
Indexes
Search:
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
Showing 1 to 3 of 3 entries
Previous
1
Next
Relationships
Close relationships within degrees of separation
One
Two degrees
