Production.WorkOrder

Columns

• //

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

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

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

  //

  CONSTRAINT: Check constraint [OrderQty] > (0)

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

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

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

  //

  CONSTRAINT: Check constraint [ScrappedQty] >= (0)

  ([ScrappedQty]>=(0))
• //

  ${escapify(column.description)}
  StartDate
  [datetime] NOT NULL
• //

  ${escapify(column.description)}
  EndDate
  [datetime] NULL
• //

  ${escapify(column.description)}
  DueDate
  [datetime] NOT NULL
• //

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

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

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_WorkOrder_WorkOrderID
  UNIQUE CLUSTERED
  WorkOrderID
• //

  Nonclustered index.
  IX_WorkOrder_ScrapReasonID
  NONCLUSTERED
  ScrapReasonID
• //

  Nonclustered index.
  IX_WorkOrder_ProductID
  NONCLUSTERED
  ProductID

Foreign Keys

• //

  Foreign key constraint referencing Product.ProductID.
  FK_WorkOrder_Product_ProductID
  Production.Product
  ProductID ⥱ ProductID
• //

  Foreign key constraint referencing ScrapReason.ScrapReasonID.
  FK_WorkOrder_ScrapReason_ScrapReasonID
  Production.ScrapReason
  ScrapReasonID ⥱ ScrapReasonID

Check Constraints

• //

  Check constraint [EndDate] >= [StartDate] OR [EndDate] IS NULL
  CK_WorkOrder_EndDate
  ([EndDate]>=[StartDate] OR [EndDate] IS NULL)

Sample Data