MusicMe
Tables (4)
album
- album_id — VARCHAR(255) — Primary key — NOT NULL
- album_name — VARCHAR(255)
- artist_id — VARCHAR(255) — Foreign key → artist.artist_id — NOT NULL
- track_id — VARCHAR(255) — Foreign key → track.track_id — NOT NULL
artist
- artist_id — VARCHAR(255) — Primary key — NOT NULL
- first_name — VARCHAR(255)
- last_name — VARCHAR(255)
- album_id — VARCHAR(255) — Foreign key → album.album_id — NOT NULL
played
- track_id — VARCHAR(255) — Foreign key → track.track_id — NOT NULL
- count — INT(8)
- timestamp — VARCHAR(255) — NOT NULL
track
- track_id — VARCHAR(255) — Primary key — NOT NULL
- track_name — VARCHAR(255)
- track_time — VARCHAR(255)
- album_id — VARCHAR(255) — Foreign key → album.album_id — NOT NULL