CHECK Table Level|([ProductAssemblyID] IS NULL AND [BOMLevel]=(0) AND [PerAssemblyQty]=(1) OR [ProductAssemblyID] IS NOT NULL AND [BOMLevel]>=(1))
CHECK Table Level|([EndDate]>[StartDate] OR [EndDate] IS NULL)
CHECK Table Level|([ProductAssemblyID]<>[ComponentID])
DEFAULT on column ModifiedDate|(getdate())
DEFAULT on column PerAssemblyQty|((1.0))
DEFAULT on column StartDate|(getdate())
FOREIGN KEY|ComponentID
|REFERENCES AdventureWorks.Production.Product (ProductID)
FOREIGN KEY|ProductAssemblyID
|REFERENCES AdventureWorks.Production.Product (ProductID)
FOREIGN KEY|UnitMeasureCode
|REFERENCES AdventureWorks.Production.UnitMeasure (UnitMeasureCode)
PRIMARY KEY (non-clustered)|BillOfMaterialsID
No foreign keys reference this table, or you do not have permissions on referencing tables.|