t0:strings[pk(stringid),uniqueIndex(mystring)] t1:artists[pk(artistid),stringid] t2:albumsorsamplers[pk(albumorsamplerid),stringid] t3:songs[pk(songid),stringid] t4:song2artist[pk(fk(songid),fk(artistid)),playtime] t5:artist2album[pk(fk(artistid),fk(albumorsamplerid))] t6:song2album2track[pk(fk(songid),fk(albumorsamplerid)),track)] t7:song2artist2genrevotes[pk(fk(songid),fk(artistid),fk(genreid)),votes] t8:cds[pk(discid,albumorsamplerid),plength,fk_t5(submitterid)] t9:cds2year2genrevotes[pk(fk(diskid),fk(albumorsamplerid)),year,fk(genreid)),votes] t10:cdtracks[pk(fk(cdid),fk(songid)),offset]