playlist-maker

테이블 (3)

Untitled (music)

  • Key (music_id) — bigint — 기본 키 — NOT NULL
  • Field (yt_video_id) — varchar(45) — NOT NULL
  • Field (thumbnail_path) — varchar(512) — NOT NULL

Untitled (official_tag)

  • Key (music_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (artist_id) — bigint — NOT NULL
  • Field (artist_name) — varchar(45) — NOT NULL
  • Field (album_id) — bigint — NOT NULL
  • Field (album_name) — varchar(128) — NOT NULL
  • Field (title) — varchar(128) — NOT NULL
  • Field (lyrics) — varchar(1024)
  • Field (duration) — time — NOT NULL
  • Field (published_at) — date — NOT NULL

사용자 (user)

  • (user_id) — bigint — 기본 키 — NOT NULL
  • Field (yt_channel_id) — varchar(45) — NOT NULL
  • Field