Customer Database
PostgreSQL database that is the system of record for all customer profile data.
What is this?
The Customer Database is the authoritative store for every customer profile at Acme Inc. The Customer APICustomer APIServicev1.0.0
The public-facing API for customer profiles. Handles commands to register and update customers, serves customer reads, a...Publishescustomer-registered, customer-updatedSubscribesregister-customer, update-customer +1APIsOpenAPIOwnercustomer-platformMapRepoView docs reads from and writes to it. It stores profile data only — credentials and authentication live in the Identity ProviderIdentity ProviderSystemv1.0.0The identity system that authenticates customers. It is the source of truth for credentials and login, verifies sign-in ...Ownercustomer-platformMapView docs‘s User DirectoryUser DirectoryContainerv1.0.0The directory of customer credentials and identities — the source of truth for authentication.MapView docs, not here.
What does it store?
- Customers — one row per customer: id, email, name and account status.
Schema
-- Customer Database — system of record for customer profiles-- Note: credentials/authentication are owned by the Identity Provider, not stored here.
CREATE TABLE customers ( customer_id UUID PRIMARY KEY DEFAULT gen_random_uuid(), email TEXT NOT NULL UNIQUE, name TEXT, status TEXT NOT NULL DEFAULT 'ACTIVE' CHECK (status IN ('ACTIVE', 'SUSPENDED', 'CLOSED')), registered_at TIMESTAMPTZ NOT NULL DEFAULT now(), updated_at TIMESTAMPTZ NOT NULL DEFAULT now());
CREATE INDEX idx_customers_status ON customers (status);Access patterns
- The Customer APICustomer APIServicev1.0.0The public-facing API for customer profiles. Handles commands to register and update customers, serves customer reads, a...Publishescustomer-registered, customer-updatedSubscribesregister-customer, update-customer +1APIsOpenAPIOwnercustomer-platformMapRepoView docs is the only writer on the request path.
- No credentials or passwords are stored here — only profile data. Authentication is owned by the Identity ProviderIdentity ProviderSystemv1.0.0The identity system that authenticates customers. It is the source of truth for credentials and login, verifies sign-in ...Ownercustomer-platformMapView docs.
Classification
Customer profile data is confidential. Access is role-based and least-privilege; PII handling follows Acme’s data policies.