Sales.Orders

Columns

• //

  ${escapify(column.description)}
  OrderID
  [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[OrderID])
• //

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

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

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

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

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

  ${escapify(column.description)}
  OrderDate
  [date] NOT NULL
• //

  ${escapify(column.description)}
  ExpectedDeliveryDate
  [date] NOT NULL
• //

  ${escapify(column.description)}
  CustomerPurchaseOrderNumber
  [nvarchar](20) NULL
• //

  ${escapify(column.description)}
  IsUndersupplyBackordered
  [bit] NOT NULL
• //

  ${escapify(column.description)}
  Comments
  [nvarchar](MAX) NULL
• //

  ${escapify(column.description)}
  DeliveryInstructions
  [nvarchar](MAX) NULL
• //

  ${escapify(column.description)}
  InternalComments
  [nvarchar](MAX) NULL
• //

  ${escapify(column.description)}
  PickingCompletedWhen
  [datetime2](8) NULL
• LastEditedBy
  [int] NOT NULL
• LastEditedWhen
  [datetime2](8) NOT NULL DEFAULT (sysdatetime())

Indexes

• PK_Sales_Orders
  UNIQUE CLUSTERED
  OrderID
• //

  Auto-created to support a foreign key
  FK_Sales_Orders_CustomerID
  NONCLUSTERED
  CustomerID
• //

  Auto-created to support a foreign key
  FK_Sales_Orders_SalespersonPersonID
  NONCLUSTERED
  SalespersonPersonID
• //

  Auto-created to support a foreign key
  FK_Sales_Orders_PickedByPersonID
  NONCLUSTERED
  PickedByPersonID
• //

  Auto-created to support a foreign key
  FK_Sales_Orders_ContactPersonID
  NONCLUSTERED
  ContactPersonID

Foreign Keys

• FK_Sales_Orders_Application_People
  Application.People
  LastEditedBy ⥱ PersonID
• FK_Sales_Orders_BackorderOrderID_Sales_Orders
  Sales.Orders
  BackorderOrderID ⥱ OrderID
• FK_Sales_Orders_ContactPersonID_Application_People
  Application.People
  ContactPersonID ⥱ PersonID
• FK_Sales_Orders_CustomerID_Sales_Customers
  Sales.Customers
  CustomerID ⥱ CustomerID
• FK_Sales_Orders_PickedByPersonID_Application_People
  Application.People
  PickedByPersonID ⥱ PersonID
• FK_Sales_Orders_SalespersonPersonID_Application_People
  Application.People
  SalespersonPersonID ⥱ PersonID

Sample Data