# Pending schema changes (to be folded into the next generated migration)

Applied locally with `drizzle-kit push`; regenerate one migration at integration with `pnpm db:generate`.

## packages/database/src/schema/ingestion.ts — `normalized_records`
- **added** `seq integer not null default 0` — position of the record within `normalize(raw)` output (one raw row commonly yields a catalog item + several price observations).
- **changed** unique index `normalized_records_raw_uq`: `(raw_record_id)` → `(raw_record_id, kind, seq)`.

## Notes
- No other table/column changes were needed by the pipeline; the `assets_title_trgm` GIN index declared in the schema was missing from the local DB and got created by the push (it is already in migration 0000).
- pg-boss creates and manages its own schema `pgboss` at worker start (not part of Drizzle migrations).