From bb5bf872de5e67d7b406e3a305c9dfcbd0f218a6 Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期四, 26 六月 2025 18:03:55 +0800 Subject: [PATCH] 采购，正式库优化 --- main-business/src/main/resources/db/migration/postgresql/V20250603160101__create_table_purchase_registration.sql | 38 +++++++++++++++++++------------------- 1 files changed, 19 insertions(+), 19 deletions(-) diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250603160101__create_table_purchase_registration.sql b/main-business/src/main/resources/db/migration/postgresql/V20250603160101__create_table_purchase_registration.sql index 92dd4e6..d24a052 100644 --- a/main-business/src/main/resources/db/migration/postgresql/V20250603160101__create_table_purchase_registration.sql +++ b/main-business/src/main/resources/db/migration/postgresql/V20250603160101__create_table_purchase_registration.sql @@ -1,26 +1,26 @@ -- 鍒涘缓 purchase_registration 琛� CREATE TABLE purchase_registration ( - id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID锛岃嚜鍔ㄩ�掑 - supplier_id BIGINT NOT NULL, -- 渚涘簲鍟嗗悕绉癐D锛屼笉鍏佽涓虹┖ - supplier_name VARCHAR(255) NOT NULL, -- 渚涘簲鍟嗗悕绉帮紝涓嶅厑璁镐负绌� - unit VARCHAR(50) NOT NULL, -- 鍗曚綅锛屼笉鍏佽涓虹┖ - coal_id BIGINT NOT NULL, -- 鐓ょ绫诲瀷id - coal VARCHAR(255), -- 鐓ょ绫诲瀷 - purchase_quantity DECIMAL(10, 2) NOT NULL, -- 閲囪喘鏁伴噺锛屼笉鍏佽涓虹┖ - price_including_tax DECIMAL(10, 2) NOT NULL, -- 鍗曚环锛堝惈绋庯級锛屼笉鍏佽涓虹┖ - total_price_including_tax DECIMAL(10, 2) NOT NULL, -- 鎬讳环锛堝惈绋庯級锛屼笉鍏佽涓虹┖ - tax_rate DECIMAL(5, 2) NOT NULL, -- 绋庣巼锛屼笉鍏佽涓虹┖ - price_excluding_tax DECIMAL(10, 2) NOT NULL, -- 涓嶅惈绋庡崟浠凤紝涓嶅厑璁镐负绌� - total_price_excluding_tax DECIMAL(10, 2) NOT NULL, -- 涓嶅惈绋庢�讳环锛屼笉鍏佽涓虹┖ - registrant_id VARCHAR(255) NOT NULL, -- 鐧昏浜篿d锛屼笉鍏佽涓虹┖ - registration_date DATE NOT NULL, -- 鐧昏鏃ユ湡锛屼笉鍏佽涓虹┖ + id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID锛岃嚜鍔ㄩ�掑 + supplier_id BIGINT NOT NULL, -- 渚涘簲鍟嗗悕绉癐D锛屼笉鍏佽涓虹┖ + supplier_name VARCHAR(255) NOT NULL, -- 渚涘簲鍟嗗悕绉帮紝涓嶅厑璁镐负绌� + unit VARCHAR(50) NOT NULL, -- 鍗曚綅锛屼笉鍏佽涓虹┖ + coal_id BIGINT NOT NULL, -- 鐓ょ绫诲瀷id + coal VARCHAR(255), -- 鐓ょ绫诲瀷 + purchase_quantity DECIMAL(10, 2) NOT NULL, -- 閲囪喘鏁伴噺锛屼笉鍏佽涓虹┖ + price_including_tax DECIMAL(10, 2) NOT NULL, -- 鍗曚环锛堝惈绋庯級锛屼笉鍏佽涓虹┖ + total_price_including_tax DECIMAL(10, 2) NOT NULL, -- 鎬讳环锛堝惈绋庯級锛屼笉鍏佽涓虹┖ + tax_rate DECIMAL(5, 2) NOT NULL, -- 绋庣巼锛屼笉鍏佽涓虹┖ + price_excluding_tax DECIMAL(10, 2) NOT NULL, -- 涓嶅惈绋庡崟浠凤紝涓嶅厑璁镐负绌� + total_price_excluding_tax DECIMAL(10, 2) NOT NULL, -- 涓嶅惈绋庢�讳环锛屼笉鍏佽涓虹┖ + registrant_id BIGINT NOT NULL, -- 鐧昏浜篿d锛屼笉鍏佽涓虹┖ + registration_date DATE NOT NULL, -- 鐧昏鏃ユ湡锛屼笉鍏佽涓虹┖ - 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 -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿 + 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 -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿 ); -- 涓鸿〃娣诲姞娉ㄩ噴 -- Gitblit v1.9.3