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