"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='血糖数据表';