Blotter

Metadata

  • Base Table Class: Static
  • Default Size: User * Constants::MaxBlottersPerUser = 100

Fields

NameTypeSize (bytes)Description
IdInteger (signed)8The unique identifier of this Blotter.
StatusSet of Status4
NameString48The long text identifier for this record in the Blotter table
UserForeign key to User8The User Table contains a list of the UserIds that are used by individuals to log into the Trading System.
BlotterStatusOne of BlotterStatus1
TypeOne of BlotterType1
SideOne of OrderSide1Whether this is a Buy (0) or a Sell (1).
CountInteger (unsigned)4
IsNewInteger (unsigned)1
LimitValueInteger (signed)8
CurrentValueInteger (signed)8
UpdateNumberInteger (unsigned)8A number that records every change that happens to a record. It is primarily used to avoid write after read problems when an intermediate write has changed the originally read record.
OwnerUserForeign key to User8The Id of the User that owns this Blotter.
OwnerGroupForeign key to Group8The Id of the Group that owns this Blotter.
OwnerFirmForeign key to Firm8The Id of the Firm that owns this Blotter.
CreateUserForeign key to User8The Id of the User that created this Blotter.
CreateTimestampInteger (unsigned)8The time at which this Blotter was created.
UpdateUserForeign key to User8The Id of the User that last updated this Blotter.
UpdateTimestampInteger (unsigned)8The time at which this Blotter was last updated.

Foreign Keys

The following diagram shows the tables that have a foreign key link to the Blotter table. All Table nodes can be clicked to take you to that table's definition page.

graph LR;
	Order-->|Blotter|Blotter
	click Order "/marketgrid/developer/model/tables/Order"