Option 2 is ruled out because you don't need a join table for 1:M reletionships.
The relationship between
APPLICATION_STUDY
andCONSULTATION
is 0:M, not 1:M.Option 1 is the correct one, that's the usual way of modeling 0:M relationships, a nullable FK on the MANY side.
Tulains Córdova
- 39.5k
- 13
- 99
- 155