update: note that some databases *cough* postgres *cough* support something called table-inheritance, which might be an interesting alternative solution.

I've looked hopefully at this but been put off by the serious "Caveats" section in the docs on table inheritance. It would appear to essentially break primary and foreign keys!