app_goal_grp_org

0 rows


Description

Stores the organisation assignments of goals

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_goal_grp_org_id_seq'::regclass)
goalid int8 19 null
app_goal.id Defined in XMLR
orgid int8 19 null
app_org.id Defined in XMLR
includechildren int2 5 0
timemodified int8 19 null
usermodified int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_goalgrporg_id_pk Primary key Asc id
app_goalgrporg_goa_ix Performance Asc goalid
app_goalgrporg_org_ix Performance Asc orgid

Relationships

Close relationships within degrees of separation