Goal Grp Org Table Schema (goal_grp_org)


Description

Stores the organisation assignments of goals

goal_grp_org table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
goalid BIGINT 19 null
goal.id goalgrporg_goa2_fk R
orgid BIGINT 19 null
org.id goalgrporg_org2_fk R
includechildren TINYINT 3 0
timemodified BIGINT 19 null
usermodified BIGINT 19 null

Table contained -1 rows

goal_grp_org table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
goalgrporg_goa_ix Performance Asc goalid
goalgrporg_org_ix Performance Asc orgid

goal_grp_org table relationships

Close relationships within degrees of separation