Goal Grp Pos Table Schema (goal_grp_pos)


Description

Stores the position assignments of goals

goal_grp_pos table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
goalid BIGINT 19 null
goal.id goalgrppos_goa2_fk R
posid BIGINT 19 null
pos.id goalgrppos_pos2_fk R
includechildren TINYINT 3 0
timemodified BIGINT 19 null
usermodified BIGINT 19 null

Table contained -1 rows

goal_grp_pos table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
goalgrppos_goa_ix Performance Asc goalid
goalgrppos_pos_ix Performance Asc posid

goal_grp_pos table relationships

Close relationships within degrees of separation