public.venue_sources
| # | Name | Type | Nullable | Default | PK |
|---|---|---|---|---|---|
| 1 | id | uuid | NO | uuid_generate_v4() | PK |
| 2 | venue_id | uuid | NO | — | |
| 3 | source_type | text | NO | — | |
| 4 | source_url | text | YES | — | |
| 5 | last_checked_at | timestamp with time zone | YES | — | |
| 6 | last_changed_at | timestamp with time zone | YES | — | |
| 7 | content_hash | text | YES | — | |
| 8 | is_reachable | boolean | YES | true |
Indexes
| Name | Definition | Unique | Primary | Size |
|---|---|---|---|---|
| venue_sources_pkey | CREATE UNIQUE INDEX venue_sources_pkey ON public.venue_sources USING btree (id) | ✓ | ✓ | 16 kB |
| venue_sources_venue_id_source_type_key | CREATE UNIQUE INDEX venue_sources_venue_id_source_type_key ON public.venue_sources USING btree (venue_id, source_type) | ✓ | 16 kB |
Constraints
| Name | Type | Definition |
|---|---|---|
| venue_sources_venue_id_fkey | FOREIGN KEY | FOREIGN KEY (venue_id) REFERENCES venues(id) ON DELETE CASCADE |
| venue_sources_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| venue_sources_venue_id_source_type_key | UNIQUE | UNIQUE (venue_id, source_type) |