I'm not sure how to explain this. I have a parent-child relation, but there can be different types of children. I'm wondering if I should make a different child table for each type of child, or or try to homogonize them into one child with a field telling what type they are.

Having different tables would be good because I need to store different data about different children. The problem is that if I need a new child type, I need a new table.

Does this make any sense?

Thanks,

Michelle