Production.ScrapReason - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Production
Name	ScrapReason
Module	Manufacturing

Manufacturing failure reasons lookup table.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		ScrapReasonID	smallint		Identity		Primary key for ScrapReason records.
Primary key for ScrapReason records. Identity
	2		Name	nvarchar(50)				Failure description.
Failure description.
	3		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
Production.WorkOrder		Production.ScrapReason	Production.WorkOrder.ScrapReasonID = Production.ScrapReason.ScrapReasonID	FK_WorkOrder_ScrapReason_ScrapReasonID Foreign key constraint referencing ScrapReason.ScrapReasonID.
Production.WorkOrder.ScrapReasonID = Production.ScrapReason.ScrapReasonID Name: FK_WorkOrder_ScrapReason_ScrapReasonID Foreign key constraint referencing ScrapReason.ScrapReasonID.

Unique keys

	Key name	Columns	Description
	PK_ScrapReason_ScrapReasonID	ScrapReasonID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_ScrapReason_Name	Name	Unique nonclustered index.
Unique nonclustered index.

Used by

Name
Production.ScrapReason
Production.WorkOrder

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