auto-save: 2026-07-22T07:12:00 (1 files) — db/migrations/006_commercial_briefs.sql

5de9ab3218ed7221757ef266cb95bb0705914eb3 · 2026-07-22 07:12:11 -0700 · Steve Abrams

Files touched

A db/migrations/006_commercial_briefs.sql

Diff

commit 5de9ab3218ed7221757ef266cb95bb0705914eb3
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Wed Jul 22 07:12:11 2026 -0700

    auto-save: 2026-07-22T07:12:00 (1 files) — db/migrations/006_commercial_briefs.sql
---
 db/migrations/006_commercial_briefs.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)

diff --git a/db/migrations/006_commercial_briefs.sql b/db/migrations/006_commercial_briefs.sql
new file mode 100644
index 0000000..a93c12a
--- /dev/null
+++ b/db/migrations/006_commercial_briefs.sql
@@ -0,0 +1,13 @@
+-- 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)
+);

← 0b1ee1d Wire Commercial into main site nav across all pages (discove · back to Nationalrealestate · Phase 4: generated commercial news briefs (local Ollama, $0) 04a19e4 →