From a461d5fc184fd0129a0eb5a5b3e34f67d75cc6a2 Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期三, 04 六月 2025 16:51:59 +0800
Subject: [PATCH] 联调基础信息
---
basic-server/src/main/resources/db/migration/postgresql/V20250603102701__create_table_coal_info.sql | 18 +++++++++---------
1 files changed, 9 insertions(+), 9 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..a59dcd0 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,16 +1,16 @@
-- 鍒涘缓 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), -- 鍒涘缓浜�
+ deleted int4 NOT NULL DEFAULT 0, -- 鏄惁鍒犻櫎锛堣蒋鍒犻櫎鏍囧織锛�
+ create_by VARCHAR(255), -- 鍒涘缓浜�
create_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, -- 鍒涘缓鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂�
- update_by VARCHAR(255), -- 鏈�鍚庢洿鏂颁汉
+ update_by VARCHAR(255), -- 鏈�鍚庢洿鏂颁汉
update_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿
);
@@ -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