From 05a5ac6f4fc67ee9445c2a8a7ed4dd8c67c8195c Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期二, 03 六月 2025 15:42:21 +0800
Subject: [PATCH] 1.煤质 2.其他优化
---
basic-server/src/main/resources/db/migration/postgresql/V20250530152701__create_table_supply.sql | 15 +++++++++------
1 files changed, 9 insertions(+), 6 deletions(-)
diff --git a/basic-server/src/main/resources/db/migration/postgresql/V20250530152701__create_table_supply.sql b/basic-server/src/main/resources/db/migration/postgresql/V20250530152701__create_table_supply.sql
index a4f4916..314bed4 100644
--- a/basic-server/src/main/resources/db/migration/postgresql/V20250530152701__create_table_supply.sql
+++ b/basic-server/src/main/resources/db/migration/postgresql/V20250530152701__create_table_supply.sql
@@ -10,9 +10,12 @@
bank_name VARCHAR(255) NOT NULL DEFAULT '', -- 寮�鎴疯
contact_person VARCHAR(255) NOT NULL DEFAULT '', -- 鑱旂郴浜�
contact_address VARCHAR(255) NOT NULL DEFAULT '', -- 鑱旂郴鍦板潃
- province_id BIGINT NOT NULL DEFAULT 0,
- city_id BIGINT NOT NULL DEFAULT 0,
- district_id BIGINT NOT NULL DEFAULT 0,
+ b_province_id BIGINT NOT NULL DEFAULT 0, -- 缁忚惀鍦板潃鐪乮d
+ b_city_id BIGINT NOT NULL DEFAULT 0, -- 缁忚惀鍦板潃甯俰d
+ b_district_id BIGINT NOT NULL DEFAULT 0, -- 缁忚惀鍦板潃鍖篿d
+ c_province_id BIGINT NOT NULL DEFAULT 0, -- 鑱旂郴鍦板潃鐪乮d
+ c_city_id BIGINT NOT NULL DEFAULT 0, -- 鑱旂郴鍦板潃甯俰d
+ c_district_id BIGINT NOT NULL DEFAULT 0, -- 鑱旂郴鍦板潃鍖篿d
deleted int4 NOT NULL DEFAULT 0, -- 鏄惁鍒犻櫎锛堣蒋鍒犻櫎鏍囧織锛�
create_by VARCHAR(255), -- 鍒涘缓浜�
create_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, -- 鍒涘缓鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂�
@@ -48,13 +51,13 @@
COMMENT ON COLUMN supply.contact_address IS '渚涘簲鍟嗚仈绯讳汉鐨勮仈绯诲湴鍧�';
-- 鐪佷唤ID锛堥粯璁�0锛岄潪绌猴紝鍏宠仈鍦板潃瀛楀吀锛�
-COMMENT ON COLUMN supply.province_id IS '渚涘簲鍟嗘墍鍦ㄧ渷浠界殑ID锛堝叧鑱斿湴鍧�瀛楀吀琛級锛岄粯璁�0';
+COMMENT ON COLUMN supply.b_province_id IS '渚涘簲鍟嗘墍鍦ㄧ渷浠界殑ID锛堝叧鑱斿湴鍧�瀛楀吀琛級锛岄粯璁�0';
-- 鍩庡競ID锛堥粯璁�0锛岄潪绌猴紝鍏宠仈鍦板潃瀛楀吀锛�
-COMMENT ON COLUMN supply.city_id IS '渚涘簲鍟嗘墍鍦ㄥ煄甯傜殑ID锛堝叧鑱斿湴鍧�瀛楀吀琛級锛岄粯璁�0';
+COMMENT ON COLUMN supply.b_city_id IS '渚涘簲鍟嗘墍鍦ㄥ煄甯傜殑ID锛堝叧鑱斿湴鍧�瀛楀吀琛級锛岄粯璁�0';
-- 鍖哄幙ID锛堥粯璁�0锛岄潪绌猴紝鍏宠仈鍦板潃瀛楀吀锛�
-COMMENT ON COLUMN supply.district_id IS '渚涘簲鍟嗘墍鍦ㄥ尯鍘跨殑ID锛堝叧鑱斿湴鍧�瀛楀吀琛級锛岄粯璁�0锛岀敤浜庡湴鍧�灞傜骇鍒掑垎';
+COMMENT ON COLUMN supply.b_district_id IS '渚涘簲鍟嗘墍鍦ㄥ尯鍘跨殑ID锛堝叧鑱斿湴鍧�瀛楀吀琛級锛岄粯璁�0锛岀敤浜庡湴鍧�灞傜骇鍒掑垎';
COMMENT ON COLUMN supply.deleted IS '杞垹闄ゆ爣蹇楋紝true琛ㄧず宸插垹闄�';
COMMENT ON COLUMN supply.create_by IS '鍒涘缓浜虹敤鎴峰悕';
--
Gitblit v1.9.3