AdventureWorks

Basic Index   Expanded Index

Table Name:Production.ScrapReason
Description:Manufacturing failure reasons lookup table.
Primary Keys:ScrapReasonID
FieldTypeDefaultsNulls?Comments
ScrapReasonIDsmallint - IdentityNoneNoPrimary key for ScrapReason records.
Namenvarchar (50)NoneNoFailure description.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_ScrapReason_ScrapReasonIDYesYesScrapReasonID
AK_ScrapReason_NameNoYesName

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_WorkOrder_ScrapReason_ScrapReasonIDProduction.WorkOrderScrapReasonID

No triggers