Add database constraint for transaction status lifecycle

[nanaf6203-bit]

Add a database-level constraint for transaction status validity.

Acceptance Criteria:

• Prisma migration adds enum or check constraint.
• Invalid status values cannot be inserted.
• Application validation remains in place.
• Tests verify database constraint enforcement.