music

Tables (8)

listening

  • id (Key) — Primary key — NOT NULL
  • session_id (Key4) — Foreign key → session.id — NOT NULL
  • user_id (Key3) — Foreign key → user.id — NOT NULL
  • track_id (Key2) — Foreign key → track.id — NOT NULL

playlist

  • id (Key) — Primary key — NOT NULL
  • Field

playlist_track

  • id (Key) — Primary key — NOT NULL
  • playlist_id (Key3) — Foreign key → playlist.id — NOT NULL
  • track_id (Key2) — Foreign key → track.id — NOT NULL
  • Field

session

  • id (Key) — Primary key — NOT NULL
  • Field

session_user

  • id (Key) — Primary key — NOT NULL
  • session_id (Key2) — Foreign key → session.id — NOT NULL
  • user_id (Key3) — Foreign key → user.id — NOT NULL
  • Field

track

  • id (Key) — Primary key — NOT NULL
  • Field

user

  • id (Key) — Primary key — NOT NULL
  • Field

user_playlist

  • id (Key) — Primary key — NOT NULL
  • user_id (Key3) — Foreign key → user.id — NOT NULL
  • playlist_id (Key2) — Foreign key → playlist.id — NOT NULL
  • Field