Generated using SQL Data Dictionary demo version.


Table Production.ProductInventory (1,069 rows)


Product inventory information.


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

Indexes:


References:


Used by: