Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| comic_id | bpchar | 4 | null |
|
|
||||||
| name | varchar | 32 | null |
|
|
||||||
| order_type | varchar | 9 | null |
|
|
||||||
| type | varchar | 10 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| variants_pkey | Primary key | Asc | comic_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| variants_order_type_check | (((order_type)::text = ANY ((ARRAY['CLOSED'::character varying, 'EVENT'::character varying, 'INCENTIVE'::character varying, 'OPEN'::character varying, 'RETAILER'::character varying])::text[]))) |
| variants_type_check | (((type)::text = ANY ((ARRAY['BLANK'::character varying, 'COVER'::character varying, 'CONNECTING'::character varying, 'FACSIMILE'::character varying, 'FOIL'::character varying, 'METAL'::character varying, 'SECRET'::character varying, 'VIRGIN'::character varying])::text[]))) |
Relationships
Close relationships within degrees of separation
