Goal Grp Cohort Table Schema (goal_grp_cohort)


Description

Stores the assignments of goals

goal_grp_cohort table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
goalid BIGINT 19 null
goal.id goalgrpcoho_goa2_fk R
cohortid BIGINT 19 null
cohort.id goalgrpcoho_coh2_fk R
timemodified BIGINT 19 null
usermodified BIGINT 19 null

Table contained -1 rows

goal_grp_cohort table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
goalgrpcoho_coh_ix Performance Asc cohortid
goalgrpcoho_goa_ix Performance Asc goalid

goal_grp_cohort table relationships

Close relationships within degrees of separation