Offices ---------- GUID (uniqueidentifier, PK) [other fields] Users --------- GUID (uniqueidentifier, PK) [other fields] Clients --------- GUID (uniqueidentifier, PK) [other fields] Vendors --------- GUID (uniqueidentifier, PK) [other fields] [more tables]
and I want these tables to be able to have multiple addresses (home, work, billing, shipping, physical, PO box, etc.), so I have the following Addresses table:
Addresses --------- GUID (uniqueidentifier, PK) ParentGUID (uniqueidentifier, FK) Street City State Zip [etc]
How do I make the ParentGUID of the Addresses table a FK that relates to all of the other tables? Or is there a better approach?