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.
VendorAddress Table Definition
The VendorAddress table is contained in the Purchasing schema.
Column |
Data type |
Nullability |
Description |
|---|---|---|---|
VendorID |
int |
Not null |
Primary key. Foreign key to Vendor.VendorID. |
AddressID |
int |
Not null |
Primary key. Foreign key to Address.AddressID. |
AddressTypeID |
int |
Not null |
Address type. Foreign key to AddressType.AddressTypeID. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |