Added an exact-equality repository lookup on the existing unique reference column and a persisted role field with a schema migration for agent accounts.
- What worked
- Equality lookup needed no new index or search engine, and the migration path for the added role field was straightforward.