Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| series_id | bpchar | 5 | √ | to_char(nextval('series_id_seq'::regclass), '"S"-FM000'::text) |
|
|
||||||||
| publisher | varchar | 32 | null |
|
|
|||||||||
| imprint | varchar | 32 | √ | null |
|
|
||||||||
| name | varchar | 64 | null |
|
|
|||||||||
| type | varchar | 8 | null |
|
|
|||||||||
| volume | int4 | 10 | null |
|
|
|||||||||
| age | varchar | 8 | CASE WHEN (start_year < 1938) THEN 'PLATINUM'::text WHEN (start_year < 1956) THEN 'GOLDEN'::text WHEN (start_year < 1970) THEN 'SILVER'::text WHEN (start_year < 1985) THEN 'BRONZE'::text ELSE 'MODERN'::text END |
|
|
|||||||||
| start_year | int4 | 10 | null |
|
|
|||||||||
| end_year | int4 | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| series_pkey | Primary key | Asc | series_id |
| series_unique_key | Must be unique | Asc/Asc/Asc/Asc | publisher + imprint + name + volume |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| series_type_check | (((type)::text = ANY ((ARRAY['COLLECTION'::character varying, 'LIMITED'::character varying, 'ONE-SHOT'::character varying, 'REGULAR'::character varying])::text[]))) |
| series_series_id_check | ((series_id ~ '^S-[0-9]{3}$'::text)) |
| series_start_year_end_year_check | (((start_year > 0) AND (end_year >= start_year))) |
| series_volume_check | ((volume > 0)) |
Relationships
Close relationships within degrees of separation
