| 1234567891011121314151617181920 |
- "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='体格数据表';
|
