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