AccountLink

Metadata

  • Base Table Class: Static
  • Not in MDB
  • Default Size: Account = 500

Fields

NameTypeSize (bytes)Description
IdInteger (signed)8The unique identifier of this AccountLink.
StatusSet of Status4
AccountForeign key to Account8An Account is the element in the model that links trading activity to the users undertaking that activity. All Accounts are "owned" by a Firm_ and it against one of these Accounts that Holding_ records are managed in the system.
ExternalAccountForeign key to ExternalAccount8This is a reference to the ExternalAccount table. It is keyed by the ExternalAccount column in this table to the Id column in the ExternalAccount table.
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 AccountLink.
OwnerGroupForeign key to Group8The Id of the Group that owns this AccountLink.
OwnerFirmForeign key to Firm8The Id of the Firm that owns this AccountLink.
CreateUserForeign key to User8The Id of the User that created this AccountLink.
CreateTimestampInteger (unsigned)8The time at which this AccountLink was created.
UpdateUserForeign key to User8The Id of the User that last updated this AccountLink.
UpdateTimestampInteger (unsigned)8The time at which this AccountLink was last updated.