Skip to content

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ộtKiểuKhoáMô tả
account_iduuidNOT NULLPK FK → accounts
pipoint_uidtextNOT NULL
ekyc_statustextNOT NULL
viatext
methodtext
verified_attimestamptz
ekyc_changed_attimestamptzekyc.changedAt of the applied status (watermark of ekyc_status / via / method / verified_at).
request_statustext
request_platformtext
reject_codetext
request_changed_attimestamptzrequest.changedAt of the applied latest request (watermark of request_status / request_platform / reject_code).
first_verified_attimestamptzSet once, at the first sync that saw verified (referral EKYC_VERIFIED, recordEkycVerified).
synced_attimestamptzNOT 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ộtKiểuKhoáMô tả
event_idtextNOT NULLPK
typetextNOT NULL
uidtextNOT NULL
occurred_attimestamptzdeletedAt (account.deleted) or changedAt (eKYC events) of the payload when PiPoint sends it.
job_slot_keytextNOT NULL
correlation_idcorrelation_refNOT NULL
received_attimestamptzNOT NULL
processed_attimestamptz
failure_codetextPPI-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ó

Sinh từ ad83b0aea · 820 migration · PostgreSQL 17