운동할걸2
테이블 (6)
EXERCISE (운동)
- exercise_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- category — VARCHAR(50)
- difficulty — VARCHAR(20)
- target_area — VARCHAR(50)
EXERCISE_VIDEO (운동영상)
- video_id — BIGINT — 기본 키 — NOT NULL
- exercise_id — BIGINT — 외래 키 → EXERCISE.exercise_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- youtube_url — VARCHAR(500) — NOT NULL
- thumbnail_path — VARCHAR(500) — NOT NULL
- video_sequence — INT
MEMBER (멤버)
- member_id — BIGINT — 기본 키 — NOT NULL
- Key — 기본 키 — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50)
- role — VARCHAR(20)
- created_at — DATETIME
MEMBER_SURVEY_RESPONSE (멤버설문응답)
- response_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → MEMBER.member_id — NOT NULL
- question_id — BIGINT — 외래 키 → SURVEY_QUESTION.question_id — NOT NULL
- created_at — DATETIME
- Key — 외래 키 → MEMBER.Key — NOT NULL
RECOMMENDATION_HISTORY (추천기록)
- history_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → MEMBER.member_id — NOT NULL
- exercise_id — BIGINT — 외래 키 → EXERCISE.exercise_id — NOT NULL
- recommended_at — DATETIME
- Key — 외래 키 → MEMBER.Key — NOT NULL
SURVEY_QUESTION (질문)
- question_id — BIGINT — 기본 키 — NOT NULL
- question_text — VARCHAR(255) — NOT NULL
- step_order — INT — NOT NULL
- is_active — CHAR(1)