Tool Policy Table Schema (tool_policy)


Description

Contains the list of policy documents defined on the site.

tool_policy table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
tool_policy_versions.policyid toolpolivers_pol2_fk R
sortorder MEDIUMINT 7 999

Defines the order in which policies should be presented to users
currentversionid BIGINT 19 √ null
tool_policy_versions.id toolpoli_cur2_fk R

ID of the current policy version that applies on the site, NULL if the policy does not apply

Table contained -1 rows

tool_policy table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolpoli_cur_ix Performance Asc currentversionid

tool_policy table relationships

Close relationships within degrees of separation