.png)
VendorAddress Table (AdventureWorks)
SQL Server 2005
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.
| 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. |
