Goal Item History Table Schema (goal_item_history)


Description

Store changes to scalevalueid in goal_record and goal_personal.

goal_item_history table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
scope BIT 1 null
itemid BIGINT 19 null
scalevalueid BIGINT 19 √ null
goal_scale_values.id goalitemhist_sca2_fk R
timemodified BIGINT 19 null
usermodified BIGINT 19 null

Table contained -1 rows

goal_item_history table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
goalitemhist_sca_ix Performance Asc scalevalueid
goalitemhist_scoite_ix Performance Asc/Asc scope + itemid

goal_item_history table relationships

Close relationships within degrees of separation