tool_policy_versions

0 rows


Description

Holds versions of the policy documents

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
tool_policy.currentversionid toolpoli_cur2_fkR
tool_policy_acceptances.policyversionid toolpoliacce_pol2_fkR
name VARCHAR 1333
type SMALLINT 5 0
audience SMALLINT 5 0
archived SMALLINT 5 0
usermodified BIGINT 19 null
user.id toolpolivers_use2_fkR
timecreated BIGINT 19 null
timemodified BIGINT 19 null
policyid BIGINT 19 null
tool_policy.id toolpolivers_pol2_fkR
agreementstyle SMALLINT 5 0
optional SMALLINT 5 0
revision VARCHAR 1333
summary LONGTEXT 2147483647 null
summaryformat SMALLINT 5 null
content LONGTEXT 2147483647 null
contentformat SMALLINT 5 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolpolivers_pol4_ix Performance Asc policyid
toolpolivers_use4_ix Performance Asc usermodified

Relationships

Close relationships within degrees of separation