Sales.SalesReason - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Sales
Name	SalesReason
Module	Sales

Lookup table of customer purchase reasons.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		SalesReasonID	int		Identity		Primary key for SalesReason records.
Primary key for SalesReason records. Identity
	2		Name	nvarchar(50)				Sales reason description.
Sales reason description.
	3		ReasonType	nvarchar(50)				Category the sales reason belongs to.
Category the sales reason belongs to.
	4		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Sales.SalesOrderHeaderSalesReason		Sales.SalesReason	Sales.SalesOrderHeaderSalesReason.SalesReasonID = Sales.SalesReason.SalesReasonID	FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID Foreign key constraint referencing SalesReason.SalesReasonID.
Sales.SalesOrderHeaderSalesReason.SalesReasonID = Sales.SalesReason.SalesReasonID Name: FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID Foreign key constraint referencing SalesReason.SalesReasonID.

Unique keys

	Key name	Columns	Description
	PK_SalesReason_SalesReasonID	SalesReasonID	Primary key (clustered) constraint
Primary key (clustered) constraint

Used by

Name
Sales.SalesReason
Sales.SalesOrderHeaderSalesReason

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56