container
Returns Database
PostgreSQL database that is the system of record for return requests and their status.
Databasepostgres@16Residency: eu-west-1Retention: 7yAccess Mode: readWrite
What is this?
The Returns Database stores every return request. The Returns APIReturns APIServicev1.0.0Public API customers use to start a return. Validates the request against the original order and records it.
Publishesreturn-requestedSubscribesrequest-returnOwnerfulfilment-platformMapRepoView docs writes new requests, and the Returns ProcessorReturns ProcessorServicev1.0.0
Applies the returns policy to new requests and tracks returned parcels until they arrive back at the warehouse.
Publishesreturn-approved, return-receivedSubscribesreturn-requestedOwnerfulfilment-platformMapRepoView docs reads them and records approval and receipt.
What does it store?
- Returns — one row per return: order, customer, reason and status (
requested,approved,received). - Return items — SKUs, quantities and inspected condition.