ChronicDisease_SpringBoot/docs/DataBase/t_blood_pressure_data.txt

CREATE TABLE `t_blood_pressure_data` (
  `id` BIGINT NOT NULL COMMENT '主键ID',
  `user_id` BIGINT NOT NULL COMMENT '用户ID',
  `systolic_pressure` INT COMMENT '收缩压(mmHg)',
  `diastolic_pressure` INT COMMENT '舒张压(mmHg)',
  `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_bp_user_measure_time` (`user_id`, `measure_time`),
  KEY `idx_bp_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='血压数据表';