From c0cf736ff001bbaec59b7da6239f4670464952fd Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期四, 12 六月 2025 16:32:05 +0800 Subject: [PATCH] 1.销售模块 2.时区优化 --- main-business/src/main/resources/db/migration/postgresql/V20250604104500__create_table_pending_inventory.sql | 32 +++++++++++++++----------------- 1 files changed, 15 insertions(+), 17 deletions(-) diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250604104500__create_table_pending_inventory.sql b/main-business/src/main/resources/db/migration/postgresql/V20250604104500__create_table_pending_inventory.sql index 9ee25e8..37bbf2e 100644 --- a/main-business/src/main/resources/db/migration/postgresql/V20250604104500__create_table_pending_inventory.sql +++ b/main-business/src/main/resources/db/migration/postgresql/V20250604104500__create_table_pending_inventory.sql @@ -1,22 +1,21 @@ -- 鍒涘缓寰呭叆搴撹〃 CREATE TABLE pending_inventory ( - id BIGSERIAL 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, -- 鎴愭湰鍗曚环 - registrant VARCHAR(50) NOT NULL, -- 鐧昏浜� - registration_time TIMESTAMP NOT NULL 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, -- 鎬讳环锛堝惈绋庯級 + registrant VARCHAR(50) NOT NULL, -- 鐧昏浜� + registration_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- 鐧昏鏃堕棿 - 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 -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿 ); -- 娣诲姞琛ㄦ敞閲� @@ -25,12 +24,11 @@ -- 娣诲姞瀛楁娉ㄩ噴 COMMENT ON COLUMN pending_inventory.id IS '涓婚敭ID'; COMMENT ON COLUMN pending_inventory.supplier_name IS '渚涜揣鍟嗗悕绉�'; -COMMENT ON COLUMN pending_inventory.coal_type IS '鐓ょ'; +COMMENT ON COLUMN pending_inventory.coal IS '鐓ょ'; COMMENT ON COLUMN pending_inventory.unit IS '鍗曚綅'; COMMENT ON COLUMN pending_inventory.inventory_quantity IS '搴撳瓨鏁伴噺'; COMMENT ON COLUMN pending_inventory.price_including_tax IS '鍗曚环锛堝惈绋庯級'; COMMENT ON COLUMN pending_inventory.total_price_including_tax IS '鎬讳环锛堝惈绋庯級'; -COMMENT ON COLUMN pending_inventory.cost_per_unit IS '鎴愭湰鍗曚环'; COMMENT ON COLUMN pending_inventory.registrant IS '鐧昏浜�'; COMMENT ON COLUMN pending_inventory.registration_time IS '鐧昏鏃堕棿'; -- Gitblit v1.9.3