Microsoft Message Queuing – Log Trade Information using Microsoft SQL Server

use [Harlinn.Messaging.Data]
go

CREATE TABLE Bid
(
  Id uniqueidentifier not null primary key,
  TimeStamp datetime not null,
  BidderId uniqueidentifier not null,
  InstrumentId uniqueidentifier not null,
  BidConditionsId uniqueidentifier not null,
  Value float not null,
  Volume float not null 
)
go

CREATE TABLE Offer
(
  Id uniqueidentifier not null primary key,
  TimeStamp datetime not null,
  SellerId uniqueidentifier not null,
  SaleConditionsId uniqueidentifier not null,
  InstrumentId uniqueidentifier not null,
  Value float not null,
  Volume float not null 
)
go

CREATE TABLE Trade
(
  Id uniqueidentifier not null primary key,
  TimeStamp datetime not null,
  SellerId uniqueidentifier not null,
  BuyerId uniqueidentifier not null,
  TradeAgreementId uniqueidentifier not null,
  InstrumentId uniqueidentifier not null,
  Value float not null,
  Volume float not null 
)
go