public.scrape_logs
| # | Name | Type | Nullable | Default | PK |
|---|---|---|---|---|---|
| 1 | id | uuid | NO | uuid_generate_v4() | PK |
| 2 | venue_id | uuid | YES | — | |
| 3 | started_at | timestamp with time zone | NO | now() | |
| 4 | finished_at | timestamp with time zone | YES | — | |
| 5 | status | text | NO | 'running'::text | |
| 6 | sources_checked | jsonb | YES | '[]'::jsonb | |
| 7 | raw_response | jsonb | YES | — | |
| 8 | parsed_data | jsonb | YES | — | |
| 9 | error_message | text | YES | — | |
| 10 | duration_ms | integer | YES | — | |
| 11 | scrape_type | text | YES | 'deep'::text |
Indexes
| Name | Definition | Unique | Primary | Size |
|---|---|---|---|---|
| idx_scrape_logs_type | CREATE INDEX idx_scrape_logs_type ON public.scrape_logs USING btree (scrape_type) | 16 kB | ||
| idx_scrape_logs_venue | CREATE INDEX idx_scrape_logs_venue ON public.scrape_logs USING btree (venue_id) | 16 kB | ||
| scrape_logs_pkey | CREATE UNIQUE INDEX scrape_logs_pkey ON public.scrape_logs USING btree (id) | ✓ | ✓ | 40 kB |
Constraints
| Name | Type | Definition |
|---|---|---|
| scrape_logs_venue_id_fkey | FOREIGN KEY | FOREIGN KEY (venue_id) REFERENCES venues(id) ON DELETE SET NULL |
| scrape_logs_pkey | PRIMARY KEY | PRIMARY KEY (id) |