From fce96ef468291fb9a0e6a4d34ab371315e9485d4 Mon Sep 17 00:00:00 2001
From: yxh <172933527@qq.com>
Date: 星期六, 03 十月 2026 00:59:44 +0800
Subject: [PATCH] ai优化

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

diff --git a/sql/mysql/jh.sql b/sql/mysql/jh.sql
index 609d300..390b8f7 100644
--- a/sql/mysql/jh.sql
+++ b/sql/mysql/jh.sql
@@ -21,7 +21,6 @@
   `pat_ward_code` varchar(45) DEFAULT '' COMMENT '鎮ｈ�呮墍鍦ㄧ梾鍖轰唬鐮�',
   `pat_ward_desc` varchar(45) DEFAULT '' COMMENT '鎮ｈ�呮墍鍦ㄧ梾鍖哄悕绉�',
   `pat_bed_no` varchar(45) DEFAULT '' COMMENT '搴婂彿',
-  `book_id` varchar(45) DEFAULT '' COMMENT '棰勭害缂栧彿',
   `book_date` date NOT NULL COMMENT '棰勭害鏃ユ湡',
   `book_timeslot` int NOT NULL COMMENT '棰勭害鏃堕棿娈�',
   `book_time` datetime NOT NULL COMMENT '棰勭害鍙戠敓鏃堕棿',
@@ -35,6 +34,13 @@
   `updater` varchar(10) DEFAULT '' COMMENT '鏇存柊鑰�',
   `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
   `deleted` bit(1) DEFAULT b'0' COMMENT '鍒犻櫎鏍囪',
+  -- 浠ヤ笅 6 鍒楃敱 _prep/06_add_his_columns.sql 娣诲姞锛圚IS 鎺ュ叆琛ュ厖瀛楁锛�2026-09-27锛�
+  `jjbz` varchar(4) DEFAULT NULL COMMENT '浼樺厛绾ф爣璁� N甯歌 J鍔犳��',
+  `method_code` varchar(64) DEFAULT NULL COMMENT '妫�鏌ユ柟寮忕紪鐮�',
+  `target_site_code` varchar(64) DEFAULT NULL COMMENT '妫�鏌ラ儴浣嶇紪鐮�',
+  `room_name` varchar(64) DEFAULT NULL COMMENT '妫�鏌ユ埧闂村悕绉�',
+  `remark` varchar(255) DEFAULT NULL COMMENT '娉ㄦ剰浜嬮」',
+  `book_seq_num` int DEFAULT NULL COMMENT '棰勭害鎺掑簭鍙�',
   PRIMARY KEY (`id`),
   KEY `idx-pat` (`pat_id`) USING BTREE
 ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='棰勭害琛�';

--
Gitblit v1.9.3