Returns table foreign key blocked container boot

What happened

The deploy that introduced the eBay returns surface (/orders/returns) put the new container into a crash loop. Every boot, the migrate-on-boot script tried to apply 0096_ebay_returns.sql and Postgres rejected the foreign key — the new table's user_id column was declared uuid, but the actual user table's id column is text.

Root cause

The Drizzle schema export for the user table is named users (plural), but the underlying Postgres table is "user" (singular, and a SQL reserved word). When I hand-wrote the migration SQL, I matched the export name and assumed uuid for the FK column type. Both were wrong: the table name needed quoting and the column type needed to be text.

Fix

Changed both columns from uuid to text and pushed the corrected migration. The migrate-on-boot transaction-per-migration pattern meant the failed attempt left zero state behind — the next deploy retried 0096 cleanly and the site came back.

What we learned

Before writing new schema, copy the closest existing migration file (e.g. lib/db/schema/easypost-shipments.ts) rather than typing column types from memory. The same FK pattern is repeated everywhere; the right shape was visible all along.