Object type: Table

Cross-reference table mapping sales orders to sales reason codes.

Columns 

Name	Data type	Nullable	Description
SalesOrderID	int	No	Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
SalesReasonID	int	No	Primary key. Foreign key to SalesReason.SalesReasonID.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_SalesOrderHeaderSalesReason_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID	PRIMARY KEY	SalesOrderID SalesReasonID	Clustered index created by a primary key constraint.
FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID	FOREIGN KEY	SalesReasonID	Reference table: Sales.SalesReason Foreign key constraint referencing SalesReason.SalesReasonID.
FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID	FOREIGN KEY	SalesOrderID	Reference table: Sales.SalesOrderHeader Foreign key constraint referencing SalesOrderHeader.SalesOrderID.

Triggers 

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

Modified by 

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

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation