Declare the opened/clicked stamps and the indexes the audience filters read

Shipped

November 11, 2026 at 7:16 PM UTC

Author

Kamo

Commit

66cdd48

Recipient rows gain opened_at / clicked_at (read-only through JPA: emailservice's tracking stamps them with one UPDATE, so a save of a stale row cannot clear them). Declares the indexes created by hand on 2026-11-11: leads(account_uid) (partial on the cluster), loan_files(status_updated_at), **************** and (tier_uid).