헬스ERD

테이블 (10)

Diet_Logs

  • diet_id — INT
  • user_id — INT — 외래 키 → Users.user_id — NOT NULL
  • date — DATE — NOT NULL
  • meal_time — ENUM('BREAKFAST', 'LUNCH', 'DINNER', 'SNACK')
  • calories — INT
  • description — TEXT

Equipment_Reports

  • report_id — INT
  • equipment_id — INT — 외래 키 → Gym_Equipment.equipment_id — NOT NULL
  • reporter_id — INT — 외래 키 → Users.user_id — NOT NULL
  • assignee_id — INT — 외래 키 → Users.user_id
  • issue_detail — TEXT — NOT NULL
  • report_status — ENUM('PENDING', 'IN_PROGRESS', 'RESOLVED')
  • created_at — TIMESTAMP

Exercise_Logs

  • log_id — INT
  • user_id — INT — 외래 키 → Users.user_id — NOT NULL
  • exercise_id — INT — 외래 키 → Exercises.exercise_id — NOT NULL
  • date — DATE — NOT NULL
  • weight — FLOAT
  • sets — INT
  • reps — INT
  • distance — FLOAT
  • speed — FLOAT
  • duration — INT

Exercises

  • exercise_id — INT
  • name — VARCHAR(100) — NOT NULL
  • category — ENUM('WEIGHT', 'CARDIO') — NOT NULL

Gym_Equipment

  • equipment_id — INT
  • gym_id — INT — 외래 키 → Gyms.gym_id — NOT NULL
  • exercise_id — INT — 외래 키 → Exercises.exercise_id — NOT NULL
  • serial_number — VARCHAR(50)
  • status — ENUM('NORMAL', 'BROKEN', 'REPAIRING')
  • purchase_date — DATE
  • last_check_date — DATE

Gyms

  • gym_id — INT
  • gym_name — VARCHAR(100) — NOT NULL
  • location — VARCHAR(255)
  • created_at — TIMESTAMP

Missions

  • mission_id — INT
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • category — ENUM('WEIGHT', 'CARDIO', 'ATTENDANCE') — NOT NULL
  • base_exp_reward — INT

Trainer_Student

  • id — INT
  • trainer_id — INT — 외래 키 → Users.user_id — NOT NULL
  • member_id — INT — 외래 키 → Users.user_id — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE')
  • start_date — DATE

User_Missions

  • user_mission_id — INT
  • user_id — INT — 외래 키 → Users.user_id — NOT NULL
  • mission_id — INT — 외래 키 → Missions.mission_id — NOT NULL
  • target_value — FLOAT — NOT NULL
  • current_value — FLOAT
  • status — ENUM('PROGRESS', 'COMPLETED', 'FAILED')
  • exp_reward — INT
  • assigned_at — TIMESTAMP
  • completed_at — TIMESTAMP

Users

  • user_id — INT
  • gym_id — INT — 외래 키 → Gyms.gym_id
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — ENUM('MEMBER', 'TRAINER', 'ADMIN')
  • level — INT
  • exp — INT
  • created_at — TIMESTAMP