LoGym2

Tables (7)

equipment_master

  • id — UUID
  • name — VARCHAR(100) — NOT NULL
  • target_muscle — VARCHAR(50) — NOT NULL
  • brand — VARCHAR(50)

follows

  • follower_id — UUID — Foreign key → users.id — NOT NULL
  • following_id — UUID — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP

gym_equipment

  • id — UUID
  • gym_id — UUID — Foreign key → gyms.id — NOT NULL
  • equipment_id — UUID — Foreign key → equipment_master.id — NOT NULL
  • status — VARCHAR(20)
  • requested_by — UUID — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP

gyms

  • id — UUID
  • kakao_place_id — VARCHAR(100) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • latitude — DECIMAL(10, 8) — NOT NULL
  • longitude — DECIMAL(11, 8) — NOT NULL
  • address — VARCHAR(255) — NOT NULL

users

  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_img_url — VARCHAR(255)
  • role — VARCHAR(20)
  • active_gym_id — UUID — Foreign key → gyms.id
  • active_gym_name — VARCHAR(100)
  • created_at — TIMESTAMP

workout_logs

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • gym_id — UUID — Foreign key → gyms.id
  • start_time — TIMESTAMP — NOT NULL
  • end_time — TIMESTAMP — NOT NULL
  • total_duration — INTEGER — NOT NULL
  • image_url — VARCHAR(255)
  • visibility — VARCHAR(20)
  • created_date — DATE — NOT NULL

workout_sets

  • id — UUID
  • log_id — UUID — Foreign key → workout_logs.id — NOT NULL
  • equipment_id — UUID — Foreign key → equipment_master.id — NOT NULL
  • set_number — INTEGER — NOT NULL
  • weight — DECIMAL(5, 2) — NOT NULL
  • reps — INTEGER — NOT NULL