User:Mortice/Simpsons songs

Experimenting with possible table for recording songs from the Simpsons, eventually to replace the lists on List of songs featured in The Simpsons.

I see this as a number of tables in different groups:


 * 1) Background music
 * 2) Pre-existing songs sung/played by cast
 * 3) Original songs
 * 4) Parody songs

Any other groups or subgroups?

Beyond that, there's a key question of whether the most useful ordering of data is by song name, episode name or artist name. I'd like to have multiple tables (auto-generated!) but that might be a bit extreme.

I'd also like to have a clever 'template' that we could put onto an episode page and it would transmogrify into the subset of the big song table that's in that episode. Probably not possible with wiki :-(

An example table follows (not real data)...

Songs sung by characters
First row in table created with template SimpsonSongTableByCast and second with SimpsonSongTableByLinked which affects the 'performer' column. Third is SimpsonSongTable2ComposersByCast due to having 2 composers.