app_goal_record

0 rows


Description

Track current status of a user within goals

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_goal_record_id_seq'::regclass)
userid int8 19 null
app_user.id Defined in XMLR
goalid int8 19 null
app_goal.id Defined in XMLR
scalevalueid int8 19 null
app_goal_scale_values.id Defined in XMLR
deleted int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_goalreco_id_pk Primary key Asc id
app_goalreco_goa_ix Performance Asc goalid
app_goalreco_sca_ix Performance Asc scalevalueid
app_goalreco_use_ix Performance Asc userid

Relationships