Biblioteka muzyczna Baza danych 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)

pictureTable tracks

----

id (primary key)

albumid (foreign key to albums table)

name

override_artist (overrides album artist if not null)

playtime

lyric

otherstuff as neededTable 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 ) )