"id" "user_id" "height" "weight" "measure_time" "create_user" "create_time" "update_user" "update_time" "version" "remark" "1988449152629252097" "1988147181088956418" "155" "65" "9/11/2025 00:00:00" "1" "12/11/2025 11:29:56" "1" "12/11/2025 11:29:56" "0" "1988456421005795330" "1988147181088956418" "177" "90" "12/11/2025 00:00:00" "1" "12/11/2025 11:58:49" "1" "12/11/2025 11:58:49" "0" "1989581733017985026" "1988147181088956418" "170" "78" "15/11/2025 00:00:00" "1" "15/11/2025 14:30:24" "1" "15/11/2025 14:30:24" "0" CREATE TABLE `t_physical_data` ( `id` bigint(20) NOT NULL COMMENT '主键ID', `user_id` bigint(20) NOT NULL COMMENT '用户ID', `height` decimal(5,2) DEFAULT NULL COMMENT '身高(cm)', `weight` decimal(5,2) DEFAULT NULL COMMENT '体重(kg)', `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_physical_user_measure_time` (`user_id`,`measure_time`), KEY `idx_physical_user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='体格数据表';