Production.ProductInventory Table

Information

Name	ProductInventory
Schema	Production
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:54

Extended Properties

Name	Type	Property Name	Value
ProductInventory	TABLE	MS_Description	Product inventory information.

Columns

Name	Data Type	Collation	References	Default
ProductID	int		Production.Product.ProductID
LocationID	smallint		Production.Location.LocationID
Shelf	nvarchar(10)	SQL_Latin1_General_CP1_CI_AS
Bin	tinyint
Quantity	smallint			((0))
rowguid	uniqueidentifier			(newid())
ModifiedDate	datetime			(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_ProductInventory_ProductID_LocationID	Clustered			ProductID, LocationID

Check Constraints

Name	Column	Enabled	Trusted	Expression
CK_ProductInventory_Shelf	Shelf			([Shelf] like '[A-Za-z]' OR [Shelf]='N/A')
CK_ProductInventory_Bin	Bin			([Bin]>=(0) AND [Bin]<=(100))

Foreign Key Constraints

Name	Type	Referenced Table
FK_ProductInventory_Location_LocationID	Foreign key	Production.Location
FK_ProductInventory_Product_ProductID	Foreign key	Production.Product

SQL Script

CREATE TABLE [Production].[ProductInventory] (
    [ProductID] int NOT NULL,
    [LocationID] smallint NOT NULL,
    [Shelf] nvarchar(10) NOT NULL,
    [Bin] tinyint NOT NULL,
    [Quantity] smallint NOT NULL DEFAULT ((0)),
    [rowguid] uniqueidentifier NOT NULL DEFAULT (newid()),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);