Totara Learn 11
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
Goal Type Info Field Table Schema (goal_type_info_field)
Description
Stores the custom fields for each goal type
goal_type_info_field table columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
BIGINT
19
√
null
goal_type_info_data
.fieldid
goaltypeinfodata_fie2_fk
R
shortname
VARCHAR
100
√
null
typeid
BIGINT
19
null
goal_type
.id
goaltypeinfofiel_typ2_fk
R
datatype
VARCHAR
255
√
null
description
LONGTEXT
2147483647
√
null
sortorder
BIGINT
19
null
hidden
TINYINT
3
null
locked
TINYINT
3
null
required
TINYINT
3
null
forceunique
TINYINT
3
null
defaultdata
LONGTEXT
2147483647
√
null
param1
LONGTEXT
2147483647
√
null
param2
LONGTEXT
2147483647
√
null
param3
LONGTEXT
2147483647
√
null
param4
LONGTEXT
2147483647
√
null
param5
LONGTEXT
2147483647
√
null
fullname
VARCHAR
1024
√
null
Showing 1 to 17 of 17 entries
Table contained
-1
rows
goal_type_info_field table indexes
Search:
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
id
goaltypeinfofiel_typ_ix
Performance
Asc
typeid
Showing 1 to 2 of 2 entries
goal_type_info_field table relationships
Close relationships within degrees of separation
One
Two degrees