Production.ProductInventory
Documentation | AdventureWorks |
Schema | Production |
Name | ProductInventory |
Module | Inventory |
Product inventory information.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | ProductID | int | Production.Product | Product identification number. Foreign key to Product.ProductID. | ||||
Product identification number. Foreign key to Product.ProductID. References: Production.Product |
||||||||
2 | LocationID | smallint | Production.Location | Inventory location identification number. Foreign key to Location.LocationID. | ||||
Inventory location identification number. Foreign key to Location.LocationID. References: Production.Location |
||||||||
3 | Shelf | nvarchar(10) | Storage compartment within an inventory location. | |||||
Storage compartment within an inventory location. |
||||||||
4 | Bin | tinyint | Storage container on a shelf in an inventory location. | |||||
Storage container on a shelf in an inventory location. |
||||||||
5 | Quantity | smallint | Default: 0 | Quantity of products in the inventory location. | ||||
Quantity of products in the inventory location. Default: 0 |
||||||||
6 | rowguid | uniqueidentifier | Default: newid() | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. | ||||
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. Default: newid() |
||||||||
7 | ModifiedDate | datetime | Default: getdate() | Date and time the record was last updated. | ||||
Date and time the record was last updated. Default: getdate() |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
Production.ProductInventory | Production.Location | Production.ProductInventory.LocationID = Production.Location.LocationID | FK_ProductInventory_Location_LocationID Foreign key constraint referencing Location.LocationID. |
|
Production.ProductInventory.LocationID = Production.Location.LocationID Name: FK_ProductInventory_Location_LocationIDForeign key constraint referencing Location.LocationID. |
||||
Production.ProductInventory | Production.Product | Production.ProductInventory.ProductID = Production.Product.ProductID | FK_ProductInventory_Product_ProductID Foreign key constraint referencing Product.ProductID. |
|
Production.ProductInventory.ProductID = Production.Product.ProductID Name: FK_ProductInventory_Product_ProductIDForeign key constraint referencing Product.ProductID. |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_ProductInventory_ProductID_LocationID | ProductID, LocationID | Primary key (clustered) constraint | |
Primary key (clustered) constraint |
Uses
Name |
---|
Production.ProductInventory
|
Used by
Name |
---|
Production.ProductInventory
|
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56