| | |
|---|
| | | `update_time` datetime NOT NULL COMMENT '更新时间', |
|---|
| | | `deleted` bit(1) DEFAULT b'0' COMMENT '删除标记', |
|---|
| | | PRIMARY KEY (`id`), |
|---|
| | | UNIQUE KEY `unique_pat_id` (`pat_id`) USING BTREE, |
|---|
| | | KEY `idx_status` (`status`) USING BTREE, |
|---|
| | | KEY `idx_seq_num` (`seq_num`) USING BTREE, |
|---|
| | | KEY `idx_room_bed_status` (`room_id`,`bed_no`,`status`) USING BTREE |
|---|
| | | ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='排队表'; |
|---|
| | | |
|---|
| | | ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='排队表'; |
|---|
| | | |
|---|
| | | -- ---------------------------- |
|---|
| | | -- Table structure for clinic_room |
|---|
