public.events
| # | Name | Type | Nullable | Default | PK |
|---|---|---|---|---|---|
| 1 | id | uuid | NO | uuid_generate_v4() | PK |
| 2 | venue_id | uuid | NO | — | |
| 3 | title_en | text | NO | — | |
| 4 | title_pl | text | YES | — | |
| 5 | title_uk | text | YES | — | |
| 6 | description_en | text | YES | — | |
| 7 | description_pl | text | YES | — | |
| 8 | description_uk | text | YES | — | |
| 9 | date | date | NO | — | |
| 10 | start_time | time without time zone | NO | — | |
| 11 | end_time | time without time zone | YES | — | |
| 12 | is_recurring | boolean | NO | false | |
| 13 | recurrence_rule | text | YES | — | |
| 14 | image_url | text | YES | — | |
| 15 | source_url | text | YES | — | |
| 16 | created_at | timestamp with time zone | NO | now() | |
| 17 | updated_at | timestamp with time zone | NO | now() |
Indexes
| Name | Definition | Unique | Primary | Size |
|---|---|---|---|---|
| events_pkey | CREATE UNIQUE INDEX events_pkey ON public.events USING btree (id) | ✓ | ✓ | 16 kB |
| idx_events_date | CREATE INDEX idx_events_date ON public.events USING btree (date) | 16 kB | ||
| idx_events_venue | CREATE INDEX idx_events_venue ON public.events USING btree (venue_id) | 16 kB |
Constraints
| Name | Type | Definition |
|---|---|---|
| events_venue_id_fkey | FOREIGN KEY | FOREIGN KEY (venue_id) REFERENCES venues(id) ON DELETE CASCADE |
| events_pkey | PRIMARY KEY | PRIMARY KEY (id) |