ALTER TABLE `lihu`.`check_type`
|
ADD COLUMN `display_barcode` INT NULL DEFAULT 0 COMMENT '是否显示患者条码' AFTER `deleted`,
|
ADD COLUMN `expense_recognition` INT NULL DEFAULT 0 COMMENT '是否需要确费' AFTER `display_barcode`,
|
ADD COLUMN `timeslot_book_num` INT NULL DEFAULT 0 COMMENT '时段预约规定人数' AFTER `expense_recognition`,
|
ADD COLUMN `timeslot_reserved_num` INT NULL DEFAULT 0 COMMENT '每时段预留人数' AFTER `timeslot_book_num`,
|
ADD COLUMN `affinity_check_types` VARCHAR(45) NULL DEFAULT '' COMMENT '亲和的检查类型' AFTER `timeslot_reserved_num`;
|
|
CREATE TABLE `queue_sequence` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`check_type` int DEFAULT NULL,
|
`time_slot` int DEFAULT NULL,
|
`queue_no` int DEFAULT NULL,
|
`queue_vip_no` int DEFAULT NULL,
|
`queue_full` int DEFAULT NULL,
|
`queue_vip_full` int DEFAULT NULL,
|
`creator` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '',
|
`create_time` datetime NOT NULL,
|
`updater` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '',
|
`update_time` datetime NOT NULL,
|
`deleted` bit(1) DEFAULT b'0',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
SELECT * FROM lihu.check_type;
|
