efrilmandClaude Opus 5.5
bf9651e221
The recipient of a transfer now gets a push through FCM instead of a
WhatsApp message (docs/prd-point-coin.md F5).
Customers had nowhere to keep FCM tokens: user_devices only holds staff
devices. Migration 000096 adds customer_devices, and the customer app
registers with PUT /customer/devices { device_id, fcm_token, platform,
app_version } after login and whenever FCM refreshes the token, and
unregisters with DELETE /customer/devices/:device_id on logout. A token
belongs to one customer only: registering it takes it away from whoever
had it on that phone before, so they stop getting this customer's
notifications.
The push goes to every device of the recipient after the commit, titled
"EnakPoint masuk" or "EnakCoin masuk", with type WALLET_TRANSFER_IN, the
TRANSFER_IN transaction id, the group id, the currency and the amount in
its data so the app can open it. A retried transfer sends nothing again. It
stays best effort: no device, FCM not configured or FCM failing is logged
and never undoes the transfer.
The app builds one FCM client and shares it between staff notifications
and customer pushes.
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
18 lines
867 B
SQL
18 lines
867 B
SQL
-- Devices of the customer app, so customers can get push notifications through FCM
|
|
-- (docs/prd-point-coin.md F5: the recipient of a transfer is notified). user_devices
|
|
-- only holds staff devices.
|
|
CREATE TABLE customer_devices (
|
|
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
|
|
customer_id UUID NOT NULL REFERENCES customers(id) ON DELETE CASCADE,
|
|
device_id VARCHAR(255) NOT NULL,
|
|
platform VARCHAR(50) CHECK (platform IN ('android', 'ios', 'web')),
|
|
fcm_token VARCHAR(512) NOT NULL,
|
|
app_version VARCHAR(50),
|
|
last_active_at TIMESTAMP WITH TIME ZONE,
|
|
created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
|
|
updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
|
|
);
|
|
|
|
CREATE UNIQUE INDEX idx_customer_devices_customer_device ON customer_devices(customer_id, device_id);
|
|
CREATE INDEX idx_customer_devices_fcm_token ON customer_devices(fcm_token);
|