Spotify

Tables (5)

Artist

  • Artist ID (AID) — VARCAHR(45) — Primary key — NOT NULL
  • Music ID (MID) — MID
  • User ID (UID) — VARCHAR(20) — Foreign key → Artists.User ID — NOT NULL

Artists

  • User ID (UID) — VARCHAR(20) — Foreign key → User.User ID — NOT NULL
  • Artist ID (AID) — VARCAHR(45)

Music

  • Music ID (MID) — MID — Primary key — NOT NULL
  • Artist ID (AID) — VARCAHR(45) — Foreign key → Artist.Artist ID — NOT NULL
  • Lyrics (LTXT) — FILE
  • View (VINT) — INT
  • Likes (LINT) — INT

Playlist

  • Playlist ID (PID) — VARCHAR(45) — Primary key — NOT NULL
  • User ID (UID) — VARCHAR(20) — Foreign key → User.User ID — NOT NULL
  • Music ID (MID) — MID

User

  • User ID (UID) — VARCHAR(20) — Primary key — NOT NULL
  • Password (UPW) — VARCHAR(45) — NOT NULL
  • Playlist ID (PID) — VARCHAR(45)
  • Liked Artists (UArt) — Array