From 684e4306a08feeae188070f264148e6765da8dcf Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期日, 20 九月 2026 19:25:15 +0800
Subject: [PATCH] feat(account): 更新往来付款回款流水表及接口
---
doc/20260920_create_payment_record.sql | 8 +++++---
1 files changed, 5 insertions(+), 3 deletions(-)
diff --git a/doc/20260920_create_payment_record.sql b/doc/20260920_create_payment_record.sql
index 12056c2..a39e2ef 100644
--- a/doc/20260920_create_payment_record.sql
+++ b/doc/20260920_create_payment_record.sql
@@ -1,11 +1,13 @@
# 寰�鏉ヤ粯娆惧洖娆炬祦姘磋〃
-# 瀹㈡埛寰�鏉ュ彇 party_type=1 and direction=1 浣滀负銆屼粯娆俱�嶅垪
-# 渚涘簲鍟嗗線鏉ュ彇 party_type=2 and direction=2 浣滀负銆屽洖娆俱�嶅垪
+# 瀹㈡埛寰�鏉ュ彇 party_type=1 and direction=1 浣滀负銆屽洖娆俱�嶅垪锛堣繑鍥炲瓧娈� receiptRecordAmount锛�
+# 渚涘簲鍟嗗線鏉ュ彇 party_type=2 and direction=2 浣滀负銆屼粯娆俱�嶅垪锛堣繑鍥炲瓧娈� paymentRecordAmount锛�
+# 娉ㄦ剰锛歞irection 鍙栧�兼寜椤甸潰鍥哄畾锛屼笉瑕佹寜涓嬮潰 搂鏂瑰悜 鐨勫瓧闈紙1浠樻 2鍥炴锛夊幓閫�
+# 鍚堜綔鍟嗗線鏉ュ彇 party_type=3 and direction=1 浣滀负銆屽凡浠樻銆嶅垪
drop table if exists payment_record;
create table payment_record
(
id bigint auto_increment primary key,
- party_type tinyint not null comment '寰�鏉ユ柟绫诲瀷 1瀹㈡埛 2渚涘簲鍟�',
+ party_type tinyint not null comment '寰�鏉ユ柟绫诲瀷 1瀹㈡埛 2渚涘簲鍟� 3鍚堜綔鍟�',
party_id bigint not null comment '瀹㈡埛id鎴栦緵搴斿晢id',
direction tinyint not null comment '鏂瑰悜 1浠樻 2鍥炴',
amount decimal(18, 2) not null default 0 comment '閲戦',
--
Gitblit v1.9.3