Glossary Table Schema (glossary)


Description

all glossaries

glossary table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
glossary_categories.glossaryid gloscate_glo2_fk R
glossary_entries.glossaryid glosentr_glo2_fk R
course bigint 10 0
name varchar 255
intro longtext 2147483647 null
introformat smallint 4 0
allowduplicatedentries tinyint 2 0
displayformat varchar 50 dictionary
mainglossary tinyint 2 0
showspecial tinyint 2 1
showalphabet tinyint 2 1
showall tinyint 2 1
allowcomments tinyint 2 0
allowprintview tinyint 2 1
usedynalink tinyint 2 1
defaultapproval tinyint 2 1
approvaldisplayformat varchar 50 default

Display Format when approving entries

globalglossary tinyint 2 0
entbypage smallint 3 10
editalways tinyint 2 0
rsstype tinyint 2 0
rssarticles tinyint 2 0
assessed bigint 10 0
assesstimestart bigint 10 0
assesstimefinish bigint 10 0
scale bigint 10 0
timecreated bigint 10 0
timemodified bigint 10 0
completionentries int 9 0

Non zero if a certain number of entries are required to mark this glossary complete for a user.

Table contained -1 rows

glossary table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
glos_cou_ix Performance Asc course

glossary table relationships