Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| convention_id | bpchar | 6 | √ | √ | to_char(nextval('convention_id_seq'::regclass), '"CON-"FM00'::text) |
|
|
|
| name | varchar | 64 | null |
|
|
|||
| type | varchar | 32 | null |
|
|
|||
| start_date | date | 13 | null |
|
|
|||
| end_date | date | 13 | null |
|
|
|||
| city | varchar | 32 | null |
|
|
|||
| state | bpchar | 2 | √ | null |
|
|
||
| country | bpchar | 3 | null |
|
|
|||
| zip | bpchar | 5 | √ | null |
|
|
Check Constraints
| Constraint Name | Constraint |
|---|---|
| conventions_id_check | ((convention_id ~ 'CON-[0-9]{2}'::text)) |
| conventions_start_end_date_check | ((start_date <= end_date)) |
| conventions_zip_check | ((zip ~ '[0-9]{5}'::text)) |
| conventions_country_check | ((country ~ '[A-Z]{3}'::text)) |
| conventions_state_check | ((state ~ '[A-Z]{2}'::text)) |
| conventions_type_check | (((type)::text = ANY ((ARRAY['COMIC-CON'::character varying, 'FAN-EXPO'::character varying])::text[]))) |
Relationships
Close relationships within degrees of separation
