Table: 'Production.ScrapReason'

3 fields. 118 bytes.

Manufacturing failure reasons lookup table.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
ScrapReasonIDsmallint identity smallint Not nullPrimary key for ScrapReason records. 
NameName nvarchar(50) Not nullFailure description. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ScrapReason'

Primary Key NameField Name
There are no Foreign Keys for this table.

Indexes for table 'Production.ScrapReason', 2 items

Index NameDescriptionClusteredUniqueFields
PK_ScrapReason_ScrapReasonIDClustered index created by a primary key constraint.YesYesScrapReasonID
AK_ScrapReason_NameUnique nonclustered index.NoYesName

Triggers for table 'Production.ScrapReason', 1 item

uScrapReasonAFTER UPDATE trigger setting the ModifiedDate column in the ScrapReason table to the current date.after Update Yes

Dependencies for table 'Production.ScrapReason', 1 item

Object NameTypeField Name