Totara Learn 12
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
Glossary Entries Table Schema (glossary_entries)
Description
all glossary entries
glossary_entries table columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
BIGINT
19
√
null
glossary_alias
.entryid
glosalia_ent2_fk
R
glossary_entries_categories
.entryid
glosentrcate_ent2_fk
R
glossaryid
BIGINT
19
0
glossary
.id
glosentr_glo2_fk
R
userid
BIGINT
19
0
user
.id
Implied Constraint
R
concept
VARCHAR
255
definition
LONGTEXT
2147483647
null
definitionformat
TINYINT
3
0
definitiontrust
TINYINT
3
0
attachment
VARCHAR
100
timecreated
BIGINT
19
0
timemodified
BIGINT
19
0
teacherentry
TINYINT
3
0
sourceglossaryid
BIGINT
19
0
usedynalink
TINYINT
3
1
casesensitive
TINYINT
3
0
fullmatch
TINYINT
3
1
approved
TINYINT
3
1
Showing 1 to 16 of 16 entries
Table contained
-1
rows
glossary_entries table indexes
Search:
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
id
glosentr_con_ix
Performance
Asc
concept
glosentr_glo_ix
Performance
Asc
glossaryid
glosentr_use_ix
Performance
Asc
userid
Showing 1 to 4 of 4 entries
glossary_entries table relationships
Close relationships within degrees of separation
One
Two degrees
One implied
Two implied
