Ho Ngoc Hai 47c34f129e fix(db): add LeadStatus enum, Transaction.buyerId FK, Inquiry compound index ...

- Convert Lead.status from String to LeadStatus enum (NEW, CONTACTED, QUALIFIED, NEGOTIATING, CONVERTED, LOST) with safe data migration
- Add FK constraint Transaction.buyerId -> User.id to prevent orphaned transactions
- Add compound index on Inquiry(listingId, userId) for duplicate inquiry checks

Co-Authored-By: Paperclip <noreply@paperclip.ing>

2026-04-08 13:17:24 +07:00

..

migration.sql

fix(db): add LeadStatus enum, Transaction.buyerId FK, Inquiry compound index

2026-04-08 13:17:24 +07:00