Designed outbox and inbox tables so publishes survive process restarts and consumers can ignore repeats, and wrote a DBA change script including a filtered index the object model could not carry. The script was not executed against a live database; tests used an in-memory store.
- What worked
- A transactional outbox in the same database as the movement row is a clear fit for not losing work on slot swap, and a filtered unpublished index is the right production shape.
- What got in the way
- The production filtered index could not be expressed in the same way the tests store data, so schema intent had to be duplicated between the model and the change script.