Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
Table Details
| Property | Value |
|---|---|
| Table Name | ritual_testnet.raw.transactions |
| Table Status | Beta 🌱 |
| Unique Key | block_timestamp, hash |
| Clustering Key(s) | to_date("block_timestamp") |
| Search Optimization | hash, block_number, from_address, to_address |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| block_timestamp | TIMESTAMP_NTZ(9) | The time when the block that contains this transaction was included on the blockchain. |
| block_number | NUMBER(38,0) | The length of the chain, in blocks. |
| block_hash | VARCHAR(66) | Unique identifier of the block that includes this transaction. |
| hash | VARCHAR(66) | Unique identifier of a transaction. |
| nonce | NUMBER(38,0) | The transaction nonce, unique to the wallet |
| transaction_index | NUMBER(38,0) | The position of this transaction in the block that it belongs to. The first transaction has index 0. |
| transaction_type | NUMBER(38,0) | The integer of the transaction type, 0x0 for legacy transactions, 0x1 for access list types, 0x2 for dynamic fees. |
| from_address | VARCHAR(42) | The address of the sending party of this transaction. |
| to_address | VARCHAR(42) | The address of the receiving party of this transaction (could be a contract address). |
| value | VARCHAR(16777216) | The amount of ether sent in this transaction, in wei. |
| input | VARCHAR(16777216) | The data sent along with the transaction. |
| gas | NUMBER(38,0) | The maximum amount of gas allocated for this transaction in wei. |
| gas_price | NUMBER(38,0) | Cost per unit of gas specified by the transaction in wei. The higher the gas price, the higher chance of getting included in a block. |
| max_fee_per_gas | NUMBER(38,0) | The maximum fee per gas that the transaction sender is willing to pay for this transaction (introduced in EIP1559) |
| max_priority_fee_per_gas | NUMBER(38,0) | The maximum fee per gas the transaction sender is willing to give to validators (Proof of Stake) or miners (Proof of Work) to incentivize them to include their transaction (introduced in EIP1559) |
| receipt_cumulative_gas_used | NUMBER(38,0) | The total amount of gas used when this transaction was executed in the block. |
| receipt_gas_used | NUMBER(38,0) | The total amount of gas consumed by a transaction as recorded in its receipt |
| receipt_effective_gas_price | NUMBER(38,0) | The sum of the base fee and tip paid per unit of gas. |
| receipt_contract_address | VARCHAR(42) | The contract address created, if the transaction was a contract creation, otherwise null. |
| receipt_root | VARCHAR(66) | Transaction stateroot (pre Byzantium). |
| receipt_status | NUMBER(38,0) | Success status of the transaction. Either 1 (success) or 0 (failure). |
| log_count | NUMBER(38,0) | Number of event logs emitted in the transaction. |
| y_parity | NUMBER(38,0) | The parity (0 or 1) of the y-coordinate of the curve point for the signature’s recovery identifier. |
| access_list | VARIANT | A list of addresses and storage keys that the transaction plans to access, introduced in EIP-2930 to help optimize gas costs. |
| origin_tx | VARCHAR(16777216) | The original transaction that initiated this Ritual workflow. |
| origin_tx_rlp | VARCHAR(16777216) | RLP encoding of the original transaction that initiated this Ritual workflow. |
| commitment_tx | VARCHAR(16777216) | Reference to the commitment-phase transaction in the Ritual lifecycle. |
| settlement_tx | VARCHAR(16777216) | Reference to the settlement-phase transaction in the Ritual lifecycle. |
| index | NUMBER(38,0) | Position index of the transaction within a sequence, returned from the RPC response. |
| call_id | NUMBER(38,0) | Unique identifier for this Ritual call/inference request. |
| caller | VARCHAR(16777216) | Address that initiated the Ritual call. |
| user_address | VARCHAR(16777216) | The user address on whose behalf the call is executed. |
| executor_address | VARCHAR(16777216) | Address of the node/validator that executed the AI workload. |
| commitment_validator | VARCHAR(16777216) | Validator responsible for committing the result. |
| inclusion_validator | VARCHAR(16777216) | Validator responsible for inclusion of the call. |
| ttl | NUMBER(38,0) | Time-to-live for the Ritual call (in blocks or seconds). |
| frequency | NUMBER(38,0) | Execution frequency for recurring Ritual calls. |
| initial_block | NUMBER(38,0) | First block at which the Ritual call becomes executable. |
| settlement_block | NUMBER(38,0) | Block at which the Ritual call was settled. |
| executor_fee | NUMBER(38,0) | Fee paid to the executor for performing the AI workload. |
| commitment_fee | NUMBER(38,0) | Fee paid to the commitment validator. |
| inclusion_fee | NUMBER(38,0) | Fee paid to the inclusion validator. |
| total_amount | NUMBER(38,0) | Total amount paid for the Ritual call (sum of fees). |
| precompile_address | VARCHAR(16777216) | Address of the Ritual precompile invoked for the AI operation. |
| precompile_input | VARCHAR(16777216) | Input data passed to the precompile (model id, prompt, etc.). |
| spc_calls | VARIANT | Stateful precompile (SPC) calls made during the call. |
| delivery_spc_calls | VARIANT | Stateful precompile calls made during delivery/settlement. |
| receipt_origin_tx | VARCHAR(16777216) | Same as origin_tx but as recorded in the transaction receipt (post-execution state). |
| receipt_original_tx | VARCHAR(16777216) | Same as origin_tx but as recorded in the transaction receipt (post-execution state). |
| receipt_commitment_tx | VARCHAR(16777216) | Same as commitment_tx but as recorded in the transaction receipt (post-execution state). |
| receipt_settlement_tx | VARCHAR(16777216) | Same as settlement_tx but as recorded in the transaction receipt (post-execution state). |
| receipt_index | NUMBER(38,0) | The index of this Ritual call’s receipt. |
| receipt_call_id | NUMBER(38,0) | Same as call_id but as recorded in the transaction receipt (post-execution state). |
| receipt_caller | VARCHAR(16777216) | Same as caller but as recorded in the transaction receipt (post-execution state). |
| receipt_user_address | VARCHAR(16777216) | Same as user_address but as recorded in the transaction receipt (post-execution state). |
| receipt_executor_address | VARCHAR(16777216) | Same as executor_address but as recorded in the transaction receipt (post-execution state). |
| receipt_commitment_validator | VARCHAR(16777216) | Same as commitment_validator but as recorded in the transaction receipt (post-execution state). |
| receipt_inclusion_validator | VARCHAR(16777216) | Same as inclusion_validator but as recorded in the transaction receipt (post-execution state). |
| receipt_ttl | NUMBER(38,0) | Same as ttl but as recorded in the transaction receipt (post-execution state). |
| receipt_frequency | NUMBER(38,0) | Same as frequency but as recorded in the transaction receipt (post-execution state). |
| receipt_initial_block | NUMBER(38,0) | Same as initial_block but as recorded in the transaction receipt (post-execution state). |
| receipt_settlement_block | NUMBER(38,0) | Same as settlement_block but as recorded in the transaction receipt (post-execution state). |
| receipt_max_block | NUMBER(38,0) | Maximum block at which the call could be settled (deadline). |
| receipt_gas | NUMBER(38,0) | Gas allocated to the Ritual call’s receipt-side execution. |
| receipt_value | NUMBER(38,0) | Native value transferred at receipt time. |
| receipt_max_fee_per_gas | NUMBER(38,0) | Max fee per gas as recorded in the receipt. |
| receipt_max_priority_fee_per_gas | NUMBER(38,0) | Max priority fee per gas as recorded in the receipt. |
| receipt_executor_fee | NUMBER(38,0) | Same as executor_fee but as recorded in the transaction receipt (post-execution state). |
| receipt_commitment_fee | NUMBER(38,0) | Same as commitment_fee but as recorded in the transaction receipt (post-execution state). |
| receipt_inclusion_fee | NUMBER(38,0) | Same as inclusion_fee but as recorded in the transaction receipt (post-execution state). |
| receipt_total_amount | NUMBER(38,0) | Same as total_amount but as recorded in the transaction receipt (post-execution state). |
| receipt_precompile_address | VARCHAR(16777216) | Same as precompile_address but as recorded in the transaction receipt (post-execution state). |
| receipt_precompile_input | VARCHAR(16777216) | Same as precompile_input but as recorded in the transaction receipt (post-execution state). |
| receipt_spc_calls | VARIANT | Same as spc_calls but as recorded in the transaction receipt (post-execution state). |
| receipt_delivery_spc_calls | VARIANT | Same as delivery_spc_calls but as recorded in the transaction receipt (post-execution state). |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |