← back to Nationalrealestate

db/migrations/006_commercial_briefs.sql

14 lines

-- Generated news blurbs for commercial assets (Phase 4). One short, factual
-- news-wire sentence per marquee / recently-recorded asset, produced by a LOCAL
-- LLM ($0) from the assessor facts only — never invented prices/owners/tenants.
-- Precomputed so the feed/explorer serve briefs instantly.

CREATE TABLE IF NOT EXISTS commercial_brief (
  county_fips  text NOT NULL,
  ain          text NOT NULL,
  brief        text NOT NULL,
  model        text,
  generated_at timestamptz NOT NULL DEFAULT now(),
  PRIMARY KEY (county_fips, ain)
);