Skip to content

pipoint / rank_adjustments ​

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 đè.

1 bảng. Quay lại pipoint.

rank_adjustments ​

PPI-P5-07 (W-03 b). Maker/checker rank-only debit of a customer: never sent to PiPoint, no point_requests row. APPROVED writes one SIGNED rank_debits row (source_rank_adjustment_id). No delete; decided rows never change.

public.rank_adjustments · 18 cột · 10 check · 0 unique · 5 index · 1 policy · 6 trigger · RLS bật

CộtKiểuKhoáMô tả
iduuidNOT NULLPK
account_iduuidNOT NULLFK → accounts
pointsintegerNOT NULL
reason_codetextNOT NULL
reason_texttextNOT NULL
evidence_media_idsuuid[]NOT NULL
source_adjustment_iduuidFK → point_adjustments
payload_hashbyteaNOT NULL
statustextNOT NULL
requested_byuuidFK → accountsPPI-P5-07 maker (operations, F-06). NULL = made by the system for a refused return-recall slip (PPI-P5-09, E-09d).
requested_attimestamptzNOT NULL
decided_byuuidFK → accounts
decided_attimestamptz
decision_notetext
correlation_idcorrelation_refNOT NULL
created_attimestamptzNOT NULL
updated_attimestamptzNOT NULL
versionintegerNOT NULL

Khoá chính: id

Trỏ ra (4):

  • account_id → accounts · ON DELETE RESTRICT
  • decided_by → accounts · ON DELETE RESTRICT
  • requested_by → accounts · ON DELETE RESTRICT
  • source_adjustment_id → point_adjustments · ON DELETE RESTRICT

Được trỏ tới (1): rank_debits

Sinh từ ad83b0aea · 820 migration · PostgreSQL 17