aleo.core Table: fact_transactions Type: Base Table
Fact table containing information about all transactions on the network.
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. |
| TX_ID | TEXT | The unique identifier for the transaction. |
| INDEX | NUMBER | The index of the transaction within the block |
| TX_SUCCEEDED | BOOLEAN | |
| TX_TYPE | TEXT | The type of the transaction (e.g., ‘execute’, ‘deploy’, ‘fee’.) |
| FEE_MSG | VARIANT | |
| EXECUTION_MSG | VARIANT | The execution message data associated with the transaction. |
| DEPLOYMENT_MSG | VARIANT | The deployment message data associated with the transaction. |
| OWNER_MSG | VARIANT | The owner message data associated with the transaction. |
| FINALIZE_MSG | VARIANT | The finalize message data associated with the transaction. |
| REJECTED_MSG | VARIANT | The rejected message data associated with the transaction. |
| TRANSITION_COUNT | NUMBER | The number of transitions in the transaction. |
| FEE_RAW | NUMBER | The raw fee value from the transaction. |
| FEE | FLOAT | The native-unit fee value from the transaction. |
| FACT_TRANSACTIONS_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 | |
| FEE_PAYER | TEXT | The account that paid the fee for the transaction. |