fitu

Tables (16)

friendships

  • id — BIGINT — Primary key — NOT NULL
  • user_id_a — BIGINT — Foreign key → users.id
  • user_id_b — BIGINT — Foreign key → users.id

media_files

  • id — BIGINT — Primary key — NOT NULL
  • uploader_id — BIGINT — Foreign key → users.id
  • url — VARCHAR(500)
  • uploaded_at — DATETIME
  • category — VARCHAR(50)

physical_infos

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • recorded_at — DATETIME
  • body_fat — INT
  • muscle — INT
  • height — INT
  • weight — INT

post_comments

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → posts.id
  • writer_id — BIGINT — Foreign key → users.id
  • root_id — BIGINT
  • contents — TEXT
  • created_at — DATETIME
  • is_secret — TINYINT(1)

posts

  • id — BIGINT — Primary key — NOT NULL
  • category — VARCHAR(50)
  • university_id — BIGINT — Foreign key → universities.id
  • writer_id — BIGINT — Foreign key → users.id
  • title — VARCHAR(255)
  • contents — TEXT
  • created_at — DATETIME

reports

  • id — BIGINT — Primary key — NOT NULL
  • reporter_id — BIGINT — Foreign key → users.id
  • target_id — BIGINT
  • target_type — VARCHAR(50)
  • created_at — DATETIME

session_exercises

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → sessions.id
  • workout_id — BIGINT — Foreign key → workouts.id
  • order_index — INT

sessions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • start_time — DATETIME
  • end_time — DATETIME
  • exercise_image_id — BIGINT — Foreign key → media_files.id

sets

  • id — BIGINT — Primary key — NOT NULL
  • session_exercise_id — BIGINT — Foreign key → session_exercises.id
  • set_index — INT
  • weight — INT
  • reps — INT

universities

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • domain_name — VARCHAR(255)

users

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • gender — VARCHAR(50)
  • kakao_email — VARCHAR(255)
  • role — VARCHAR(50)
  • friend_code — VARCHAR(255)
  • status — VARCHAR(50)
  • suspend_end_at — DATETIME
  • university_id — BIGINT — Foreign key → universities.id
  • university_email — VARCHAR(255)
  • profile_img_id — BIGINT — Foreign key → media_files.id
  • profile_visibility — TINYINT(1)

workout_categories

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50)
  • priority — INT

workout_detail_logs

  • id — BIGINT — Primary key — NOT NULL
  • workout_log_id — BIGINT — Foreign key → workout_logs.id
  • workout_id — BIGINT — Foreign key → workouts.id
  • weight — INT
  • num_of_sets — INT
  • reps_per_set — INT

workout_logs

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • date — DATETIME

workout_verifications

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • video_id — BIGINT — Foreign key → media_files.id
  • workout_type — VARCHAR(50)
  • request_date — DATETIME
  • status — VARCHAR(50)
  • weight — INT

workouts

  • id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → workout_categories.id
  • equipment_id — BIGINT
  • name — VARCHAR(50)
  • workout_name — VARCHAR(255)
  • description — VARCHAR(1000)
  • image_id — BIGINT — Foreign key → media_files.id
  • image_url — VARCHAR(500)
  • gif_id — BIGINT — Foreign key → media_files.id
  • gif_url — VARCHAR(500)