| block_timestamp | TIMESTAMP_NTZ(9) | UTC timestamp of the block containing this transaction. |
| block_number | NUMBER(38,0) | Height of the block containing this transaction. |
| id | VARCHAR(16777216) | Unique transaction identifier (transaction hash). |
| orchestra_id | VARCHAR(16777216) | Identifier of the Orchestra operation this transaction belongs to, when applicable. |
| swap_id | VARCHAR(16777216) | Identifier of the swap this transaction is part of, when applicable. |
| transaction_index | NUMBER(38,0) | Position of this transaction within its block. |
| status | VARCHAR(16777216) | Lifecycle state of the transaction, e.g. sent (pending) or confirmed (final). Treat only confirmed as settled. |
| type | VARCHAR(16777216) | Transaction type, e.g. lightning_payment, spark_transfer, token_transfer, token_multi_transfer, token_mint, token_burn, bitcoin_deposit. |
| amount_sats | NUMBER(38,0) | Native BTC amount in satoshis, when the transaction carries a native value. |
| token_amount | NUMBER(38,0) | Token amount in the token’s smallest unit, when the transaction carries a token value. |
| value_usd | FLOAT | Indicative USD value of the transaction at scrape time (Sparkscan valueUsd); recomputed per scrape, so treat as approximate rather than a settled value. |
| bitcoin_txid | VARCHAR(16777216) | Underlying Bitcoin L1 transaction id, for transactions that settle on-chain (e.g. deposits/withdrawals). |
| created_at | TIMESTAMP_NTZ(9) | Timestamp when the transaction was first observed by the indexer. |
| updated_at | TIMESTAMP_NTZ(9) | Timestamp of the most recent indexer update to this transaction (e.g. a sent → confirmed transition). |
| expired_time | TIMESTAMP_NTZ(9) | Expiry timestamp for time-bound transactions (e.g. pending Lightning payments), when applicable. |
| token_transfer_count | NUMBER(38,0) | Number of token-transfer legs produced by this transaction (see the token_transfers table). |
| block_timestamp_unix | NUMBER(38,0) | Unix timestamp (seconds) of the block containing this transaction. |
| from_address_details | VARIANT | Structured sender detail (identifier, pubkey, type) from the raw record. Null for transaction types where the API does not populate a top-level sender (e.g. token_multi_transfer); use the transfer-level fields in token_transfers for those. |
| to_address_details | VARIANT | Structured recipient detail (identifier, pubkey, type) from the raw record. Null where the API does not populate a top-level recipient. |
| multi_io_details | VARIANT | Raw UTXO input/output breakdown (inputs[], outputs[], totals) for multi-transfer transactions. |
| token_metadata | VARIANT | Token metadata (name, ticker, decimals, token address/identifier) for token transactions. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
