Sales.CustomerAddress

Object type: Table

Cross-reference table mapping customers to their address(es).

Columns

Name Data type Nullable Description

CustomerID int No Primary key. Foreign key to Customer.CustomerID.

AddressID int No Primary key. Foreign key to Address.AddressID.

AddressTypeID int No Address type. Foreign key to AddressType.AddressTypeID.

rowguid uniqueidentifier No Default value: NEWID()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.

ModifiedDate datetime No Default value: GETDATE()
Date and time the record was last updated.

Constraints

Name Type Columns Description

DF_CustomerAddress_rowguid DEFAULT rowguid Value: NEWID()
Default constraint value of NEWID()

DF_CustomerAddress_ModifiedDate DEFAULT ModifiedDate Value: GETDATE()
Default constraint value of GETDATE()

PK_CustomerAddress_CustomerID_AddressID PRIMARY KEY CustomerID
AddressID Clustered index created by a primary key constraint.

FK_CustomerAddress_Address_AddressID FOREIGN KEY AddressID Reference table: Person.Address
Foreign key constraint referencing Address.AddressID.

FK_CustomerAddress_AddressType_AddressTypeID FOREIGN KEY AddressTypeID Reference table: Person.AddressType
Foreign key constraint referencing AddressType.AddressTypeID.

FK_CustomerAddress_Customer_CustomerID FOREIGN KEY CustomerID Reference table: Sales.Customer
Foreign key constraint referencing Customer.CustomerID.

Indices

Name Description

AK_CustomerAddress_rowguid Unique nonclustered index. Used to support replication samples.

Triggers

Name Description

Sales.uCustomerAddress AFTER UPDATE trigger setting the ModifiedDate column in the CustomerAddress table to the current date.

Accessed by

Name Description

Sales.vIndividual Individual customers (names and addresses) that purchase Adventure Works Cycles products online.

Sales.vStoreWithDemographics Stores (names and addresses) that sell Adventure Works Cycles products to consumers.

Modified by

Name Description

Sales.uCustomerAddress AFTER UPDATE trigger setting the ModifiedDate column in the CustomerAddress table to the current date.

Applies to

Tables | User

Name	Data type	Nullable	Description
CustomerID	int	No	Primary key. Foreign key to Customer.CustomerID.
AddressID	int	No	Primary key. Foreign key to Address.AddressID.
AddressTypeID	int	No	Address type. Foreign key to AddressType.AddressTypeID.
rowguid	uniqueidentifier	No	Default value: NEWID() ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Name	Type	Columns	Description
DF_CustomerAddress_rowguid	DEFAULT	rowguid	Value: NEWID() Default constraint value of NEWID()
DF_CustomerAddress_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_CustomerAddress_CustomerID_AddressID	PRIMARY KEY	CustomerID AddressID	Clustered index created by a primary key constraint.
FK_CustomerAddress_Address_AddressID	FOREIGN KEY	AddressID	Reference table: Person.Address Foreign key constraint referencing Address.AddressID.
FK_CustomerAddress_AddressType_AddressTypeID	FOREIGN KEY	AddressTypeID	Reference table: Person.AddressType Foreign key constraint referencing AddressType.AddressTypeID.
FK_CustomerAddress_Customer_CustomerID	FOREIGN KEY	CustomerID	Reference table: Sales.Customer Foreign key constraint referencing Customer.CustomerID.

Name	Description
AK_CustomerAddress_rowguid	Unique nonclustered index. Used to support replication samples.

Name	Description
Sales.uCustomerAddress	AFTER UPDATE trigger setting the ModifiedDate column in the CustomerAddress table to the current date.

Name	Description
Sales.vIndividual	Individual customers (names and addresses) that purchase Adventure Works Cycles products online.
Sales.vStoreWithDemographics	Stores (names and addresses) that sell Adventure Works Cycles products to consumers.