ExchangeRate
Used to persist the prevailing exchange rate for each currency pair when the system is shut down or shared memory is refreshed. For fast lookup of the exchange rates in the engine, see the CurrentExchangeRate table. For consumption of rates by other processes, see the ExchangeRate_change change table.
- Section: Products
Metadata
- Base Table Class: Entity
- Default Size: 1000
Fields
| Name | Type | Size (bytes) | Description |
|---|---|---|---|
| Id | Integer (signed) | 8 | The unique identifier of this ExchangeRate. |
| Status | Set of Status | 4 | |
| Currency1 | Foreign key to Instrument | 8 | |
| Currency2 | Foreign key to Instrument | 8 | |
| Rate | Integer (signed) | 8 | |
| 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 ExchangeRate. |
| OwnerGroup | Foreign key to Group | 8 | The Id of the Group that owns this ExchangeRate. |
| OwnerFirm | Foreign key to Firm | 8 | The Id of the Firm that owns this ExchangeRate. |
| CreateUser | Foreign key to User | 8 | The Id of the User that created this ExchangeRate. |
| CreateTimestamp | Integer (unsigned) | 8 | The time at which this ExchangeRate was created. |
| UpdateUser | Foreign key to User | 8 | The Id of the User that last updated this ExchangeRate. |
| UpdateTimestamp | Integer (unsigned) | 8 | The time at which this ExchangeRate was last updated. |