CustomerAddress Table (AdventureWorks)

Maps customers to their address or addresses. For example, a customer may have separate billing and shipping addresses.

CustomerAddress Table Definition

The CustomerAddress table is contained in the Sales schema.

Column Data type Nullability Description

CustomerID

int

Not null

Primary key. Foreign key to Customer.CustomerID.

AddressID

int

Not null

Primary key. Foreign key to Address.AddressID.

AddressTypeID

int

Not null

Address type. Foreign key to AddressType.AddressTypeID.

rowguid

uniqueidentifier ROWGUIDCOL

Not null

ROWGUIDCOL number that uniquely identifies the record. Used to support a merge replication sample.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

See Also

Reference

Address Table (AdventureWorks)
AddressType Table (AdventureWorks)
Customer Table (AdventureWorks)
Individual Table (AdventureWorks)
SalesOrderHeader Table (AdventureWorks)
SalesPerson Table (AdventureWorks)
SalesTerritory Table (AdventureWorks)
Store Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance