From dc9010b9fc4ca6929992bfc3cc4fa110ebc24b2c Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期四, 12 六月 2025 17:45:39 +0800 Subject: [PATCH] 采购优化 --- main-business/src/main/resources/db/migration/postgresql/V20250604111200__create_table_official_inventory.sql | 38 ++++++++++++++++++++------------------ 1 files changed, 20 insertions(+), 18 deletions(-) diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250604111200__create_table_official_inventory.sql b/main-business/src/main/resources/db/migration/postgresql/V20250604111200__create_table_official_inventory.sql index 80587a1..94908ff 100644 --- a/main-business/src/main/resources/db/migration/postgresql/V20250604111200__create_table_official_inventory.sql +++ b/main-business/src/main/resources/db/migration/postgresql/V20250604111200__create_table_official_inventory.sql @@ -1,23 +1,26 @@ -- 鍒涘缓姝ｅ紡搴撹〃 CREATE TABLE official_inventory ( - id SERIAL PRIMARY KEY, -- 涓婚敭ID - supplier_name VARCHAR(255) NOT NULL, -- 渚涜揣鍟嗗悕绉� - coal_type VARCHAR(50) NOT NULL, -- 鐓ょ - unit VARCHAR(50) NOT NULL, -- 鍗曚綅 - inventory_quantity DECIMAL(10, 2) NOT NULL, -- 搴撳瓨鏁伴噺 - price_including_tax DECIMAL(10, 2) NOT NULL, -- 鍗曚环锛堝惈绋庯級 - total_price_including_tax DECIMAL(10, 2) NOT NULL, -- 鎬讳环锛堝惈绋庯級 - cost_per_unit DECIMAL(10, 2) NOT NULL, -- 鎴愭湰鍗曚环 - pending_replenishment DECIMAL(10, 2) NOT NULL, -- 寰呰ˉ搴� - registrant_id VARCHAR(50) NOT NULL, -- 鐧昏浜篿d - registration_date TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, + id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID + supplier_name VARCHAR(255) NOT NULL, -- 渚涜揣鍟嗗悕绉� + coal VARCHAR(50) NOT NULL, -- 鐓ょ + unit VARCHAR(50) NOT NULL, -- 鍗曚綅 + inventory_quantity DECIMAL(10, 2) NOT NULL, -- 搴撳瓨鏁伴噺 + price_including_tax DECIMAL(10, 2) NOT NULL, -- 鍗曚环锛堝惈绋庯級 + total_price_including_tax DECIMAL(10, 2) NOT NULL, -- 鎬讳环锛堝惈绋庯級 + price_excluding_tax DECIMAL(10, 2) NOT NULL, -- 涓嶅惈绋庡崟浠� + total_price_excluding_tax DECIMAL(10, 2) NOT NULL, -- 涓嶅惈绋庢�讳环 + pending_replenishment DECIMAL(10, 2) NOT NULL, -- 寰呰ˉ搴� + registrant_id VARCHAR(50) NOT NULL, -- 鐧昏浜篿d + type VARCHAR(50) NOT NULL, -- 鐧昏浜篿d + pending_id BIGINT, -- 寰呭叆搴搃d + registration_date TIMESTAMP WITHOUT TIME ZONE, - deleted INT NOT NULL DEFAULT 0, -- 杞垹闄ゆ爣蹇楋細0=鏈垹闄わ紝1=宸插垹闄� - 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 -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿-- 鐧昏鏃ユ湡 + deleted INT NOT NULL DEFAULT 0, -- 杞垹闄ゆ爣蹇楋細0=鏈垹闄わ紝1=宸插垹闄� + create_by VARCHAR(255), -- 鍒涘缓浜虹敤鎴峰悕 + create_time TIMESTAMP WITHOUT TIME ZONE, -- 鍒涘缓鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂� + update_by VARCHAR(255), -- 鏈�鍚庢洿鏂颁汉鐢ㄦ埛鍚� + update_time TIMESTAMP WITHOUT TIME ZONE -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿-- 鐧昏鏃ユ湡 ); -- 娣诲姞琛ㄦ敞閲� @@ -26,12 +29,11 @@ -- 娣诲姞瀛楁娉ㄩ噴 COMMENT ON COLUMN official_inventory.id IS '涓婚敭ID'; COMMENT ON COLUMN official_inventory.supplier_name IS '渚涜揣鍟嗗悕绉�'; -COMMENT ON COLUMN official_inventory.coal_type IS '鐓ょ'; +COMMENT ON COLUMN official_inventory.coal IS '鐓ょ'; COMMENT ON COLUMN official_inventory.unit IS '鍗曚綅'; COMMENT ON COLUMN official_inventory.inventory_quantity IS '搴撳瓨鏁伴噺'; COMMENT ON COLUMN official_inventory.price_including_tax IS '鍗曚环锛堝惈绋庯級'; COMMENT ON COLUMN official_inventory.total_price_including_tax IS '鎬讳环锛堝惈绋庯級'; -COMMENT ON COLUMN official_inventory.cost_per_unit IS '鎴愭湰鍗曚环'; COMMENT ON COLUMN official_inventory.pending_replenishment IS '寰呰ˉ搴�'; COMMENT ON COLUMN official_inventory.registrant_id IS '鐧昏浜篿d'; COMMENT ON COLUMN official_inventory.registration_date IS '鐧昏鏃ユ湡'; -- Gitblit v1.9.3