ChronicDisease_SpringBoot/docs/OLD/DataBase/t_physical_data.txt

CREATE TABLE `t_physical_data` (
  `id` BIGINT NOT NULL COMMENT '主键ID',
  `user_id` BIGINT NOT NULL COMMENT '用户ID',
  `height` DECIMAL(5,2) COMMENT '身高(cm)',
  `weight` DECIMAL(5,2) COMMENT '体重(kg)',
  `measure_time` DATETIME NOT NULL COMMENT '测量时间',
  `create_user` BIGINT COMMENT '创建者ID',
  `create_time` DATETIME COMMENT '创建时间',
  `update_user` BIGINT COMMENT '更新者ID',
  `update_time` DATETIME COMMENT '更新时间',
  `version` INT DEFAULT 0 COMMENT '乐观锁版本号',
  `remark` VARCHAR(255) 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='体格数据表';