| 123456789101112131415161718 |
- "id" "user_id" "heart_rate" "measure_time" "create_user" "create_time" "update_user" "update_time" "version" "remark"
- "1988498386246213634" "1988147181088956418" "72" "12/11/2025 00:00:00" "1" "12/11/2025 14:45:34" "1" "12/11/2025 14:45:34" "0"
- "1988498431406284802" "1988147181088956418" "54" "11/11/2025 00:00:00" "1" "12/11/2025 14:45:45" "1" "12/11/2025 14:45:45" "0"
- CREATE TABLE `t_heart_rate_data` (
- `id` bigint(20) NOT NULL COMMENT '主键ID',
- `user_id` bigint(20) NOT NULL COMMENT '用户ID',
- `heart_rate` int(11) DEFAULT NULL COMMENT '心率(次/分钟)',
- `measure_time` datetime NOT NULL COMMENT '测量时间',
- `create_user` bigint(20) DEFAULT NULL COMMENT '创建者ID',
- `create_time` datetime DEFAULT NULL COMMENT '创建时间',
- `update_user` bigint(20) DEFAULT NULL COMMENT '更新者ID',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `version` int(11) DEFAULT '0' COMMENT '乐观锁版本号',
- `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL 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='心率数据表';
|