曲库 MySQL 数据库

Table artists

----

id /primary key/,

name

description

years_active

otherinfo /whatever you need/



Table albums

----

id /primary key/

artistid /foreign key to artists table/

name,

releasedate

genreid /foreign key to genres table/

picture



Table tracks

----

id /primary key/

albumid /foreign key to albums table/

name

override_artist /overrides album artist if not null/

playtime

lyric

otherstuff as needed



Table genres

----

id /primary key/

name

description

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 / /