Miscellaneous Table

PoolsCreationBlock Table

Table Name: PoolsCreationBlock

Description: Tracks the creation of liquidity pools within specific blocks, essential for the dex pricing module which uses this information to identify which pools to initialize for a given block range.

Key: Block number (u64)

• Type: u64
• Description: The block at which liquidity pools were created.

Value: PoolsToAddresses

• Type: Vec<Address>
• Description: A list of addresses representing newly created liquidity pools for that block specified block.

InitializedState Table

Table Name: InitializedState

Description: Indicates which state data has been initialized and loaded into Brontes. This table helps in identifying the data that needs to be downloaded from Clickhouse to ensure that Brontes is up-to-date with the required data set.

Key: Block number (u64)

• Type: u64
• Description: Typically represents the highest block number for which the state has been initialized in the Brontes database.

Value: InitializedStateMeta

• Type: u8
• Description: A status byte indicating if tables have been initialized initialization for the given block.

Field Details

• State Meta:
  • Type: u8
  • Description: BitMap representing which tables have been downloaded and initialized for the given block number.