Webapp

Tables (5)

COMMENT

  • comment_id — INT
  • playlist_id — INT — Foreign key → PLAYLIST.playlist_id — NOT NULL
  • user_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME

LIKE_LIST

  • like_id — INT
  • playlist_id — INT — Foreign key → PLAYLIST.playlist_id — NOT NULL
  • user_id — INT — NOT NULL
  • created_at — DATETIME

PLAYLIST

  • playlist_id — INT
  • user_id — INT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • genre — VARCHAR(50)
  • created_at — DATETIME

PLAYLIST_SONG

  • playlist_song_id — INT
  • playlist_id — INT — Foreign key → PLAYLIST.playlist_id — NOT NULL
  • song_id — INT — Foreign key → SONG.song_id — NOT NULL

SONG

  • song_id — INT
  • title — VARCHAR(100) — NOT NULL
  • artist — VARCHAR(100) — NOT NULL
  • album — VARCHAR(100)
  • genre — VARCHAR(50)