Miscellany

t1:artists[pk(artistid),uniqueIndex(name)]
t2:albumsorsamplers[pk(albumorsamplerid),uniqueIndex(name)]
t3:songs[pk(songid),uniqueIndex(name)]
t4:genres[pk(genreid),uniqueIndex(name)]
t5:submitters[pk(submitterid),uniqueIndex(name),submitcounter]

t6:song2artist[pk(fk(songid),fk(artistid)),playtime]
t7:artist2album[pk(fk(artistid),fk(albumorsamplerid))]
t8:song2artist2album2track[pk(song2artist2album2trackid),uniqueIndex(fk(songid),fk(artistid),fk(artistid),fk(albumorsamplerid),track)]
t9:song2artist2genrevotes[pk(fk(songid),fk(artistid),fk(genreid)),votes]
t10:cds[pk(cdid),uniqueIndex(discid,albumorsamplerid),plength,fk_t5(submitterid]
t11:cds2year2genrevotes[pk(fk(cdid),year,fk(genreid)),votes]
t12:cdtracks[pk(fk(cdid),fk(song2artist2album2trackid))),offset]