Sales.SalesOrderHeaderSalesReason

Columns

• //

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

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

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

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID
  UNIQUE CLUSTERED
  SalesOrderID , SalesReasonID

Foreign Keys

• //

  Foreign key constraint referencing SalesOrderHeader.SalesOrderID.
  FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID
  Sales.SalesOrderHeader
  SalesOrderID ⥱ SalesOrderID
• //

  Foreign key constraint referencing SalesReason.SalesReasonID.
  FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID
  Sales.SalesReason
  SalesReasonID ⥱ SalesReasonID

Sample Data