publication_categories


Description

Associates publications (and thus submissions) with categories.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
publication_category_id BIGINT UNSIGNED 20 null
publication_id BIGINT 19 null
publications.publication_id publication_categories_publication_id_foreignC
category_id BIGINT 19 null
categories.category_id publication_categories_category_id_foreignC

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc publication_category_id
publication_categories_category_id Performance Asc category_id
publication_categories_id Must be unique Asc/Asc publication_id + category_id
publication_categories_publication_id Performance Asc publication_id

Relationships