ChronicDisease_SpringBoot/docs/DataBase/t_heart_rate_data.txt

CREATE TABLE `t_heart_rate_data` (
  `id` BIGINT NOT NULL COMMENT '主键ID',
  `user_id` BIGINT NOT NULL COMMENT '用户ID',
  `heart_rate` INT COMMENT '心率(次/分钟)',
  `measure_time` DATETIME NOT NULL COMMENT '测量时间',
  `create_user` BIGINT COMMENT '创建者ID',
  `create_time` DATETIME COMMENT '创建时间',
  `update_user` BIGINT COMMENT '更新者ID',
  `update_time` DATETIME COMMENT '更新时间',
  `version` INT DEFAULT 0 COMMENT '乐观锁版本号',
  PRIMARY KEY (`id`),
  KEY `idx_hr_user_measure_time` (`user_id`, `measure_time`),
  KEY `idx_hr_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='心率数据表';