Sales.CustomerAddress Table

Information

Name	CustomerAddress
Schema	Sales
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:54

Extended Properties

Name	Type	Property Name	Value
CustomerAddress	TABLE	MS_Description	Cross-reference table mapping customers to their address(es).

Columns

Name	Data Type	References	Default
CustomerID	int	Sales.Customer.CustomerID
AddressID	int	Person.Address.AddressID
AddressTypeID	int	Person.AddressType.AddressTypeID
rowguid	uniqueidentifier		(newid())
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_CustomerAddress_CustomerID_AddressID	Clustered			CustomerID, AddressID
AK_CustomerAddress_rowguid	NonClustered			rowguid

Foreign Key Constraints

Name	Type	Referenced Table
FK_CustomerAddress_Address_AddressID	Foreign key	Person.Address
FK_CustomerAddress_AddressType_AddressTypeID	Foreign key	Person.AddressType
FK_CustomerAddress_Customer_CustomerID	Foreign key	Sales.Customer

SQL Script

CREATE TABLE [Sales].[CustomerAddress] (
    [CustomerID] int NOT NULL,
    [AddressID] int NOT NULL,
    [AddressTypeID] int NOT NULL,
    [rowguid] uniqueidentifier NOT NULL DEFAULT (newid()),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_CustomerAddress_rowguid] on [Sales].[CustomerAddress]([rowguid]);