Disambiguate optional one-to-one relationship
This is a similar problem to https://discord.com/channels/1043890932593987624/1084576896039260202/threads/1254869164607143998
I have table A that has an id column, and table B that has a nullable reference to table A on a unique column. This is an optional one-to-one relationship, however, there is another column on table B that is not unique and should have a many-to-one relationship to table A.
It's possible to disambiguate many-to-one relationships, but I'm not sure how to disambiguate a one-to-one without including
- but instead involves two tables, one of which has a non-nullable foreign key to the other.
I have table A that has an id column, and table B that has a nullable reference to table A on a unique column. This is an optional one-to-one relationship, however, there is another column on table B that is not unique and should have a many-to-one relationship to table A.
It's possible to disambiguate many-to-one relationships, but I'm not sure how to disambiguate a one-to-one without including
fields and references on the ambiguous one() on table A which makes the one-to-one relationship incorrectly non-nullable.
