5월 최종보고서

테이블 (5)

Untitled (emotion)

  • id — BIGINT — 외래 키 → diaries.id — NOT NULL
  • Field (JOY)
  • Field2 (LOVE)
  • Field3 (PEACE)
  • Field (NEUTRAL)
  • Field2 (ANXIETY)
  • Field3 (SADNESS)
  • Field4 (ANGER)

Untitled (Counselor Type)

  • id — BIGINT — 외래 키 → users.id — NOT NULL
  • Field (FRIEND/MENTOR)
  • Field2 (ANALYST/OPTIMIST)

diaries (감정 일기)

  • id — BIGINT — 외래 키 → users.id — NOT NULL
  • user_id — BIGINT NOT NULL
  • diary_date — DATE NOT NULL
  • content — TEXT NOT NULL
  • emotion — VARCHAR
  • comfort_letter — TEXT
  • strength_point — TEXT
  • advice — TEXT

music (음악)

  • id — BIGINT — 외래 키 → Untitled.id — NOT NULL
  • recommended_track — VARCHAR
  • recommended_artist — VARCHAR
  • youtube_video_id — VARCHAR
  • youtube_url — VARCHAR
  • playlist_title — VARCHAR
  • playlist_subtitle — VARCHAR
  • created_at — DATETIME
  • updated_at — DATETIME

users (사용자)

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR NOT NULL
  • password — VARCHAR NOT NULL
  • nickname — VARCHAR NOT NULL
  • counselor_type — VARCHAR
  • favorite_genres — VARCHAR
  • favorite_artists — VARCHAR
  • created_at — DATETIME
  • updated_at — DATETIME