Totara Learn 12
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
Goal Scale Table Schema (goal_scale)
Description
Scale represents the different levels of achievement of a goal
goal_scale table columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
BIGINT
19
√
null
goal_personal
.scaleid
goalpers_sca3_fk
R
goal_scale_assignments
.scaleid
goalscalassi_sca2_fk
R
goal_scale_values
.scaleid
goalscalvalu_sca2_fk
R
name
VARCHAR
255
√
null
description
LONGTEXT
2147483647
√
null
timemodified
BIGINT
19
null
usermodified
BIGINT
19
null
defaultid
BIGINT
19
√
null
goal_scale_values
.id
goalscal_def2_fk
R
Showing 1 to 6 of 6 entries
Table contained
-1
rows
goal_scale table indexes
Search:
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
id
goalscal_def_ix
Performance
Asc
defaultid
Showing 1 to 2 of 2 entries
goal_scale table relationships
Close relationships within degrees of separation
One
Two degrees