Totara Learn 11
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
Goal Record Table Schema (goal_record)
Description
Track current status of a user within goals
goal_record table columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
BIGINT
19
√
null
userid
BIGINT
19
null
user
.id
goalreco_use2_fk
R
goalid
BIGINT
19
null
goal
.id
goalreco_goa2_fk
R
scalevalueid
BIGINT
19
√
null
goal_scale_values
.id
goalreco_sca2_fk
R
deleted
BIT
1
0
Showing 1 to 5 of 5 entries
Table contained
-1
rows
goal_record table indexes
Search:
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
id
goalreco_goa_ix
Performance
Asc
goalid
goalreco_sca_ix
Performance
Asc
scalevalueid
goalreco_use_ix
Performance
Asc
userid
Showing 1 to 4 of 4 entries
goal_record table relationships
Close relationships within degrees of separation
One
Two degrees
One implied
Two implied
