From 60264687a654d2e7fc46dc9dc81e4fd663210b78 Mon Sep 17 00:00:00 2001
From: chenhj <1263187585@qq.com>
Date: 星期六, 14 六月 2025 16:27:59 +0800
Subject: [PATCH] 库存明细，以及库存数量更新方法，库存节点存储
---
basic-server/src/main/resources/db/migration/postgresql/V20250603102701__create_table_coal_info.sql | 22 +++++++++++-----------
1 files changed, 11 insertions(+), 11 deletions(-)
diff --git a/basic-server/src/main/resources/db/migration/postgresql/V20250603102701__create_table_coal_info.sql b/basic-server/src/main/resources/db/migration/postgresql/V20250603102701__create_table_coal_info.sql
index e1274a7..85d44bd 100644
--- a/basic-server/src/main/resources/db/migration/postgresql/V20250603102701__create_table_coal_info.sql
+++ b/basic-server/src/main/resources/db/migration/postgresql/V20250603102701__create_table_coal_info.sql
@@ -1,17 +1,17 @@
-- 鍒涘缓 coal_info 琛�
CREATE TABLE coal_info
(
- id SERIAL PRIMARY KEY, -- 涓婚敭锛岃嚜鍔ㄩ�掑
- coal_name VARCHAR(255) NOT NULL, -- 鐓ょ鍚嶇О锛屼笉鍏佽涓虹┖
- maintainer VARCHAR(255) NOT NULL, -- 缁存姢浜猴紝涓嶅厑璁镐负绌�
- maintenance_date DATE NOT NULL, -- 缁存姢鏃ユ湡锛屼笉鍏佽涓虹┖
+ id SERIAL PRIMARY KEY, -- 涓婚敭锛岃嚜鍔ㄩ�掑
+ coal VARCHAR(255) NOT NULL, -- 鐓ょ鍚嶇О锛屼笉鍏佽涓虹┖
+ maintainer_id int4 NOT NULL DEFAULT 0, -- 缁存姢浜猴紝涓嶅厑璁镐负绌�
+ maintenance_date DATE NOT NULL, -- 缁存姢鏃ユ湡锛屼笉鍏佽涓虹┖
-- 鏂板瀛楁
- deleted int4 NOT NULL DEFAULT 0, -- 鏄惁鍒犻櫎锛堣蒋鍒犻櫎鏍囧織锛�
- 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 int4 NOT NULL DEFAULT 0, -- 鏄惁鍒犻櫎锛堣蒋鍒犻櫎鏍囧織锛�
+ create_by VARCHAR(255), -- 鍒涘缓浜�
+ create_time TIMESTAMP WITHOUT TIME ZONE, -- 鍒涘缓鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂�
+ update_by VARCHAR(255), -- 鏈�鍚庢洿鏂颁汉
+ update_time TIMESTAMP WITHOUT TIME ZONE -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿
);
-- 涓鸿〃娣诲姞娉ㄩ噴
@@ -19,8 +19,8 @@
-- 涓哄瓧娈垫坊鍔犳敞閲�
COMMENT ON COLUMN coal_info.id IS '涓婚敭ID';
-COMMENT ON COLUMN coal_info.coal_name IS '鐓ょ鍚嶇О';
-COMMENT ON COLUMN coal_info.maintainer IS '缁存姢浜哄鍚�';
+COMMENT ON COLUMN coal_info.coal IS '鐓ょ鍚嶇О';
+COMMENT ON COLUMN coal_info.maintainer_id IS '缁存姢浜哄鍚�';
COMMENT ON COLUMN coal_info.maintenance_date IS '缁存姢鏃ユ湡';
-- 鏂板瀛楁鐨勬敞閲�
--
Gitblit v1.9.3