ChronicDisease_SpringBoot/docs/DataBase/t_blood_glucose_data.txt

CREATE TABLE `t_blood_glucose_data` (
  `id` BIGINT NOT NULL COMMENT '主键ID',
  `user_id` BIGINT NOT NULL COMMENT '用户ID',
  `measure_time` DATETIME NOT NULL COMMENT '测量时间',
  `type` VARCHAR(50) NOT NULL COMMENT '血糖测量类型',
  `value` DECIMAL(5,2) 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_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='血糖数据表';