VendorAddress Table (AdventureWorks)
Is a cross-reference table that maps vendors and their addresses. Vendors may have more than one address; for example, a vendor may have separate billing and shipping addresses.
The VendorAddress table is contained in the Purchasing schema.
Primary key. Foreign key to Vendor.VendorID.
Primary key. Foreign key to Address.AddressID.
Address type. Foreign key to AddressType.AddressTypeID.
Date and time the row was last updated.