Subscribe capture creation to update denormalized data

Subscribe event/queue: `capture-created` and trigger the database update for the denormalized data table.

The final goal: a unit test that mocks the event and checks the database update SQL

Locate the event/queue subscription for `capture-created` and the code that updates the denormalized data table. Add the requested unit test by mocking the event and checking the database update SQL; done means the event triggers the expected update and the test passes.

Written by the indexing model from the issue text.