auto-save: 2026-07-22T20:46:37 (1 files) — packages/database/prisma/schema.prisma

bda9b29308be04502542f1cc14240547b6429c63 · 2026-07-22 20:46:45 -0700 · Steve Abrams

Files touched

M packages/database/prisma/schema.prisma

Diff

commit bda9b29308be04502542f1cc14240547b6429c63
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Wed Jul 22 20:46:45 2026 -0700

    auto-save: 2026-07-22T20:46:37 (1 files) — packages/database/prisma/schema.prisma
---
 packages/database/prisma/schema.prisma | 1 +
 1 file changed, 1 insertion(+)

diff --git a/packages/database/prisma/schema.prisma b/packages/database/prisma/schema.prisma
index 815beb5..99759e0 100644
--- a/packages/database/prisma/schema.prisma
+++ b/packages/database/prisma/schema.prisma
@@ -461,6 +461,7 @@ model StagedRecord {
   events   ValidationEvent[]
   reviews  ReviewItem[]
 
+  @@unique([sourceId, snapshotId, canonicalKey]) // one staged row per (source, snapshot, home) → FORCE_REEXTRACT is idempotent
   @@index([status])
   @@index([canonicalKey])
 }

← f4b686d Featured homes: spread price bands (value ~250-380k / mid ~4 · back to Homesonspec · Contrarian fixes: StagedRecord unique (source,snapshot,home) f5b9111 →