glossary

0 rows


Description

all glossaries

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
glossary_categories.glossaryid gloscate_glo2_fkR
glossary_entries.glossaryid glosentr_glo2_fkR
course BIGINT 19 0
name VARCHAR 255
intro LONGTEXT 2147483647 null
introformat SMALLINT 5 0
allowduplicatedentries TINYINT 3 0
displayformat VARCHAR 50 dictionary
glossary_formats.name Defined in XMLR
mainglossary TINYINT 3 0
showspecial TINYINT 3 1
showalphabet TINYINT 3 1
showall TINYINT 3 1
allowcomments TINYINT 3 0
allowprintview TINYINT 3 1
usedynalink TINYINT 3 1
defaultapproval TINYINT 3 1
approvaldisplayformat VARCHAR 50 default

Display Format when approving entries
globalglossary TINYINT 3 0
entbypage SMALLINT 5 10
editalways TINYINT 3 0
rsstype TINYINT 3 0
rssarticles TINYINT 3 0
assessed BIGINT 19 0
assesstimestart BIGINT 19 0
assesstimefinish BIGINT 19 0
scale BIGINT 19 0
timecreated BIGINT 19 0
timemodified BIGINT 19 0
completionentries INT 10 0

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

Indexes

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

Relationships

Close relationships within degrees of separation