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.