categories


Description

Categories permit the organization of submissions into a heirarchical structure.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
category_id BIGINT 19 √ null
categories.parent_id categories_parent_id_foreignN
category_settings.category_id category_settings_category_id_foreignC
publication_categories.category_id publication_categories_category_id_foreignC
context_id BIGINT 19 null
journals.journal_id categories_context_id_foreignC
parent_id BIGINT 19 √ NULL
categories.category_id categories_parent_id_foreignN
seq BIGINT 19 √ NULL
path VARCHAR 255 null
image TEXT 65535 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc category_id
category_context_id Performance Asc context_id
category_context_parent_id Performance Asc/Asc context_id + parent_id
category_parent_id Performance Asc parent_id
category_path Must be unique Asc/Asc context_id + path

Relationships

Close relationships within degrees of separation