CREATE TABLE scrape_log (
    id              UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    source_name     TEXT NOT NULL,
    entity_type     TEXT NOT NULL,
    entity_id       UUID NOT NULL,
    source_url      TEXT NOT NULL,
    last_scraped_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    raw_data        JSONB
);

CREATE INDEX idx_scrape_entity ON scrape_log(entity_type, entity_id);
CREATE INDEX idx_scrape_source ON scrape_log(source_name);