Sales.CustomerAddress (table)

wikibot

Table

Sales.CustomerAddress

Column	Data Type	Nullable	Default	PK	Index
CustomerID	int	not null		PK_CustomerAddress_CustomerID_AddressID
AddressID	int	not null		PK_CustomerAddress_CustomerID_AddressID
AddressTypeID	int	not null
rowguid	uniqueidentifier	not null	(newid())		AK_CustomerAddress_rowguid
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Person.Address	AddressID	AddressID
Person.AddressType	AddressTypeID	AddressTypeID
Sales.Customer	CustomerID	CustomerID

automatically generated

Table	Sales.CustomerAddress
Description	Cross-reference table mapping customers to their address(es).

Column	Data Type	Nullable	Default	Description	PK / Index
CustomerID	int	not null		Primary key. Foreign key to Customer.CustomerID.	PK_CustomerAddress_CustomerID_AddressID
AddressID	int	not null		Primary key. Foreign key to Address.AddressID.	PK_CustomerAddress_CustomerID_AddressID
AddressTypeID	int	not null		Address type. Foreign key to AddressType.AddressTypeID.
rowguid	uniqueidentifier	not null	(NEWID())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.	AK_CustomerAddress_rowguid
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Relation	Column	Referenced Column
Person.Address	AddressID	AddressID
Person.AddressType	AddressTypeID	AddressTypeID
Sales.Customer	CustomerID	CustomerID