Create one-to-one relation without adding reference in one of the tables
I have 2 tables: Company(Id uniqueidentifier, …), Address(Id int,…) and representative entities: Company and Address. They should have relation one-to-one. As I don’t want to have any reference to Company in Address entity I thought of creating join-table CompanyAddress(CompanyId, AddressId).