Production.ProductInventory (table)

wikibot

Table

Production.ProductInventory

Column	Data Type	Nullable	Default	PK	Index
ProductID	int	not null		PK_ProductInventory_ProductID_LocationID
LocationID	smallint	not null		PK_ProductInventory_ProductID_LocationID
Shelf	nvarchar(10)	not null
Bin	tinyint	not null
Quantity	smallint	not null	((0))
rowguid	uniqueidentifier	not null	(newid())
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Production.Location	LocationID	LocationID
Production.Product	ProductID	ProductID

automatically generated

Table	Production.ProductInventory
Description	Product inventory information.

Column	Data Type	Nullable	Default	Description / PK / Index
ProductID	int	not null		Product identification number. Foreign key to Product.ProductID. PK_ProductInventory_ProductID_LocationID
LocationID	smallint	not null		Inventory location identification number. Foreign key to Location.LocationID. PK_ProductInventory_ProductID_LocationID
Shelf	nvarchar(10)	not null		Storage compartment within an inventory location.
Bin	tinyint	not null		Storage container on a shelf in an inventory location.
Quantity	smallint	not null	(0)	Quantity of products in the inventory location.
rowguid	uniqueidentifier	not null	(NEWID())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Relation	Column	Referenced Column
Production.Location	LocationID	LocationID
Production.Product	ProductID	ProductID

Referencing Object	Object Type	Reference Type
dbo.ufnGetStock	Function	Select