Music Databases
Tables (4)
Album (album)
- AlbumID (album_id) — INT(9) — Primary key — NOT NULL
- Artist ID (artist_id) — INT(9) — Foreign key → Artist.Artist ID — NOT NULL
- Name (name) — VARCHAR(255)
- Collection ID (collection_id) — INT(9) — Foreign key → Collection.Collection ID — NOT NULL
Artist (artist)
- Artist ID (artist_id) — INT(9) — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
Collection (collection)
- Collection ID (collection_id) — INT(9) — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
Tracks (tracks)
- Track ID (track_id) — INT(9) — Primary key — NOT NULL
- AlbumID (album_id) — INT(9) — Foreign key → Album.AlbumID — NOT NULL
- Artist ID (artist_id) — INT(9) — Foreign key → Album.Artist ID — NOT NULL
- Name (name) — VARCHAR(255)
- Length (length) — INT(11)
- Last Played (last_played) — TIMESTAMP