# 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).