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