Object type: Table

Manufacturing failure reasons lookup table.

Columns 

Name	Data type	Nullable	Description
ScrapReasonID	smallint	No	Column has identity seed value of 1 with a step value of 1. Primary key for ScrapReason records.
Name	Name	No	Failure description.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_ScrapReason_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_ScrapReason_ScrapReasonID	PRIMARY KEY	ScrapReasonID	Clustered index created by a primary key constraint.

Indices 

Name	Description
AK_ScrapReason_Name	Unique nonclustered index.

Triggers 

Name	Description
Production.uScrapReason	AFTER UPDATE trigger setting the ModifiedDate column in the ScrapReason table to the current date.

Linked tables 

Name	Description
Production.WorkOrder	Manufacturing work orders.

Modified by 

Name	Description
Production.uScrapReason	AFTER UPDATE trigger setting the ModifiedDate column in the ScrapReason 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