FirmAccountType

Mapping which AccountTypes may be used for particular Firms. It also determines which FeeSet if any should be applied for this kind of Account.

Metadata

  • Base Table Class: Static
  • Default Size: Firm * AccountType = 50000

Fields

NameTypeSize (bytes)Description
IdInteger (signed)8The unique identifier of this FirmAccountType.
StatusSet of Status4
FirmForeign key to Firm8A Firm is the organisational unit into which users of the Trading System are grouped. Every Firm belongs to one Enterprise.
AccountTypeForeign key to AccountType8This is a reference to the AccountType table. It is keyed by the AccountType column in this table to the Id column in the AccountType table.
FeeSetForeign key to FeeSet8This is a reference to the FeeSet table. It is keyed by the FeeSet column in this table to the Id column in the FeeSet table.
MpIdString20
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 FirmAccountType.
OwnerGroupForeign key to Group8The Id of the Group that owns this FirmAccountType.
OwnerFirmForeign key to Firm8The Id of the Firm that owns this FirmAccountType.
CreateUserForeign key to User8The Id of the User that created this FirmAccountType.
CreateTimestampInteger (unsigned)8The time at which this FirmAccountType was created.
UpdateUserForeign key to User8The Id of the User that last updated this FirmAccountType.
UpdateTimestampInteger (unsigned)8The time at which this FirmAccountType was last updated.

Foreign Keys

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

graph LR;
	Account-->|FirmAccountType|FirmAccountType
	click Account "/marketgrid/developer/model/tables/Account"
← Firm
FirmName →