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