MML

Tables (4)

Music (음악)

  • id (music_id) — big int — Primary key — NOT NULL
  • title — varchar(255)
  • artist — varchar(255)
  • url — varchar(255)

Music_PlayList (음악 플레이리스트)

  • id (mp_id) — big int — Primary key — NOT NULL
  • id (playlist_id) — big int — Foreign key → Playlist.id — NOT NULL
  • id (music_id) — big int — Foreign key → Music.id — NOT NULL

Playlist (플레이리스트)

  • id (playlist_id) — big int — Primary key — NOT NULL
  • id (user_id) — big int — Foreign key → User.id — NOT NULL
  • name — varchar(255)

User (사용자)

  • id (user_id) — big int — Primary key — NOT NULL
  • email — varchar(255)
  • password — varchar(255)