Production.TransactionHistory

Columns

• //

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

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

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

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

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

  ${escapify(column.description)}
  TransactionType
  [nchar](1) NOT NULL

  //

  CONSTRAINT: Check constraint [TransactionType]='p' OR [TransactionType]='s' OR [TransactionType]='w' OR [TransactionType]='P' OR [TransactionType]='S' OR [TransactionType]='W')

  (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W')
• //

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

  ${escapify(column.description)}
  ActualCost
  [money] NOT NULL
• //

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

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_TransactionHistory_TransactionID
  UNIQUE CLUSTERED
  TransactionID
• //

  Nonclustered index.
  IX_TransactionHistory_ProductID
  NONCLUSTERED
  ProductID
• //

  Nonclustered index.
  IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID
  NONCLUSTERED
  ReferenceOrderID , ReferenceOrderLineID

Foreign Keys

• //

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

Sample Data