FeeSet

Metadata

  • Base Table Class: Static
  • Default Size: 100

Fields

NameTypeSize (bytes)Description
IdInteger (signed)8The unique identifier of this FeeSet.
StatusSet of Status4
ShortNameString24The short text identifier of this FeeSet.
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 FeeSet.
OwnerGroupForeign key to Group8The Id of the Group that owns this FeeSet.
OwnerFirmForeign key to Firm8The Id of the Firm that owns this FeeSet.
CreateUserForeign key to User8The Id of the User that created this FeeSet.
CreateTimestampInteger (unsigned)8The time at which this FeeSet was created.
UpdateUserForeign key to User8The Id of the User that last updated this FeeSet.
UpdateTimestampInteger (unsigned)8The time at which this FeeSet was last updated.

Foreign Keys

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

graph LR;
	Enterprise-->|FeeSet|FeeSet
	click Enterprise "/marketgrid/developer/model/tables/Enterprise"
	Firm-->|FeeSet|FeeSet
	click Firm "/marketgrid/developer/model/tables/Firm"
	Account-->|FeeSet|FeeSet
	Account-->|EffectiveFeeSet|FeeSet
	click Account "/marketgrid/developer/model/tables/Account"
	FirmAccountType-->|FeeSet|FeeSet
	click FirmAccountType "/marketgrid/developer/model/tables/FirmAccountType"
	Fee-->|FeeSet|FeeSet
	click Fee "/marketgrid/developer/model/tables/Fee"