t_heart_rate_data.txt 1.2 KB

123456789101112131415161718
  1. "id" "user_id" "heart_rate" "measure_time" "create_user" "create_time" "update_user" "update_time" "version" "remark"
  2. "1988498386246213634" "1988147181088956418" "72" "12/11/2025 00:00:00" "1" "12/11/2025 14:45:34" "1" "12/11/2025 14:45:34" "0"
  3. "1988498431406284802" "1988147181088956418" "54" "11/11/2025 00:00:00" "1" "12/11/2025 14:45:45" "1" "12/11/2025 14:45:45" "0"
  4. CREATE TABLE `t_heart_rate_data` (
  5. `id` bigint(20) NOT NULL COMMENT '主键ID',
  6. `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  7. `heart_rate` int(11) DEFAULT NULL COMMENT '心率(次/分钟)',
  8. `measure_time` datetime NOT NULL COMMENT '测量时间',
  9. `create_user` bigint(20) DEFAULT NULL COMMENT '创建者ID',
  10. `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  11. `update_user` bigint(20) DEFAULT NULL COMMENT '更新者ID',
  12. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  13. `version` int(11) DEFAULT '0' COMMENT '乐观锁版本号',
  14. `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  15. PRIMARY KEY (`id`),
  16. KEY `idx_hr_user_measure_time` (`user_id`,`measure_time`),
  17. KEY `idx_hr_user_id` (`user_id`)
  18. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='心率数据表';