use monitoring_system;

drop table if exists exception_patient;

create table exception_patient(
  patient_id int(0) NOT NULL,
  date date NOT NULL,
  description varchar(60),
  is_get boolean
)

-- 一些测试数据
-- INSERT INTO `health` VALUES (4, 36.8, 70, 120, '2022-5-5', '该病人身体状况良好');
-- 
-- INSERT INTO `health` VALUES (7, 36.6, 70, 120, '2022-5-5', '该病人身体状况良好');
-- INSERT INTO `health` VALUES (3, 35, 10, 180, '2022-5-5', '该病人身体状况良好');
-- INSERT INTO `health` VALUES (5, 35, 10, 180, '2022-5-5', '该病人身体状况良好');