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
- pwd