From 9b18e467d407c66ecc3c46a197aca45dcc3f8056 Mon Sep 17 00:00:00 2001 From: eight <641137800@qq.com> Date: 星期二, 27 八月 2024 09:11:02 +0800 Subject: [PATCH] update --- sql/mysql/jh.sql | 29 ++++++++++++++--------------- 1 files changed, 14 insertions(+), 15 deletions(-) diff --git a/sql/mysql/jh.sql b/sql/mysql/jh.sql index 79a456c..70a6f3a 100644 --- a/sql/mysql/jh.sql +++ b/sql/mysql/jh.sql @@ -76,21 +76,20 @@ -- ---------------------------- 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`) +) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='璇婂鍜岃瘖鐤楀簥琛�'; -- ---------------------------- -- Table structure for device_model -- Gitblit v1.9.3