User blog:JoshuaJSlone/Database work in progress

So it's a month ago today I decided to make a music database. And while it's coming along nicely, I'm not quite to the point where I want to put it live on the web yet. But I figured sharing a few images of what I've got going couldn't hurt. I'm sure the page layouts will evolve quite a bit--right now it's still more at the point of making sure stuff is displaying, rather than trying to make it display in the best way.

First, the simple list of albums (including singles). It shows the database's album ID, title, artist(s) it's from, release date, and the type: s for single and so on. In this image they're displaying by date, but as I've currently got only the main releases from S/mileage, Minimoni, Coconuts Musume, Juice=Juice, and some early Morning Musume in there, there's a pretty big time gap noticeable. 

Click on an album and you'll get the album page, showing relevant information about it. My favorite part is the track list, showing which songs show up in which editions. 

Click on one of the covers or the edition abbreviations in the tracklist, and you get the more specific edition page. There's a lot of overlap with the main album page. 

Click on a specific song and it gives information about where it's showed up, credits for the song, and if there are other versions of it. 

Click on a person and we see information about what groups they're in and what they're credited for. 

As far as the system is concerned groups are just a type of person, but instead of listing what groups they're in, it lists who's in the group. 

As with albums it's possile to get a pretty simple list of people/groups, too. 

This Roles page gives a different way of browsing credits. Check out all the people credited for Arrangement, Lyrics, Guitar, whatever is in there. 

Finally there is the song list page. Right now it's pretty simple, but I think this is where the really cool stuff will happen once I put in the option to narrow things down based on various specifications. Right now it's just "All songs", but in the future you should be able to do things like "All songs by Berryz Koubou not counting remixes or instrumentals", "All songs with Tsuji Nozomi on vocals but not Kago Ai on vocals", or "All single A-sides with lyrics not written by Tsunku".