Assuming we have the following table: Item, Parent, Child and Parent is the parent of child.
The item can either belong to a parent or child and not both.
I have other tables that are similar to Item and they too can belong to either a Parent or Child.
Should I simply just add 2 nullable FK to them?
Can I enforce that either a Parent or Child must exists using the db?