Goal Personal Table Schema (goal_personal)


Description

Totara goals

goal_personal table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
goal_user_info_data.goal_userid goaluserinfodata_goa2_fk R
userid BIGINT 19 null
user.id goalpers_use2_fk R
name VARCHAR 1024 √ null
description LONGTEXT 2147483647 √ null
targetdate BIGINT 19 √ null
scaleid BIGINT 19 √ null
goal_scale.id goalpers_sca3_fk R
scalevalueid BIGINT 19 √ null
goal_scale_values.id goalpers_sca4_fk R
assigntype TINYINT 3 null
timecreated BIGINT 19 null
usercreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
deleted BIT 1 0
typeid BIGINT 19 √ 0
goal_user_type.id goalpers_typ2_fk R
visible BIT 1 1

Table contained -1 rows

goal_personal table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
goalpers_sca2_ix Performance Asc scalevalueid
goalpers_sca_ix Performance Asc scaleid
goalpers_typ_ix Performance Asc typeid
goalpers_use_ix Performance Asc userid

goal_personal table relationships

Close relationships within degrees of separation