Goal Table Schema (goal)


Description

Totara goals

goal table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
goal.parentid goal_par3_fk R
goal_grp_cohort.goalid goalgrpcoho_goa2_fk R
goal_grp_org.goalid goalgrporg_goa2_fk R
goal_grp_pos.goalid goalgrppos_goa2_fk R
goal_record.goalid goalreco_goa2_fk R
goal_type_info_data.goalid goaltypeinfodata_goa2_fk R
goal_user_assignment.goalid goaluserassi_goa2_fk R
goal_user_type_cohort.goalid goalusertypecoho_goa2_fk R
shortname VARCHAR 100 √ null
description LONGTEXT 2147483647 √ null
idnumber VARCHAR 100 √ null
frameworkid BIGINT 19 null
goal_framework.id goal_fra2_fk R
path VARCHAR 255 √ null
parentid BIGINT 19 null
goal.id goal_par3_fk R
visible TINYINT 3 null
targetdate BIGINT 19 √ null
proficiencyexpected BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
fullname VARCHAR 1024 √ null
depthlevel BIGINT 19 √ null
typeid BIGINT 19 0
goal_type.id goal_typ2_fk R
sortthread VARCHAR 255 √ null

Table contained -1 rows

goal table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
goal_fra_ix Performance Asc frameworkid
goal_par2_ix Performance Asc parentid
goal_par_ix Performance Asc parentid
goal_typ_ix Performance Asc typeid

goal table relationships

Close relationships within degrees of separation