CHECK Table Level|([EndDate]>=[StartDate] OR [EndDate] IS NULL)
DEFAULT on column ModifiedDate|(getdate())
FOREIGN KEY|ProductID
|REFERENCES AdventureWorks.Production.Product (ProductID)
FOREIGN KEY|ScrapReasonID
|REFERENCES AdventureWorks.Production.ScrapReason (ScrapReasonID)
PRIMARY KEY (clustered)|WorkOrderID