Production.ProductInventory

Columns

• //

  ${escapify(column.description)}
  ProductID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  LocationID
  [smallint] NOT NULL
• //

  ${escapify(column.description)}
  Shelf
  [nvarchar](10) NOT NULL

  //

  CONSTRAINT: Check constraint [Shelf] like '[A-Za-z]' OR [Shelf]='N/A'

  ([Shelf] like '[A-Za-z]' OR [Shelf]='N/A')
• //

  ${escapify(column.description)}
  Bin
  [tinyint] NOT NULL

  //

  CONSTRAINT: Check constraint [Bin] BETWEEN (0) AND (100)

  ([Bin]>=(0) AND [Bin]<=(100))
• //

  ${escapify(column.description)}
  Quantity
  [smallint] NOT NULL DEFAULT ((0))
• //

  ${escapify(column.description)}
  rowguid
  [uniqueidentifier] NOT NULL DEFAULT (newid())
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_ProductInventory_ProductID_LocationID
  UNIQUE CLUSTERED
  ProductID , LocationID

Foreign Keys

• //

  Foreign key constraint referencing Location.LocationID.
  FK_ProductInventory_Location_LocationID
  Production.Location
  LocationID ⥱ LocationID
• //

  Foreign key constraint referencing Product.ProductID.
  FK_ProductInventory_Product_ProductID
  Production.Product
  ProductID ⥱ ProductID

Sample Data