8 lines
387 B
SQL
Executable File
8 lines
387 B
SQL
Executable File
-- 二诊医助：新指派患者已读标记
|
|
ALTER TABLE `zyt_tcm_diagnosis`
|
|
ADD COLUMN `assign_read_at` int(10) unsigned DEFAULT NULL
|
|
COMMENT '医助查看指派时间戳，NULL 未读（新指派红旗）' AFTER `assistant_id`;
|
|
|
|
-- 已有数据标记为已读，避免全部显示红旗
|
|
UPDATE `zyt_tcm_diagnosis` SET `assign_read_at` = UNIX_TIMESTAMP() WHERE `assistant_id` > 0;
|