Coffeehouse Post

Single Post Permalink

View Thread: when ID3 is not enought
  • User profile image
    Ion Todirel

    hey, i want some suggestions about what info about music should i store:

    I have three tables: Artist, Album and Song, what do you think what cols this tables should have?

    Artist or Band: ID, Name, Picture, Bio, Top Albums, Top Songs, Active Years, Country, Genre(s), Style(s), ...

    Album: ID, Name, Picture, Artist ID, Review, Year, Rating, Lenght, ...

    Song or Track: ID (this scheme will also have a Playlist table), Name, Album ID, Rating, Lenght, Bitrate, Composer, Genre, Style, Track #, Location, Comment, ...

    What else to store, what not to store? thanks.