Level1_change
This table represents a piece of Level One data.
- Section: Change Tables
Metadata
- Base Table Class: Change
- Default Size: Order + Trade * 4 = 5000
Fields
| Name | Type | Size (bytes) | Description |
|---|---|---|---|
| Id | Integer (signed) | 8 | The unique identifier of this Level1. |
| 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 Level1_change. |
| InstrumentMarket | Foreign key to InstrumentMarket | 8 | |
| Field | One of LevelOneType | 1 | |
| Value | Integer (signed) | 8 | |
| Group | Integer (unsigned) | 8 | |
| GroupStart | Integer (unsigned) | 8 | |
| TransactionCount | Integer (unsigned) | 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 Level1_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 Level1. |
| CreateTimestamp | Integer (unsigned) | 8 | The time at which this Level1 was created. |
| UpdateUser | Foreign key to User | 8 | The Id of the User that last updated this Level1. |
| UpdateTimestamp | Integer (unsigned) | 8 | The time at which this Level1 was last updated. |