categories

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
category_id bigserial 19 √ nextval('categories_category_id_seq'::regclass)
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
series_categories.category_id series_categories_category_idC
context_id int8 19 null
presses.press_id categories_context_id_foreignC
parent_id int8 19 √ null
categories.category_id categories_parent_id_foreignN
seq int8 19 √ null
path varchar 255 null
image text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
categories_pkey 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