ㅎㅎ

Tables (8)

audit_logs

  • id — BIGINT
  • user_id — VARCHAR(36)
  • event_type — VARCHAR(100)
  • event_json — JSON
  • created_at — TIMESTAMP

exercises

  • exercise_id — VARCHAR(36)
  • name — VARCHAR(200) — NOT NULL
  • target_muscles — JSON
  • secondary_muscles — JSON
  • equipment — JSON
  • difficulty — TINYINT
  • recommended_sets — INT
  • recommended_reps — VARCHAR(50)
  • rest_time_sec — INT
  • recovery_time_hours — INT
  • demo_video_url — VARCHAR(400)
  • contraindications — JSON
  • tags — JSON

muscle_state_cache

  • id — BIGINT
  • user_id — VARCHAR(36) — NOT NULL
  • date — DATE — NOT NULL
  • muscle — VARCHAR(100) — NOT NULL
  • recovery_score — DECIMAL(5,4)
  • fatigue_contrib — DECIMAL(8,3)
  • updated_at — TIMESTAMP

rehab_profiles

  • profile_id — VARCHAR(36)
  • name — VARCHAR(200) — NOT NULL
  • target_conditions — JSON
  • template_json — JSON
  • safety_notes — TEXT
  • last_updated — TIMESTAMP

user_daily_status

  • id — BIGINT
  • user_id — VARCHAR(36) — NOT NULL
  • date — DATE — NOT NULL
  • sleep_hours — DECIMAL(4,2)
  • rpe — TINYINT
  • stress_level — TINYINT
  • pain_scores — JSON
  • note — TEXT
  • created_at — TIMESTAMP

user_workout_sessions

  • session_id — VARCHAR(36)
  • user_id — VARCHAR(36) — NOT NULL
  • date — TIMESTAMP
  • plan_json — JSON
  • actual_json — JSON
  • duration_seconds — INT
  • completed — BOOLEAN
  • pain_reported — BOOLEAN
  • created_at — TIMESTAMP

user_workout_sets

  • set_id — BIGINT
  • session_id — VARCHAR(36) — NOT NULL
  • user_id — VARCHAR(36) — NOT NULL
  • exercise_id — VARCHAR(36)
  • set_index — SMALLINT
  • reps — SMALLINT
  • weight — DECIMAL(8,3)
  • tempo — VARCHAR(50)
  • rpe — TINYINT
  • pain_during_set — TINYINT
  • created_at — TIMESTAMP

users

  • user_id — VARCHAR(36)
  • email — VARCHAR(255)
  • password_hash — VARCHAR(255)
  • created_at — TIMESTAMP
  • name — VARCHAR(100)
  • birthdate — DATE
  • sex — VARCHAR(10)
  • height_cm — INT
  • weight_kg — DECIMAL(6,2)
  • experience_level — TINYINT
  • main_goal — VARCHAR(50)
  • equipment — JSON
  • medical_flags — JSON
  • preferred_split — JSON
  • locale — VARCHAR(10)
  • last_active — TIMESTAMP