Location Linkage explains the relationships among different places or individuals that share a single location.
When multiple places reside at the same location, linkage is modeled in two attributes:
location_parent_id- The primary business at a location with multiple places.
location_parent_relationship- The relationship to the primary business at a location
A Coinstar inside of a Vons supermarket:
A group of professional individuals within a main medical office:
A Pizza Hut inside a Target:
A branded department within a large department store:
A hybrid chain location with two brands:
Multi-tenant linkage models tenants within a larger complex or building:
landmark_address- The name of the complex, building, or mall where the place resides.
building_number- A unique ID assigned to a group of places in the same building.
number_of_tenants- The number of places at a multi-tenant location.
A group of places are inside Huntington Harbour Mall: