운동할걸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)