From 1e8ccfec6ebcf7787def13165d9932b0cccefc49 Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期五, 20 六月 2025 14:34:45 +0800 Subject: [PATCH] 1.文件上传格式调整 2.表格调整 --- main-business/src/main/resources/db/migration/postgresql/V20250604104500__create_table_pending_inventory.sql | 51 +++++++++++++++++++++++++++++++-------------------- 1 files changed, 31 insertions(+), 20 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 1acb79e..97c44c1 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,41 +1,52 @@ -- 鍒涘缓寰呭叆搴撹〃 CREATE TABLE pending_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, -- 鎴愭湰鍗曚环 - 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 NUMERIC(10,2) NOT NULL, -- 搴撳瓨鏁伴噺 + price_including_tax NUMERIC(10,2) NOT NULL, -- 鍗曚环锛堝惈绋庯級 + total_price_including_tax NUMERIC(10,2) NOT NULL, -- 鎬讳环锛堝惈绋庯級 + registrant VARCHAR(50), -- 鐧昏浜� + registration_time TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP, -- 鐧昏鏃堕棿 + price_excluding_tax VARCHAR(255), -- 鍗曚环锛堜笉鍚◣锛� + total_price_excluding_tax VARCHAR(255), -- 鎬讳环锛堜笉鍚◣锛� + registrant_id VARCHAR(32), -- 鐧昏浜篒D + registration_date DATE, -- 鐧昏鏃ユ湡 + supplier_id BIGINT, -- 渚涜揣鍟咺D + coal_id BIGINT, -- 鐓ょID - 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 INTEGER DEFAULT 0, -- 杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄� + create_by VARCHAR(255), -- 鍒涘缓璇ヨ褰曠殑鐢ㄦ埛 + create_time TIMESTAMP(6), -- 璁板綍鍒涘缓鏃堕棿 + update_by VARCHAR(255), -- 鏈�鍚庝慨鏀硅璁板綍鐨勭敤鎴� + update_time TIMESTAMP(6) -- 璁板綍鏈�鍚庢洿鏂版椂闂� + ); --- 娣诲姞琛ㄦ敞閲� COMMENT ON TABLE pending_inventory IS '寰呭叆搴撹〃'; --- 娣诲姞瀛楁娉ㄩ噴 +-- 瀛楁娉ㄩ噴 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 '鐧昏鏃堕棿'; +COMMENT ON COLUMN pending_inventory.price_excluding_tax IS '鍗曚环锛堜笉鍚◣锛�'; +COMMENT ON COLUMN pending_inventory.total_price_excluding_tax IS '鎬讳环锛堜笉鍚◣锛�'; +COMMENT ON COLUMN pending_inventory.registrant_id IS '鐧昏浜篒D'; +COMMENT ON COLUMN pending_inventory.registration_date IS '鐧昏鏃ユ湡'; +COMMENT ON COLUMN pending_inventory.supplier_id IS '渚涜揣鍟咺D'; +COMMENT ON COLUMN pending_inventory.coal_id IS '鐓ょID'; COMMENT ON COLUMN pending_inventory.deleted IS '杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄�'; COMMENT ON COLUMN pending_inventory.create_by IS '鍒涘缓璇ヨ褰曠殑鐢ㄦ埛'; COMMENT ON COLUMN pending_inventory.create_time IS '璁板綍鍒涘缓鏃堕棿'; COMMENT ON COLUMN pending_inventory.update_by IS '鏈�鍚庝慨鏀硅璁板綍鐨勭敤鎴�'; -COMMENT ON COLUMN pending_inventory.update_time IS '璁板綍鏈�鍚庢洿鏂版椂闂�'; \ No newline at end of file +COMMENT ON COLUMN pending_inventory.update_time IS '璁板綍鏈�鍚庢洿鏂版椂闂�'; + -- Gitblit v1.9.3