public.schedule_overrides
| # | Name | Type | Nullable | Default | PK |
|---|---|---|---|---|---|
| 1 | id | uuid | NO | uuid_generate_v4() | PK |
| 2 | venue_id | uuid | NO | — | |
| 3 | date | date | NO | — | |
| 4 | is_closed | boolean | NO | false | |
| 5 | open_time | time without time zone | YES | — | |
| 6 | close_time | time without time zone | YES | — | |
| 7 | note_en | text | YES | — | |
| 8 | note_pl | text | YES | — | |
| 9 | note_uk | text | YES | — | |
| 10 | created_at | timestamp with time zone | NO | now() |
Indexes
| Name | Definition | Unique | Primary | Size |
|---|---|---|---|---|
| idx_schedule_overrides_date | CREATE INDEX idx_schedule_overrides_date ON public.schedule_overrides USING btree (venue_id, date) | 8192 bytes | ||
| schedule_overrides_pkey | CREATE UNIQUE INDEX schedule_overrides_pkey ON public.schedule_overrides USING btree (id) | ✓ | ✓ | 8192 bytes |
| schedule_overrides_venue_id_date_key | CREATE UNIQUE INDEX schedule_overrides_venue_id_date_key ON public.schedule_overrides USING btree (venue_id, date) | ✓ | 8192 bytes |
Constraints
| Name | Type | Definition |
|---|---|---|
| schedule_overrides_venue_id_fkey | FOREIGN KEY | FOREIGN KEY (venue_id) REFERENCES venues(id) ON DELETE CASCADE |
| schedule_overrides_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| schedule_overrides_venue_id_date_key | UNIQUE | UNIQUE (venue_id, date) |