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. |
See Also
Reference
Address Table (AdventureWorks)
AddressType Table (AdventureWorks)
Vendor Table (AdventureWorks)
VendorContact Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary