glossary_entries

0 rows


Description

all glossary entries

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
glossary_alias.entryid glosalia_ent2_fkR
glossary_entries_categories.entryid glosentrcate_ent2_fkR
glossaryid BIGINT 19 0
glossary.id glosentr_glo2_fkR
userid BIGINT 19 0
user.id Implied ConstraintR
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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
glosentr_con2_ix Performance Asc concept
glosentr_glo2_ix Performance Asc glossaryid
glosentr_use2_ix Performance Asc userid

Relationships

Close relationships within degrees of separation