Production ProductInventory (table)

wikibot

TableProduction.ProductInventory
DescriptionProduct inventory information.

Columns

ColumnData TypeNullableDefaultDescription
ProductIDintnot null Product identification number. Foreign key to Product.ProductID.
LocationIDsmallintnot null Inventory location identification number. Foreign key to Location.LocationID.
Shelfnvarchar(10)not null Storage compartment within an inventory location.
Bintinyintnot null Storage container on a shelf in an inventory location.
Quantitysmallintnot null((0))Quantity of products in the inventory location.
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_ProductInventory_ProductID_LocationIDProductID, LocationID

Check Constraints

Check ConstraintExpressionDescription
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

RelationColumnReferenced Column
Production.LocationLocationIDLocationID
Production.ProductProductIDProductID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction

Dependencies

Reference TypeObject TypeReferencing Object
SelectFunctiondbo.ufnGetStock