series


Description

A list of press series, into which submissions can be organized.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
series_id BIGINT 19 √ null
metrics_series.series_id metrics_series_series_id_foreignC
publications.series_id publications_series_idN
series_categories.series_id series_categories_series_idC
series_settings.series_id series_settings_series_idC
usage_stats_total_temporary_records.series_id ust_series_id_foreignC
press_id BIGINT 19 null
presses.press_id series_press_idC
review_form_id BIGINT 19 √ NULL
review_forms.review_form_id series_review_form_idN
seq DOUBLE 8,2 √ 0.00
featured SMALLINT 5 0
editor_restricted SMALLINT 5 0
path VARCHAR 255 null
image TEXT 65535 √ NULL
is_inactive SMALLINT 5 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc series_id
series_path Must be unique Asc/Asc press_id + path
series_press_id Performance Asc press_id
series_review_form_id Performance Asc review_form_id

Relationships

Close relationships within degrees of separation