aleo.core Table: fact_block_solutions Type: Base Table
Records of all prover solutions for each block, including block details, rewards, and
solution-specific information.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_ID | NUMBER | The block height the block was recorded at. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The timestamp at which the block began. |
| BLOCK_PUZZLE_REWARD | NUMBER | The total coinbase reward issued to the network for each block. |
| ADDRESS | TEXT | The unique address referring to an entity on the blockchain. |
| COUNTER | TEXT | A counter value associated with the solution. |
| EPOCH_HASH | TEXT | The hash of the epoch in which the solution was found. |
| SOLUTION_ID | TEXT | A unique identifier for the prover solution. |
| TARGET | NUMBER | The target difficulty for the block solution. |
| REWARD_RAW | NUMBER | The raw value of the reward for solving the block. |
| REWARD | FLOAT | The processed or formatted value of the reward for solving the block. |
| FACT_BLOCK_SOLUTIONS_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |
| _INVOCATION_ID | TEXT |