ExchangeRate_change
Records changes to exchange rates.
- Section: Change Tables
Metadata
- Base Table Class: Change
- Default Size: ExchangeRate * 20 = 20000
Fields
| Name | Type | Size (bytes) | Description |
|---|---|---|---|
| Id | Integer (signed) | 8 | The unique identifier of this ExchangeRate. |
| Status | Set of Status | 4 | |
| Timestamp | Integer (unsigned) | 8 | The time at which this change record was generated. This is not the same as the business-level timestamp of this ExchangeRate_change. |
| 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. |
| BCSequence | Integer (unsigned) | 8 | The sequence number of this ExchangeRate_change message in the overall broadcast sequence. |
| Reloaded | Integer (unsigned) | 1 | Set to true for change records that are generated during a normal startup from engine cache files. |
| InstanceId | Integer (unsigned) | 4 | |
| RunId | Integer (unsigned) | 4 | |
| ChangedField | One of KVPKey | 4 | |
| 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. |