ScrapReason Table (AdventureWorks)

In a lookup table that contains the reasons for manufacturing failures.

ScrapReason Table Definition

The ScrapReason table is contained in the Production schema.

Column	Data type	Nullability	Description
ScrapReasonID	smallint	Not null	Primary key.
Name	Name (user-defined type) nvarchar(50)	Not null	Failure description.
ModifiedDate	datetime	Not null	Date and time the row was last updated.

ScrapReasonID

smallint

Not null

Primary key.

Name

Name (user-defined type)

nvarchar(50)

Not null

Failure description.

ModifiedDate

datetime

Not null

Date and time the row was last updated.