solana-transactions.sql

transactions.sql

CREATE TABLE default.transactions
(
    `epoch` UInt64,
    `slot` UInt64,
    `fee` UInt64,
    `fee_payer` String,
    `required_signatures` UInt8,
    `readonly_signed_accounts` UInt8,
    `readonly_unsigned_accounts` UInt8,
    `block_hash` String,
    `signature` String,
    `success` Bool,
    `error` Nullable(String),
    `recent_block_hash` String,
    `instructions` Array(Tuple(data String, executing_account String, account_arguments Array(String))),
    `inner_instructions` Array(Array(Tuple(data String, executing_account String, account_arguments Array(String)))),
    `account_keys` Array(String),
    `log_messages` Array(String),
    `pre_balances` Array(UInt64),
    `post_balances` Array(UInt64),
    `pre_token_balances` Array(Tuple(account String, mint String, owner String, amount Decimal(18, 18))),
    `post_token_balances` Array(Tuple(account String, mint String, owner String, amount Decimal(18, 18))),
    `signatures` Array(String),
    `signer` String,
    `signers` Array(String)
)