Music library MySQL database

Something like this would be good to start with. It specifies a table for artists, albums (with keys into artists and genres), tracks (keyed into albums), and genres.

Table artists----id (primary key),namedescriptionyears_activeotherinfo (whatever you need)Table albums----id (primary key)artistid (foreign key to artists table)name,releasedategenreid (foreign key to genres table)pictureTable tracks----id (primary key)albumid (foreign key to albums table)nameoverride_artist (overrides album artist if not null)playtimelyricotherstuff as neededTable genres----id (primary key)namedescription

I suggest the following database structure:

artist { id, name }genre { id, name }album { id, name, artist_id, release_date, genre_id, picture_url }track { id, album_id, number, name, playtime, lyrics }

Artist ( ArtistID INT PRIMARY KEY, ArtistName )Genre ( GenreID TINYINT PRIMARY KEY, GenreDescription )Album ( AlbumID INT PRIMARY KEY, ArtistID INT, GenreID INT ReleaseDate )AlbumArt ( AlbumArtID INT PRIMARY KEY, AlbumID INT, AlbumArtPath )Track ( AlbumID INT, TrackNumber INT, TrackName, PlayTime, Lyrics , PRIMARY KEY ( AlbumID, TrackNumber ) )