Hi,

I've got a hierarchy like this:

Animal

Bear extends Animal
BrownBear extends Bear
PolarBear extends Bear

Dog extends Animal
Dachshund extends Dog
Dalmatian extends Dog

Now I would like three tables: one for Animal, one for Bear (with discriminator) and one or Dog (with discriminator).

The animal table is purely because all animals are unique - but I don't mind a composite key.

What's the closest way this could be achieved? I tried Animal with Bear and Dog joined subclasses - but I can't shoehorn in their children.

Any help would be greatly appreciated!

John