← back to Ventura Corridor

db/migrations/003_chamber_memberships.sql

9 lines

-- Add chamber_memberships JSONB to business_enrichment.
-- Shape: { "Calabasas Chamber": { joined_via: "directory_scrape", url: "...", scraped_at: "..." }, ... }
-- Merge semantics in code (jsonb || jsonb) so re-runs add new chambers without nuking existing ones.
ALTER TABLE business_enrichment
  ADD COLUMN IF NOT EXISTS chamber_memberships JSONB;

CREATE INDEX IF NOT EXISTS idx_enrichment_chambers
  ON business_enrichment USING gin (chamber_memberships);