2026-ECC-2-

테이블 (9)

대표곡 (rep_music)

  • rep_music_id (Key) — LONG — 기본 키
  • id (Key2) — LONG — 외래 키 → 사용자.id — NOT NULL — Auto Increment
  • music_id (Key3) — LONG — 외래 키 → 음악.music_id — NOT NULL — Auto Increment
  • rep_music_created_at (Field) — TIMESTAMP — NOT NULL
  • rep_music_updated_at (Field2) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP

반응 (reactions)

  • reaction_id (Key) — LONG — 기본 키 — NOT NULL
  • bottle_id (Key2) — LONG — 외래 키 → 유리병.bottle_id — NOT NULL — Auto Increment
  • reactor_id (Key3) — LONG — 외래 키 → 사용자.id — NOT NULL — Auto Increment
  • reaction_created_at (Field) — TIME STAMP — NOT NULL
  • reaction_updated_at (Field2) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP

북마크 (bookmarks)

  • bookmark_id (Key) — LONG — 기본 키 — NOT NULL — Auto Increment
  • id (Key2) — LONG — 외래 키 → 사용자.id — NOT NULL — Auto Increment
  • bottleId (Key3) — LONG — 외래 키 → 유리병.bottle_id — NOT NULL — Auto Increment
  • bookmark_created_at (Field) — TIMESTAMP — NOT NULL
  • bookmark_expires_at (Field2) — TIMESTAMP — NOT NULL
  • bookmark_updated_at (Field3) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP

사용자 (users)

  • id (Key) — LONG — 기본 키 — NOT NULL — Auto Increment
  • user_id (Field) — VARCHAR(20) — NOT NULL — UNIQUE
  • email (Field2) — VARCHAR(100) — NOT NULL — UNIQUE
  • password (Field3) — VARCHAR(255) — NOT NULL
  • nickname (Field4) — VARCHAR(10) — NOT NULL
  • profileImage (Field5) — VARCHAR(500)
  • bio (Field6) — VARCHAR(50)
  • created_at (Field9) — TIMESTAMP — NOT NULL
  • updated_at (Field10) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP

오늘의 질문 (today_quests)

  • question_id (Key) — LONG — 기본 키 — NOT NULL — Auto Increment
  • question_text (Field) — TEXT — NOT NULL
  • date (Field2) — DATE — NOT NULL — UNIQUE
  • question_created_at (Field3) — TIMESTAMP — NOT NULL
  • question_updated_at (Field4) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP

유리병 (bottles)

  • bottle_id (Key) — LONG — 기본 키 — NOT NULL — Auto Increment
  • id (Key2) — LONG — 외래 키 → 사용자.id — NOT NULL — Auto Increment
  • question_id (Key3) — LONG — 외래 키 → 오늘의 질문.question_id — NOT NULL — Auto Increment
  • music_id (Key4) — LONG — 외래 키 → 음악.music_id — NOT NULL — Auto Increment
  • memo (Field) — VARCHAR(200)
  • is_shared (Field2) — BOOLEAN — NOT NULL
  • total_count (Field3) — INT — NOT NULL
  • bottle_created_at (Field4) — TIMESTAMP — NOT NULL
  • bottle_updated_at (Field5) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP

음악 (musics)

  • music_id (Key) — LONG — 기본 키 — NOT NULL — Auto Increment
  • track_name (Field) — VARCHAR(200) — NOT NULL
  • artist_name (Field2) — VARCHAR(200) — NOT NULL
  • album_cover_url (Field3) — VARCHAR(500)
  • itunes_track_id (Field4) — VARCHAR(200) — NOT NULL — UNIQUE
  • music_created_at (Field5) — TIMESTAMP — NOT NULL
  • music_updates_at (Field6) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP

음악 플랫폼 (platforms)

  • platform_id (Key) — LONG — 기본 키 — NOT NULL — Auto Increment
  • id (Key2) — LONG — 외래 키 → 사용자.id — NOT NULL — Auto Increment
  • platform_name (Field) — NOT NULL
  • platform_nickname (Field2)
  • platform_created_at (Field3) — NOT NULL
  • platform_updated_at (Field4) — ON UPDATE CURRENT_TIMESTAMP

친구 (friendships)

  • friend_request_id (Key) — LONG — 기본 키 — NOT NULL — Auto Increment
  • friendship_status (Field) — VARCHAR(20) — NOT NULL
  • requested_at (Field3) — TIMESTAMP
  • unfriend_at (Field5) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP
  • updated_at (Field4) — TIMESTAMP — ON UPDATE CURRENT_TIMESTAMP
  • requester_id (Key2) — LONG — 외래 키 → 사용자.id — NOT NULL — Auto Increment
  • receiverId (Key3) — LONG — 외래 키 → 사용자.id — NOT NULL — Auto Increment