From 4fedbed9949c6160dcfa216d6660bd3c625f7bce Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期三, 25 六月 2025 11:49:55 +0800 Subject: [PATCH] 优化 --- main-business/src/main/resources/db/migration/postgresql/V20250611160300__create_table_sales_record.sql | 49 ++++++++++++++++++++++++------------------------- 1 files changed, 24 insertions(+), 25 deletions(-) diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250611160300__create_table_sales_record.sql b/main-business/src/main/resources/db/migration/postgresql/V20250611160300__create_table_sales_record.sql index b963e59..4f0fe0e 100644 --- a/main-business/src/main/resources/db/migration/postgresql/V20250611160300__create_table_sales_record.sql +++ b/main-business/src/main/resources/db/migration/postgresql/V20250611160300__create_table_sales_record.sql @@ -1,31 +1,31 @@ -- 鍒涘缓閿�鍞褰曡〃 CREATE TABLE sales_record ( - id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID - sale_date DATE NOT NULL, -- 閿�鍞棩鏈� - customer_id BIGINT, -- 瀹㈡埛id - customer VARCHAR(255) NOT NULL, -- 瀹㈡埛 - coal_id VARCHAR(255) NOT NULL, -- 鐓ょ id - coal VARCHAR(255) NOT NULL, -- 鐓ょ - price_including_tax DECIMAL(10, 2) NOT NULL, -- 鍗曚环锛堝惈绋庯級 - inventory_quantity DECIMAL(10, 0) NOT NULL, -- 搴撳瓨鏁伴噺 - unit VARCHAR(100) NOT NULL, -- 鍗曚綅 - sale_quantity DECIMAL(10, 2) NOT NULL, -- 閿�鍞暟閲� - sale_price DECIMAL(10, 2) NOT NULL, -- 閿�鍞崟浠� (鍚◣) - total_amount DECIMAL(10, 2) NOT NULL, -- 閿�鍞�讳环 (鍚◣) - tax_coal VARCHAR(36), -- 璐攢鐓ょ◣鐜�13% - tax_trans VARCHAR(36), -- 杩愯緭绋庣巼9% - gross_profit DECIMAL(10, 2), -- 姣涘埄娑� - net_profit DECIMAL(10, 2), -- 鍑�鍒╂鼎 - registrant_id BIGINT, -- 鐧昏浜篿d - registrant VARCHAR(255) NOT NULL, -- 鐧昏浜� - registration_date DATE NOT NULL, -- 鐧昏鏃ユ湡 + id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID + sale_date DATE NOT NULL, -- 閿�鍞棩鏈� + customer_id BIGINT, -- 瀹㈡埛id + customer VARCHAR(255) NOT NULL, -- 瀹㈡埛 + coal_id VARCHAR(255) NOT NULL, -- 鐓ょ id + price_including_tax DECIMAL(10, 2) NOT NULL, -- 鍗曚环锛堝惈绋庯級 + inventory_quantity DECIMAL(10, 0) NOT NULL, -- 搴撳瓨鏁伴噺 + unit VARCHAR(100) NOT NULL, -- 鍗曚綅 + sale_quantity DECIMAL(10, 2) NOT NULL, -- 閿�鍞暟閲� + sale_price DECIMAL(10, 2) NOT NULL, -- 閿�鍞崟浠� (鍚◣) + total_amount DECIMAL(10, 2) NOT NULL, -- 閿�鍞�讳环 (鍚◣) + freight DECIMAL(10, 2) NOT NULL, -- 杩愯垂 + tax_coal VARCHAR(36), -- 璐攢鐓ょ◣鐜�13% + tax_trans VARCHAR(36), -- 杩愯緭绋庣巼9% + gross_profit DECIMAL(10, 2), -- 姣涘埄娑� + net_profit DECIMAL(10, 2), -- 鍑�鍒╂鼎 + registrant_id BIGINT, -- 鐧昏浜篿d + registrant VARCHAR(255) NOT NULL, -- 鐧昏浜� + registration_date DATE NOT NULL, -- 鐧昏鏃ユ湡 - create_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, -- 涓婁紶鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂� - update_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿 - create_by VARCHAR(255), -- 涓婁紶浜虹敤鎴峰悕 - update_by VARCHAR(255), -- 鏈�鍚庝慨鏀逛汉鐢ㄦ埛鍚� - deleted INT NOT NULL DEFAULT 0 -- 杞垹闄ゆ爣蹇楋細0=鏈垹闄わ紝1=宸插垹闄� + create_time TIMESTAMP WITHOUT TIME ZONE, -- 涓婁紶鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂� + update_time TIMESTAMP WITHOUT TIME ZONE, -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿 + create_by VARCHAR(255), -- 涓婁紶浜虹敤鎴峰悕 + update_by VARCHAR(255), -- 鏈�鍚庝慨鏀逛汉鐢ㄦ埛鍚� + deleted INT NOT NULL DEFAULT 0 -- 杞垹闄ゆ爣蹇楋細0=鏈垹闄わ紝1=宸插垹闄� ); -- 琛ㄦ敞閲� @@ -36,7 +36,6 @@ COMMENT ON COLUMN sales_record.sale_date IS '閿�鍞棩鏈�'; COMMENT ON COLUMN sales_record.customer IS '瀹㈡埛'; COMMENT ON COLUMN sales_record.customer_id IS '瀹㈡埛id'; -COMMENT ON COLUMN sales_record.coal IS '鐓ょ'; COMMENT ON COLUMN sales_record.coal_id IS '鐓ょid'; COMMENT ON COLUMN sales_record.unit IS '鍗曚綅'; COMMENT ON COLUMN sales_record.price_including_tax IS '鍗曚环锛堝惈绋庯級'; -- Gitblit v1.9.3