Production ProductInventory (table)

wikibot ¶

Table	Production.ProductInventory
Description	Product inventory information.

Columns ¶

Column	Data Type	Nullable	Default	Description
ProductID	int	not null		Product identification number. Foreign key to Product.ProductID.
LocationID	smallint	not null		Inventory location identification number. Foreign key to Location.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.

Primary Key ¶

Primary Key	Columns
PK_ProductInventory_ProductID_LocationID	ProductID, LocationID

Check Constraints ¶

Check Constraint	Expression	Description
CK_ProductInventory_Bin	(Bin>=(0) AND Bin<=(100))	Check constraint Bin BETWEEN (0) AND (100)
CK_ProductInventory_Shelf	(Shelf like 'A-Za-z' OR Shelf='N/A')	Check constraint Shelf like 'A-Za-z' OR Shelf='N/A'

Foreign Keys ¶

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

References ¶

Dependency Type	Object Type	Referenced Object
Schema	Schema	Production

Dependencies ¶

Reference Type	Object Type	Referencing Object
Select	Function	dbo.ufnGetStock