Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
series_id | bigserial | 19 | √ | nextval('series_series_id_seq'::regclass) |
|
|
||||||||||||
press_id | int8 | 19 | null |
|
|
|||||||||||||
review_form_id | int8 | 19 | √ | null |
|
|
||||||||||||
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 |