| 12345678910111213141516171819202122 |
- "id" "user_id" "measure_time" "type" "value" "create_user" "create_time" "update_user" "update_time" "version" "remark"
- "1988502746686595073" "1988147181088956418" "12/11/2025 00:00:00" "空腹" "6" "1" "12/11/2025 15:02:54" "1" "12/11/2025 15:02:54" "0"
- "1988502766861197314" "1988147181088956418" "12/11/2025 00:00:00" "随机" "7.6" "1" "12/11/2025 15:02:59" "1" "12/11/2025 15:02:59" "0"
- "1988502817008295937" "1988147181088956418" "5/11/2025 00:00:00" "空腹" "5.4" "1" "12/11/2025 15:03:11" "1" "12/11/2025 15:03:11" "0"
- "1988502842404806657" "1988147181088956418" "5/11/2025 00:00:00" "随机" "8.8" "1" "12/11/2025 15:03:17" "1" "12/11/2025 15:03:17" "0"
- CREATE TABLE `t_blood_glucose_data` (
- `id` bigint(20) NOT NULL COMMENT '主键ID',
- `user_id` bigint(20) NOT NULL COMMENT '用户ID',
- `measure_time` datetime NOT NULL COMMENT '测量时间',
- `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '血糖测量类型',
- `value` decimal(5,2) 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_bg_user_measure_time` (`user_id`,`measure_time`),
- KEY `idx_bg_user_id` (`user_id`),
- KEY `idx_bg_type` (`type`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='血糖数据表';
|
