Sales.SalesOrderDetail

Columns

• //

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

  ${escapify(column.description)}
  SalesOrderDetailID
  [int] IDENTITY (1,1) NOT NULL
• //

  ${escapify(column.description)}
  CarrierTrackingNumber
  [nvarchar](25) NULL
• //

  ${escapify(column.description)}
  OrderQty
  [smallint] NOT NULL

  //

  CONSTRAINT: Check constraint [OrderQty] > (0)

  ([OrderQty]>(0))
• //

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

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

  ${escapify(column.description)}
  UnitPrice
  [money] NOT NULL

  //

  CONSTRAINT: Check constraint [UnitPrice] >= (0.00)

  ([UnitPrice]>=(0.00))
• //

  ${escapify(column.description)}
  UnitPriceDiscount
  [money] NOT NULL DEFAULT ((0.0))

  //

  CONSTRAINT: Check constraint [UnitPriceDiscount] >= (0.00)

  ([UnitPriceDiscount]>=(0.00))
• //

  ${escapify(column.description)}
  LineTotal
  [numeric](38, 6) NOT NULL
• //

  ${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_SalesOrderDetail_SalesOrderID_SalesOrderDetailID
  UNIQUE CLUSTERED
  SalesOrderID , SalesOrderDetailID
• //

  Unique nonclustered index. Used to support replication samples.
  AK_SalesOrderDetail_rowguid
  UNIQUE NONCLUSTERED
  rowguid
• //

  Nonclustered index.
  IX_SalesOrderDetail_ProductID
  NONCLUSTERED
  ProductID

Foreign Keys

• //

  Foreign key constraint referencing SalesOrderHeader.PurchaseOrderID.
  FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID
  Sales.SalesOrderHeader
  SalesOrderID ⥱ SalesOrderID
• //

  Foreign key constraint referencing SpecialOfferProduct.SpecialOfferIDProductID.
  FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID
  Sales.SpecialOfferProduct
  SpecialOfferID ⥱ SpecialOfferID , ProductID ⥱ ProductID

Sample Data