From 4156037feb8e52df855c3c57b735134b5ed1ccfe Mon Sep 17 00:00:00 2001
From: eight <641137800@qq.com>
Date: 星期四, 29 八月 2024 16:50:29 +0800
Subject: [PATCH] update

---
 sql/mysql/jh.sql |   30 +++++++++++++++---------------
 1 files changed, 15 insertions(+), 15 deletions(-)

diff --git a/sql/mysql/jh.sql b/sql/mysql/jh.sql
index 79a456c..97f3bc7 100644
--- a/sql/mysql/jh.sql
+++ b/sql/mysql/jh.sql
@@ -76,21 +76,21 @@
 -- ----------------------------
 DROP TABLE IF EXISTS `clinic_room`;
 CREATE TABLE `clinic_room` (
-  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
-  `room_id` BIGINT NOT NULL COMMENT '璇婂缂栧彿',
-  `room_name` varchar(10) NOT NULL COMMENT '璇婂鍚嶇О',
-  `bed_no` varchar(10) NOT NULL COMMENT '璇婄枟搴婄紪鍙�',
-  `status` int 0 COMMENT '0:鍋滆瘖 10:寮�璇� 20:鏆傚仠',
-  `doctor_name` varchar(10) NOT NULL COMMENT '鍖荤敓鍚嶇О',
-  `tenant_id` int DEFAULT 1 COMMENT '绉熸埛缂栧彿',
-  `creator` varchar(10) DEFAULT '' COMMENT '鍒涘缓鑰�',
-  `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-  `updater` varchar(10) DEFAULT '' COMMENT '鏇存柊鑰�',
-  `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-  `deleted` bit(1) DEFAULT 0 COMMENT '鍒犻櫎鏍囪',
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='璇婂鍜岃瘖鐤楀簥琛�';
-
+       `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
+       `room_id` bigint NOT NULL COMMENT '璇婂缂栧彿',
+       `room_name` varchar(10) NOT NULL COMMENT '璇婂鍚嶇О',
+       `bed_no` varchar(10) NOT NULL COMMENT '璇婄枟搴婄紪鍙�',
+       `status` int NOT NULL DEFAULT '0',
+       `doc_id` bigint DEFAULT NULL,
+       `doc_name` varchar(10) DEFAULT '',
+       `creator` varchar(10) DEFAULT '' COMMENT '鍒涘缓鑰�',
+       `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
+       `updater` varchar(10) DEFAULT '' COMMENT '鏇存柊鑰�',
+       `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
+       `deleted` bit(1) DEFAULT b'0' COMMENT '鍒犻櫎鏍囪',
+       PRIMARY KEY (`id`),
+       UNIQUE KEY `unique-room-bed` (`room_id`,`bed_no`) USING BTREE
+) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='璇婂鍜岃瘖鐤楀簥琛�';
 
 -- ----------------------------
 -- Table structure for device_model

--
Gitblit v1.9.3