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