container
Loyalty Database
PostgreSQL database that holds the loyalty points ledger and each customer's points balance.
Databasepostgres@16Residency: eu-west-1Retention: 7yAccess Mode: readWrite
What is this?
The Loyalty Database is the authoritative store for loyalty points. The Loyalty ServiceLoyalty ServiceServicev1.0.0
Awards loyalty points when orders complete and reverses them when orders are cancelled. Owns the points ledger and custo...Publishesloyalty-points-earned, loyalty-points-reversedSubscribesorder-completed, order-cancelledOwnercustomer-platformMapRepoView docs appends a ledger entry for every award or reversal and keeps a running balance per customer.
What does it store?
- Points ledger — one row per award or reversal, linked to the order that caused it.
- Balances — current points balance and tier per customer.