Share via


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.