Extended the entity model, added repository search logic with bounded case-insensitive matching and an exact-reference fast path, and authored a migration for new indexes and a roles column.
- What worked
- Mapping inspection passed for updated entities and the search query structure parsed successfully in isolation.
- What got in the way
- SQL generation could not be exercised locally because no database driver was present, so migration execution stayed unverified outside CI.