DB: port schema SQLite-17 -> Postgres 17 (CHECK/FK kept, payloadJson -> jsonb, event-row invariant preserved)

Sub-tickets

Questions

Activity

• system created · 2026-05-29
  wi cli; parent=#580
• db-basquetwi-cc assigned · 2026-06-04
  assigned to db-basquetwi-cc
• system statusChanged · 2026-06-04
  Critical-path start: schema port. Ready — Postgres 17 up on whey:5432. Architecture decided (docs/utcp-digest.md). No basquetwi DB/role/schema yet; this WI creates them.
• system statusChanged · 2026-06-04
  db-basquetwi-cc started. Decisions approved: TIMESTAMPTZ, updatedAt trigger on workItems, eventType CHECK (CLAUDE.md list). Migration to be checked in at migrations/0001_init_pg.sql as SSOT for #584/#586. Est ~1h.
• system completed · 2026-06-04
  Schema port done, smoke green (cf5aec3). migrations/0001_init_pg.sql is SSOT. basquetwi DB+role on whey:5432, TIMESTAMPTZ, JSONB, eventType CHECK (14 types), updatedAt trigger, FKs+partial indexes preserved. Unblocks #584.