Goal Record Table Schema (goal_record)


Description

Track current status of a user within goals

goal_record table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
userid BIGINT 19 null
user.id goalreco_use2_fk R
goalid BIGINT 19 null
goal.id goalreco_goa2_fk R
scalevalueid BIGINT 19 √ null
goal_scale_values.id goalreco_sca2_fk R
deleted BIT 1 0

Table contained -1 rows

goal_record table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
goalreco_goa_ix Performance Asc goalid
goalreco_sca_ix Performance Asc scalevalueid
goalreco_use_ix Performance Asc userid

goal_record table relationships

Close relationships within degrees of separation