Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| event_id | bpchar | 8 | √ | to_char(nextval('event_id_seq'::regclass), '"EVENT-"FM00'::text) |
|
|
|||||
| publisher | varchar | 16 | null |
|
|
||||||
| name | varchar | 32 | null |
|
|
||||||
| description | text | 2147483647 | null |
|
|
||||||
| start_date | date | 13 | null |
|
|
||||||
| end_date | date | 13 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| events_pkey | Primary key | Asc | event_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| events_start_date_end_date_check | ((start_date < end_date)) |
| events_event_id_check | ((event_id ~ '^EVENT-[0-9]{2}$'::text)) |
Relationships
Close relationships within degrees of separation
