movement.core Table: fact_transactions_block_metadata Type: View
Transaction block metadata including proposer and voting information. Contains detailed metadata
about block production.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_NUMBER | NUMBER | The block number. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The timestamp of the block. |
| TX_HASH | TEXT | The transaction hash. |
| VERSION | NUMBER | The transaction version number. |
| SUCCESS | BOOLEAN | Whether the transaction succeeded. |
| TX_TYPE | TEXT | The type of transaction. |
| SENDER | TEXT | The sender address. |
| SIGNATURE | OBJECT | The transaction signature. |
| PAYLOAD | OBJECT | The transaction payload. |
| PAYLOAD_FUNCTION | TEXT | The function called in the payload. |
| EPOCH | NUMBER | The epoch number. |
| EVENTS | ARRAY | Array of events emitted. |
| CHANGES | ARRAY | Array of state changes. |
| FAILED_PROPOSER_INDICES | ARRAY | Indices of failed proposers. |
| ID | TEXT | The block metadata ID. |
| PREVIOUS_BLOCK_VOTES_BITVEC | TEXT | Bit vector of previous block votes. |
| PROPOSER | TEXT | The block proposer address. |
| ROUND | NUMBER | The consensus round. |
| VM_STATUS | TEXT | The VM execution status. |
| STATE_CHANGE_HASH | TEXT | Hash of the state changes. |
| ACCUMULATOR_ROOT_HASH | TEXT | The accumulator root hash. |
| EVENT_ROOT_HASH | TEXT | The event root hash. |
| FACT_TRANSACTIONS_BLOCK_METADATA_ID | TEXT | Unique identifier for the row. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was last modified. |