From d75958896efd4c8a6daee9c56d048641b99cacf6 Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期二, 24 六月 2025 17:54:50 +0800 Subject: [PATCH] 1.二维码巡检记录以及文件上传记录 2.部分优化 --- main-business/src/main/resources/db/migration/postgresql/V20250604104500__create_table_pending_inventory.sql | 42 ++++++++++++++++++++++-------------------- 1 files changed, 22 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 97c44c1..f686498 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,27 +1,28 @@ -- 鍒涘缓寰呭叆搴撹〃 CREATE TABLE pending_inventory ( - 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 + 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 + master_id BIGINT, -- 鐢熶骇鍔犲伐id - deleted INTEGER DEFAULT 0, -- 杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄� - create_by VARCHAR(255), -- 鍒涘缓璇ヨ褰曠殑鐢ㄦ埛 - create_time TIMESTAMP(6), -- 璁板綍鍒涘缓鏃堕棿 - update_by VARCHAR(255), -- 鏈�鍚庝慨鏀硅璁板綍鐨勭敤鎴� - update_time TIMESTAMP(6) -- 璁板綍鏈�鍚庢洿鏂版椂闂� + deleted INTEGER DEFAULT 0, -- 杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄� + create_by VARCHAR(255), -- 鍒涘缓璇ヨ褰曠殑鐢ㄦ埛 + create_time TIMESTAMP(6), -- 璁板綍鍒涘缓鏃堕棿 + update_by VARCHAR(255), -- 鏈�鍚庝慨鏀硅璁板綍鐨勭敤鎴� + update_time TIMESTAMP(6) -- 璁板綍鏈�鍚庢洿鏂版椂闂� ); @@ -43,6 +44,7 @@ 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.master_id IS '鐢熶骇鍔犲伐id'; COMMENT ON COLUMN pending_inventory.deleted IS '杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄�'; COMMENT ON COLUMN pending_inventory.create_by IS '鍒涘缓璇ヨ褰曠殑鐢ㄦ埛'; -- Gitblit v1.9.3