音乐库MySQL数据库

Question

我需要一些帮助建立一个表(S)的音乐数据库在MySQL。我不确定如何在表格中列出这些信息。

这是我想要存储在数据库中的信息。

Artist Name
Album Name
Release Date
Genre
Picture URL (album artwork)

Track Number
Trank Name
Track Playtime
Lyric (optional, But would like to have it someday)

etc.

基本上，这一切都与组织数字音乐有关。我是数据库的新手，我有一些想法。但是，如果我要学习的话，我还不如学习正确的方法。

任何关于如何设计我的表格的想法都将是很棒的。

Answer 1

像这样的东西将是一个很好的开始。它为艺术家、专辑(带有进入艺术家和风格的关键字)、曲目(进入专辑)和风格指定了一个表。

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

Answer 2

我建议使用以下数据库结构：

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 }

Answer 3

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