AdventureWorks - Production.ProductInventory

AdventureWorks

Basic Index Expanded Index

Table Name:	Production.ProductInventory
Description:	Product inventory information.
Primary Keys:	ProductID LocationID

Field	Type	Defaults	Nulls?	Comments
ProductID	int	None	No	Product identification number. Foreign key to Product.ProductID.
LocationID	smallint	None	No	Inventory location identification number. Foreign key to Location.LocationID.
Shelf	nvarchar (10)	None	No	Storage compartment within an inventory location.
Bin	tinyint	None	No	Storage container on a shelf in an inventory location.
Quantity	smallint	((0))	No	Quantity of products in the inventory location.
rowguid	uniqueidentifier	(newid())	No	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	(getdate())	No	Date and time the record was last updated.

Index	Clustered?	Unique?	Fields
PK_ProductInventory_ProductID_LocationID	Yes	Yes	ProductID LocationID

Check Constraint	Text
CK_ProductInventory_Shelf	([Shelf] like '[A-Za-z]' OR [Shelf]='N/A')
CK_ProductInventory_Bin	([Bin]>=(0) AND [Bin]<=(100))

Internal Foreign Key Constraint	Affected Field	Source Table
FK_ProductInventory_Location_LocationID	LocationID	Production.Location
FK_ProductInventory_Product_ProductID	ProductID	Production.Product

No primary keys as foreign key constraints
No triggers