From 2cc467544220312cdf16b79d32530c5e4cdfe14a Mon Sep 17 00:00:00 2001 From: eight <641137800@qq.com> Date: 星期二, 13 八月 2024 09:51:01 +0800 Subject: [PATCH] map 转 对象 hutool beanutil --- sql/mysql/jh.sql | 9 ++++----- 1 files changed, 4 insertions(+), 5 deletions(-) diff --git a/sql/mysql/jh.sql b/sql/mysql/jh.sql index 61ccf03..792a45d 100644 --- a/sql/mysql/jh.sql +++ b/sql/mysql/jh.sql @@ -46,11 +46,10 @@ `id` int NOT NULL AUTO_INCREMENT COMMENT 'id', `pat_id` varchar(30) NOT NULL COMMENT '鎮ｈ�呯紪鍙�', `pat_name` varchar(10) NOT NULL COMMENT '鎮ｈ�呭鍚�', - `pat_gender` bit(1) DEFAULT NULL COMMENT '鎮ｈ�呮�у埆', - `book_period_start` datetime NOT NULL COMMENT '棰勭害妫�鏌ユ椂闂存', - `book_period_end` datetime NOT NULL COMMENT '棰勭害妫�鏌ユ椂闂存', + `pat_gender` tinyint(1) DEFAULT NULL COMMENT '鎮ｈ�呮�у埆', + `book_timeslot` int NOT NULL COMMENT '棰勭害鏃堕棿娈�', `book_check_type` tinyint(1) DEFAULT NULL COMMENT '棰勭害妫�鏌ョ被鍨�', - `seq_id` int NOT NULL COMMENT '鎺掗槦搴忓彿', + `seq_num` int NOT NULL COMMENT '鎺掗槦搴忓彿', `status` tinyint(1) NOT NULL COMMENT '10:鎺掗槦涓� 20:鍊欒瘖鍑嗗 30:灏辫瘖涓� 40:灏辫瘖瀹屾垚 50:杩囧彿 60:杩囨湡', `passed` tinyint(1) NOT NULL COMMENT '杩囧彿鏍囪', `expired` tinyint(1) NOT NULL COMMENT '棰勭害杩囨湡鏍囪', @@ -63,7 +62,7 @@ `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿', `deleted` bit(1) DEFAULT 0 COMMENT '鍒犻櫎鏍囪', PRIMARY KEY (`id`), - UNIQUE KEY `idx_seq_id` (`seq_id`) + UNIQUE KEY `idx_seq_id` (`seq_num`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='鎺掗槦琛�'; -- Gitblit v1.9.3