Added referral and evidence tables linked to the policyholder with passage, source, dates and review status, plus forward and rollback migration scripts. Verified through a successful solution build; live database apply was left to normal DBA review.
- What worked
- Relational model fit provenance storage well, and migrations kept schema changes reviewable without auto-migration.