CustomerAddress Table (AdventureWorks)
Maps customers to their address or addresses. For example, a customer may have separate billing and shipping addresses.
The CustomerAddress table is contained in the Sales schema.
Primary key. Foreign key to Customer.CustomerID.
Primary key. Foreign key to Address.AddressID.
Address type. Foreign key to AddressType.AddressTypeID.
ROWGUIDCOL number that uniquely identifies the record. Used to support a merge replication sample.
Date and time the row was last updated.