Enterprise
An Enterprise is used to provide a grouping mechanism for Firm_ entities in the Trading System.
For example, a large bank that owns several broker firms may be recorded as an Enterprise that owns those brokers that are in turn set up as individual Firm_ instances in the Trading System.
- Section: Actors
Metadata
- Base Table Class: Static
- Default Size: 50
Fields
| Name | Type | Size (bytes) | Description |
|---|---|---|---|
| Id | Integer (signed) | 8 | The unique identifier of this Enterprise. |
| Status | Set of Status | 4 | |
| ShortName | String | 24 | The short text identifier of this Enterprise. |
| ExternalFK | Integer (unsigned) | 8 | FK for this record in the external system that generated it. |
| Name | String | 48 | The long text identifier of this Enterprise. |
| Venue | Foreign key to Venue | 8 | The Venue to which the Enterprise belongs. Each Enterprise is a member of a single Venue and may only see Markets (and InstrumentMarkets) that share the same Venue. |
| EnterpriseType | One of EnterpriseType | 1 | The type of the Enterprise. |
| PermissionGroup | Foreign key to PermissionGroup | 8 | (Optional) permission group that defines a base collection of permissions applied to this enterprise. |
| TemplateEnterprise | Foreign key to Enterprise | 8 | The Id of the template enterprise from which to inherit permissions & status. |
| WorkingStatus | Set of Status | 4 | The currently active value of the Status attribute. The Status of the Enterprise. This is a bit field as defined in the Status_ table. |
| FeeSet | Foreign key to FeeSet | 8 | This 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. |
| Address | String | 500 | The street address of the Enterprise. |
| City | String | 48 | The city name (as text) of the Enterprise. |
| State | String | 48 | The State (as text) of the Enterprise. |
| ZipCode | String | 20 | The zip or post code (as text) of the Enterprise. |
| Country | Foreign key to Country | 8 | This is a reference to the Country table. It is keyed by the Country column in this table to the Id column in the Country table. |
| SettlementCurrency | Foreign key to Instrument | 8 | An Instrument is the entity that represents something to be traded in MarketGrid. In order for an Instrument to trade it must be listed on a Market_ to produce an InstrumentMarket_. Each Instrument may be traded simultaneously on one or more Markets, each such instance being an InstrumentMarket_. |
| MetaData | String | 1024 | MetaData blob for pass-through to external systems. |
| UpdateNumber | Integer (unsigned) | 8 | A 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. |
| OwnerUser | Foreign key to User | 8 | The Id of the User that owns this Enterprise. |
| OwnerGroup | Foreign key to Group | 8 | The Id of the Group that owns this Enterprise. |
| OwnerFirm | Foreign key to Firm | 8 | The Id of the Firm that owns this Enterprise. |
| CreateUser | Foreign key to User | 8 | The Id of the User that created this Enterprise. |
| CreateTimestamp | Integer (unsigned) | 8 | The time at which this Enterprise was created. |
| UpdateUser | Foreign key to User | 8 | The Id of the User that last updated this Enterprise. |
| UpdateTimestamp | Integer (unsigned) | 8 | The time at which this Enterprise was last updated. |
Foreign Keys
The following diagram shows the tables that have a foreign key link to the Enterprise table. All Table nodes can be clicked to take you to that table's definition page.
graph LR; Firm-->|Enterprise|Enterprise click Firm "/marketgrid/developer/model/tables/Firm" Permission-->|Enterprise|Enterprise click Permission "/marketgrid/developer/model/tables/Permission"