Glossary Entries Table Schema (glossary_entries)


Description

all glossary entries

glossary_entries table columns

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

Table contained -1 rows

glossary_entries table indexes

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

glossary_entries table relationships

Close relationships within degrees of separation