From 0f8f4c5de1d817aa87c4c79e966d3cfbd0997aeb Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期三, 23 七月 2025 16:55:56 +0800
Subject: [PATCH] 1.设备领用添加记录 2.采购添加运费
---
main-business/src/main/resources/db/migration/postgresql/V20250701142700__create_table_equipment_management.sql | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250701142700__create_table_equipment_management.sql b/main-business/src/main/resources/db/migration/postgresql/V20250701142700__create_table_equipment_management.sql
index a682429..dbcd9a8 100644
--- a/main-business/src/main/resources/db/migration/postgresql/V20250701142700__create_table_equipment_management.sql
+++ b/main-business/src/main/resources/db/migration/postgresql/V20250701142700__create_table_equipment_management.sql
@@ -7,12 +7,13 @@
equipment_name VARCHAR(100) NOT NULL, -- 璁惧鍚嶇О
quantity INT NOT NULL DEFAULT 0, -- 鏁伴噺
specification VARCHAR(50) NOT NULL, -- 瑙勬牸鍨嬪彿
- usage_status VARCHAR(20) NOT NULL, -- 浣跨敤鐘舵��
+ usage_status VARCHAR(20), -- 浣跨敤鐘舵��
using_department VARCHAR(50) NOT NULL, -- 浣跨敤閮ㄩ棬
user_id BIGINT, -- 浣跨敤浜�
storage_location VARCHAR(100) NOT NULL, -- 瀛樻斁浣嶇疆
purchase_date DATE, -- 閲囪喘鏃ユ湡
purchase_price DECIMAL(10, 2), -- 閲囪喘浠锋牸
+ is_consumables BOOLEAN NOT NULL DEFAULT FALSE, -- 鏄惁鑰楁潗绫�
deleted INT NOT NULL DEFAULT 0, -- 杞垹闄ゆ爣蹇楋細0=鏈垹闄わ紝1=宸插垹闄�
create_by VARCHAR(255), -- 鍒涘缓浜虹敤鎴峰悕
@@ -46,6 +47,8 @@
ON COLUMN equipment_management.purchase_date IS ' 閲囪喘鏃ユ湡 ';
COMMENT
ON COLUMN equipment_management.purchase_price IS ' 閲囪喘浠锋牸 ';
+COMMENT
+ON COLUMN equipment_management.is_consumables IS ' 鏄惁鑰楁潗绫� ';
COMMENT
ON COLUMN inspection_task.deleted IS '杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄�';
--
Gitblit v1.9.3