Disambiguate optional one-to-one relationship
This is a similar problem to https://discord.com/channels/1043890932593987624/1084576896039260202/threads/1254869164607143998 - but instead involves two tables, one of which has a non-nullable foreign key to the other.
https://drizzle.run/my887gq5kvpp1ogl3xpoe0zh
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
https://drizzle.run/my887gq5kvpp1ogl3xpoe0zh
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
fieldsreferencesone()
