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)