public.venue_changes
| # | Name | Type | Nullable | Default | PK |
|---|---|---|---|---|---|
| 1 | id | uuid | NO | uuid_generate_v4() | PK |
| 2 | venue_id | uuid | NO | — | |
| 3 | field_name | text | NO | — | |
| 4 | old_value | jsonb | YES | — | |
| 5 | new_value | jsonb | YES | — | |
| 6 | detected_at | timestamp with time zone | NO | now() | |
| 7 | source | text | YES | — |
Indexes
| Name | Definition | Unique | Primary | Size |
|---|---|---|---|---|
| idx_venue_changes_date | CREATE INDEX idx_venue_changes_date ON public.venue_changes USING btree (detected_at) | 16 kB | ||
| idx_venue_changes_venue | CREATE INDEX idx_venue_changes_venue ON public.venue_changes USING btree (venue_id) | 16 kB | ||
| venue_changes_pkey | CREATE UNIQUE INDEX venue_changes_pkey ON public.venue_changes USING btree (id) | ✓ | ✓ | 16 kB |
Constraints
| Name | Type | Definition |
|---|---|---|
| venue_changes_venue_id_fkey | FOREIGN KEY | FOREIGN KEY (venue_id) REFERENCES venues(id) ON DELETE CASCADE |
| venue_changes_pkey | PRIMARY KEY | PRIMARY KEY (id) |