zrd-nb666/campus_health_app/backend/database/training_logs.sql

CREATE TABLE IF NOT EXISTS `training_logs` (
  `id` VARCHAR(36) NOT NULL,
  `user_id` VARCHAR(36) NOT NULL DEFAULT 'synthetic-user-001',
  `log_date` DATE NOT NULL,
  `exercise_name` VARCHAR(100) NOT NULL,
  `weight_kg` DECIMAL(6,1) DEFAULT NULL,
  `reps` INT DEFAULT NULL,
  `rpe` TINYINT DEFAULT NULL COMMENT '主观发力 1-10',
  `notes` VARCHAR(255) DEFAULT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_user_date` (`user_id`, `log_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;