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 10 null
glossary_alias.entryid glosalia_ent2_fk R
glossary_entries_categories.entryid glosentrcate_ent2_fk R
glossaryid bigint 10 0
glossary.id glosentr_glo2_fk R
userid bigint 10 0
user.id Implied Constraint R
concept varchar 255
definition longtext 2147483647 null
definitionformat tinyint 2 0
definitiontrust tinyint 2 0
attachment varchar 100
timecreated bigint 10 0
timemodified bigint 10 0
teacherentry tinyint 2 0
sourceglossaryid bigint 10 0
usedynalink tinyint 2 1
casesensitive tinyint 2 0
fullmatch tinyint 2 1
approved tinyint 2 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