From 1ed6dd5f36a8a9d36a6660f36d1ef49601c53488 Mon Sep 17 00:00:00 2001 From: eight <641137800@qq.com> Date: 星期一, 12 八月 2024 14:13:26 +0800 Subject: [PATCH] 新增 排队 查看功能 --- sql/mysql/jh.sql | 7 +++---- 1 files changed, 3 insertions(+), 4 deletions(-) diff --git a/sql/mysql/jh.sql b/sql/mysql/jh.sql index 61ccf03..eb88b04 100644 --- a/sql/mysql/jh.sql +++ b/sql/mysql/jh.sql @@ -47,10 +47,9 @@ `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 '棰勭害妫�鏌ユ椂闂存', + `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