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