Sales.SalesOrderHeaderSalesReason Table

Information

Name	SalesOrderHeaderSalesReason
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:55

Extended Properties

Name	Type	Property Name	Value
SalesOrderHeaderSalesReason	TABLE	MS_Description	Cross-reference table mapping sales orders to sales reason codes.

Columns

Name	Data Type	References	Default
SalesOrderID	int	Sales.SalesOrderHeader.SalesOrderID
SalesReasonID	int	Sales.SalesReason.SalesReasonID
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID	Clustered			SalesOrderID, SalesReasonID

Foreign Key Constraints

Name	Type	Referenced Table
FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID	Foreign key	Sales.SalesOrderHeader
FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID	Foreign key	Sales.SalesReason

SQL Script

CREATE TABLE [Sales].[SalesOrderHeaderSalesReason] (
    [SalesOrderID] int NOT NULL,
    [SalesReasonID] int NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);