Glossary Entries Categories Table Schema (glossary_entries_categories)


Description

categories of each glossary entry

glossary_entries_categories table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
categoryid BIGINT 19 0
glossary_categories.id glosentrcate_cat2_fk R
entryid BIGINT 19 0
glossary_entries.id glosentrcate_ent2_fk R

Table contained -1 rows

glossary_entries_categories table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
glosentrcate_cat_ix Performance Asc categoryid
glosentrcate_ent_ix Performance Asc entryid

glossary_entries_categories table relationships

Close relationships within degrees of separation