music

Tables (4)

Mood (mood)

  • moodID — Primary key — NOT NULL
  • name

Music (music)

  • musicID — Primary key — NOT NULL
  • moodID — Foreign key → Mood.moodID — NOT NULL
  • name
  • artist
  • ReleaseDate (RelDate)

Playlist (playlist)

  • listID — Primary key — NOT NULL
  • UserID (Userid) — Foreign key → User.UserID — NOT NULL
  • musicID — Foreign key → Music.musicID — NOT NULL
  • moodID — Foreign key → Music.moodID — NOT NULL
  • name
  • contants

User (user)

  • UserID (Userid) — Primary key — NOT NULL
  • name
  • gender
  • email
  • pwd