DROP TABLE IF EXISTS `elderly_nursing_record`;
CREATE TABLE `elderly_nursing_record`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `tenant_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '机构ID（多租户）',
  `elder_id` bigint(20) NOT NULL COMMENT '长者ID',
  `elder_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '长者姓名（冗余）',
  `elder_sex` tinyint(4) NULL DEFAULT NULL COMMENT '性别（冗余）1-男 2-女',
  `bed_info` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '楼层房号床号（冗余，如 3栋-2楼-201-1床）',
  `record_date` date NOT NULL COMMENT '记录日期',
  `record_time` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '记录时间 HH:mm',
  `temperature` decimal(4, 1) NULL DEFAULT NULL COMMENT '体温 ℃',
  `blood_oxygen` smallint(6) NULL DEFAULT NULL COMMENT '血氧 Spo2 %',
  `pulse` smallint(6) NULL DEFAULT NULL COMMENT '脉搏 次/分',
  `respiration` smallint(6) NULL DEFAULT NULL COMMENT '呼吸 次/分',
  `systolic_pressure` smallint(6) NULL DEFAULT NULL COMMENT '收缩压 mmHg',
  `diastolic_pressure` smallint(6) NULL DEFAULT NULL COMMENT '舒张压 mmHg',
  `observation` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '病情观察及护理',
  `signer` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '签名（护理人员姓名）',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_elder_date`(`elder_id`, `record_date`) USING BTREE,
  INDEX `idx_tenant`(`tenant_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '护理记录单' ROW_FORMAT = DYNAMIC;