Giao diện
pipoint / pipoint
Trang sinh tự động
Sinh từ ad83b0aea — chạy 820 migration lên PostgreSQL 17 rồi đọc pg_catalog. Mô tả bảng và cột lấy từ COMMENT ON. Không sửa tay: lần chạy docgen sau sẽ ghi đè.
2 bảng. Quay lại pipoint.
pipoint_ekyc_snapshots
PPI-P4-01 (04 s3, D-06). PiPoint eKYC status per account from ekycPlatform-review status: no verified identity (name, ID number, birth date, address) is stored. Written only by pipoint_ekyc.sync_apply; own row readable by pi_api.
public.pipoint_ekyc_snapshots · 13 cột · 9 check · 0 unique · 2 index · 1 policy · 4 trigger · RLS bật
| Cột | Kiểu | Khoá | Mô tả | |
|---|---|---|---|---|
account_id | uuid | NOT NULL | PK FK → accounts | |
pipoint_uid | text | NOT NULL | ||
ekyc_status | text | NOT NULL | ||
via | text | |||
method | text | |||
verified_at | timestamptz | |||
ekyc_changed_at | timestamptz | ekyc.changedAt of the applied status (watermark of ekyc_status / via / method / verified_at). | ||
request_status | text | |||
request_platform | text | |||
reject_code | text | |||
request_changed_at | timestamptz | request.changedAt of the applied latest request (watermark of request_status / request_platform / reject_code). | ||
first_verified_at | timestamptz | Set once, at the first sync that saw verified (referral EKYC_VERIFIED, recordEkycVerified). | ||
synced_at | timestamptz | NOT NULL |
Khoá chính: account_id
Trỏ ra (1):
account_id→accounts
Được trỏ tới: không có
pipoint_event_receipts
PPI-P3-05 (04 s2). SYSTEM_ONLY receipt of a PiPoint account event (dedupe by eventId), one pipoint.account_event job slot each. Append-only; processed_at set once by the job. Written only by pipoint_events.receive.
public.pipoint_event_receipts · 9 cột · 7 check · 1 unique · 2 index · 0 policy · 5 trigger · RLS bật
| Cột | Kiểu | Khoá | Mô tả | |
|---|---|---|---|---|
event_id | text | NOT NULL | PK | |
type | text | NOT NULL | ||
uid | text | NOT NULL | ||
occurred_at | timestamptz | deletedAt (account.deleted) or changedAt (eKYC events) of the payload when PiPoint sends it. | ||
job_slot_key | text | NOT NULL | ||
correlation_id | correlation_ref | NOT NULL | ||
received_at | timestamptz | NOT NULL | ||
processed_at | timestamptz | |||
failure_code | text | PPI-P4-05. Set (once, with processed_at) when the eKYC status pull was refused for good: the receipt is closed without a snapshot change. Null = processed normally (or not yet). |
Khoá chính: event_id
Trỏ ra: không có
Được trỏ tới: không có