series

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
series_id bigserial 19 √ nextval('series_series_id_seq'::regclass)
metrics_series.series_id metrics_series_series_id_foreignC
publications.series_id publications_series_idC
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 int8 19 null
presses.press_id series_press_idC
review_form_id int8 19 √ null
review_forms.review_form_id series_review_form_idN
seq float8 17,17 √ '0'::double precision
featured int2 5 '0'::smallint
editor_restricted int2 5 '0'::smallint
path varchar 255 null
image text 2147483647 √ null
is_inactive int2 5 '0'::smallint

Indexes

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