From 388bd216d4eb70b367ada95118d1087b45f07ae3 Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期一, 09 六月 2025 17:53:48 +0800
Subject: [PATCH] 1.煤质部分 2.代入库部分
---
basic-server/src/main/resources/db/migration/postgresql/V20250530152701__create_table_supply.sql | 43 +++++++++++++++++++++++++++----------------
1 files changed, 27 insertions(+), 16 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 e96683a..5b006fb 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
@@ -3,17 +3,25 @@
CREATE TABLE supply
(
id BIGSERIAL PRIMARY KEY,
- supplier_name VARCHAR(255) NOT NULL, -- 渚涘簲鍟嗗悕绉�
- taxpayer_id VARCHAR(255) NOT NULL, -- 绾崇◣浜鸿瘑鍒彿
- business_address VARCHAR(255) NOT NULL DEFAULT '', -- 缁忚惀鍦板潃
- bank_account VARCHAR(255) NOT NULL DEFAULT '', -- 閾惰璐﹀彿
- 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,
- create_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP -- 鑷姩濉厖鍒涘缓鏃堕棿
+ supplier_name VARCHAR(255) NOT NULL, -- 渚涘簲鍟嗗悕绉�
+ taxpayer_id VARCHAR(255) NOT NULL, -- 绾崇◣浜鸿瘑鍒彿
+ business_address VARCHAR(255) NOT NULL DEFAULT '', -- 缁忚惀鍦板潃
+ bank_account VARCHAR(255) NOT NULL DEFAULT '', -- 閾惰璐﹀彿
+ bank_name VARCHAR(255) NOT NULL DEFAULT '', -- 寮�鎴疯
+ contact_person VARCHAR(255) NOT NULL DEFAULT '', -- 鑱旂郴浜�
+ contact_address VARCHAR(255) NOT NULL DEFAULT '', -- 鑱旂郴鍦板潃
+ 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, -- 鍒涘缓鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂�
+ update_by VARCHAR(255), -- 鏈�鍚庢洿鏂颁汉
+ update_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿
+ contact_phone VARCHAR(255) -- 鑱旂郴浜虹數璇�
);
-- 琛ㄦ敞閲婏細渚涘簲鍟嗕俊鎭〃锛屽瓨鍌ㄤ緵搴斿晢鍩烘湰淇℃伅锛堝惈鍦板潃灞傜骇鍏宠仈锛�
@@ -44,14 +52,17 @@
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.create_time IS '璁板綍鏁版嵁鍒涘缓鐨勬椂闂存埑锛堝甫鏃跺尯锛夛紝绯荤粺鑷姩濉厖褰撳墠鏃堕棿';
+COMMENT ON COLUMN supply.deleted IS '杞垹闄ゆ爣蹇楋紝true琛ㄧず宸插垹闄�';
+COMMENT ON COLUMN supply.create_by IS '鍒涘缓浜虹敤鎴峰悕';
+COMMENT ON COLUMN supply.create_time IS '璁板綍鍒涘缓鏃堕棿';
+COMMENT ON COLUMN supply.update_by IS '鏈�鍚庢洿鏂颁汉鐢ㄦ埛鍚�';
+COMMENT ON COLUMN supply.update_time IS '璁板綍鏈�鍚庢洿鏂版椂闂�';
--
Gitblit v1.9.3