Condition creation

Description of Each Table/View and Explanation of All Fields

conditional_tokens_condition_preparation

This table contains events for condition creation (condition preparation) in the Conditional Tokens protocol. These data describe which condition was prepared, which oracle services it, and how many outcomes the condition has.

• condition_id (String) — condition identifier (unique key of the condition in Conditional Tokens).

• oracle (String) — address of the oracle that will publish the outcome for the condition.

• question_id (String) — identifier of the question associated with the condition (in oracle/condition terms).

• outcome_slot_count (UInt32) — number of outcomes (slots) over which the payout can be distributed.

• event_id (String) — unique event identifier (internal record identifier).

• block_number (UInt64) — block number in which the event occurred.

• log_index (UInt32) — index of the event log within the block.

• transaction_index (UInt32) — transaction index within the block.

• contract_address (String) — address of the Conditional Tokens contract that emitted the event.

• block_hash (String) — block hash.

• block_timestamp (DateTime) — block timestamp (UTC).

• gas_used (UInt64) — gas used (execution context).

• gas_limit (UInt64) — block gas limit (contextual value).

• base_fee_per_gas (UInt256) — block base fee under EIP-1559.

• transaction_hash (String) — hash of the transaction that triggered the event.

• transaction_from (String) — transaction sender.

• transaction_to (String) — transaction recipient/target address.

• transaction_value (UInt256) — transaction value (native network token).

• transaction_gas (UInt64) — transaction gas limit.

• transaction_nonce (UInt64) — sender nonce.

• max_fee_per_gas (UInt256) — transaction maxFeePerGas (EIP-1559).

• max_priority_fee_per_gas (UInt256) — transaction maxPriorityFeePerGas (EIP-1559).

• inserted_at (DateTime) — time when the record was inserted into ClickHouse.