app_goal_item_history

0 rows


Description

Store changes to scalevalueid in goal_record and goal_personal.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_goal_item_history_id_seq'::regclass)
scope int2 5 null
itemid int8 19 null
scalevalueid int8 19 null
app_goal_scale_values.id Defined in XMLR
timemodified int8 19 null
usermodified int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_goalitemhist_id_pk Primary key Asc id
app_goalitemhist_sca_ix Performance Asc scalevalueid
app_goalitemhist_scoite_ix Performance Asc/Asc scope + itemid

Relationships