doit

SSAFY 2학기 관통프로젝트 Do it 2026_07_24 기준 ERD

테이블 (19)

exercises

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • category — VARCHAR(30) — NOT NULL
  • description — TEXT — NOT NULL
  • guide_video_file_id — CHAR(36) — 외래 키 → files.id — NOT NULL
  • exercise_image_file_id — CHAR(36) — 외래 키 → files.id — NOT NULL

faqs

  • id — BIGINT — 기본 키 — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • question — VARCHAR(500) — NOT NULL
  • answer — TEXT — NOT NULL

files

  • id — CHAR(36) — 기본 키 — NOT NULL
  • owner_user_id — BIGINT — 외래 키 → users.id
  • purpose — VARCHAR(30) — NOT NULL
  • storage_key — VARCHAR(1024) — NOT NULL
  • original_name — VARCHAR(255) — NOT NULL
  • content_type — VARCHAR(255) — NOT NULL
  • size_bytes — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • expires_at — DATETIME(3)
  • created_at — DATETIME(3) — NOT NULL

inquiries

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • answer — TEXT
  • file_id — CHAR(36) — 외래 키 → files.id
  • answered_at — DATETIME(3)
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL

notifications

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • message — TEXT — NOT NULL
  • reference_type — VARCHAR(30)
  • reference_id — BIGINT
  • read_at — DATETIME(3)
  • created_at — DATETIME(3) — NOT NULL

oauth_accounts

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • provider_profile_image_url — VARCHAR(2048)

push_tokens

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • token — VARCHAR(512) — NOT NULL
  • platform — VARCHAR(20) — NOT NULL
  • active — BOOLEAN — NOT NULL
  • last_seen_at — DATETIME(3) — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL

terms

  • id — BIGINT — 기본 키 — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • version — VARCHAR(30) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — LONGTEXT — NOT NULL

user_follows

  • follower_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • following_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • created_at — DATETIME(3) — NOT NULL

user_preferences

  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • workout_notifications_enabled — BOOLEAN — NOT NULL
  • weekly_goal_days — INT
  • updated_at — DATETIME(3) — NOT NULL

user_term_agreements

  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • term_id — BIGINT — 외래 키 → terms.id — NOT NULL
  • agreed_at — DATETIME(3) — NOT NULL

users

  • id — BIGINT — 기본 키 — NOT NULL
  • nickname — VARCHAR(16)
  • gender — VARCHAR(1)
  • birth_date — DATE
  • height_cm — DECIMAL(5, 2)
  • weight_kg — DECIMAL(5, 2)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3)

workout_invitations

  • id — BIGINT — 기본 키 — NOT NULL
  • sender_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • receiver_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • workout_routine_id — BIGINT — 외래 키 → workout_routines.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • responded_at — DATETIME(3)
  • created_at — DATETIME(3) — NOT NULL

workout_routine_exercise_sets

  • id — BIGINT — 기본 키 — NOT NULL
  • workout_routine_exercise_id — BIGINT — 외래 키 → workout_routine_exercises.id — NOT NULL
  • set_order — INT — NOT NULL
  • target_weight_kg — DECIMAL(6, 2)
  • target_reps — INT
  • rest_seconds — INT

workout_routine_exercises

  • id — BIGINT — 기본 키 — NOT NULL
  • workout_routine_id — BIGINT — 외래 키 → workout_routines.id — NOT NULL
  • exercise_id — BIGINT — 외래 키 → exercises.id — NOT NULL
  • exercise_order — INT — NOT NULL

workout_routines

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • name — VARCHAR(30) — NOT NULL

workout_session_exercises

  • id — BIGINT — 기본 키 — NOT NULL
  • workout_session_id — BIGINT — 외래 키 → workout_sessions.id — NOT NULL
  • workout_routine_exercise_id — BIGINT — 외래 키 → workout_routine_exercises.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • analysis_summary — TEXT
  • started_at — DATETIME(3)
  • completed_at — DATETIME(3)

workout_session_sets

  • id — BIGINT — 기본 키 — NOT NULL
  • workout_session_exercise_id — BIGINT — 외래 키 → workout_session_exercises.id — NOT NULL
  • workout_routine_exercise_set_id — BIGINT — 외래 키 → workout_routine_exercise_sets.id — NOT NULL
  • actual_weight_kg — DECIMAL(6, 2)
  • actual_reps — INT
  • actual_rest_seconds — INT
  • duration_seconds — INT
  • posture_score — DECIMAL(5, 2)
  • analysis_status — VARCHAR(20) — NOT NULL
  • feedback — TEXT
  • replay_file_id — CHAR(36) — 외래 키 → files.id

workout_sessions

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • workout_routine_id — BIGINT — 외래 키 → workout_routines.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • started_at — DATETIME(3)
  • ended_at — DATETIME(3)