| address | VARCHAR(16777216) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies. |
| change_index | NUMBER(38,0) | Change index within the transaction. |
| data | VARIANT | ABI-encoded non-indexed parameters of an event log, or the calldata of a transaction/trace. Decode using the relevant ABI to extract individual field values. |
| handle | VARCHAR(16777216) | Move resource handle (storage address) for this table entry or event key. |
| key | VARCHAR(16777216) | Key field for this event attribute, state entry, or key-value pair. |
| state_key_hash | VARCHAR(16777216) | Hash of the state key identifying the storage slot being read or written. |
| type | VARCHAR(16777216) | The type of the position on the perpetual. |
| value | VARCHAR(16777216) | Amount of native currency (e.g. ETH, MATIC) transferred with this transaction or trace, in the chain’s smallest unit (Wei for EVM chains). Zero for calls that don’t move native currency. |
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| transaction_index | NUMBER(38,0) | Zero-based position of the transaction within its block. The first transaction in a block has index 0. |
| transaction_version | NUMBER(38,0) | Monotonically increasing version number of the transaction on the Aptos blockchain. Aptos uses versions rather than block-scoped transaction indices. |
| transaction_payload_arguments | VARIANT | Array of encoded arguments passed to the transaction’s entry function. |
| transaction_payload_function | VARCHAR(16777216) | Fully-qualified Move function identifier called by this transaction (e.g., 0x1::coin::transfer). |
| transaction_payload_type | VARCHAR(16777216) | Type of the Aptos transaction payload (e.g., entry_function_payload, script_payload, multisig_payload). |
| transaction_payload_type_arguments | VARIANT | Array of Move type arguments for the generic function called in this transaction. |
| transaction_success | BOOLEAN | True if this Aptos transaction executed without errors. |
| transaction_type | VARCHAR(16777216) | Ethereum transaction envelope type. 0 = Legacy, 1 = Access List (EIP-2930), 2 = EIP-1559 dynamic fee. |
| block_hash | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| block_height | NUMBER(38,0) | Number of confirmed blocks between this block and the genesis block (inclusive). Unlike block_slot, this only increments for slots that produced a block. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| _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. |
| data_type | VARCHAR(134217728) | Move type of the data stored in this state key or change record. |
| type_address | VARCHAR(134217728) | Move package address component of a fully-qualified type (e.g. 0x2 in 0x2::coin::Coin). |
| type_module | VARCHAR(134217728) | Move module name component of a fully-qualified type (e.g. coin in 0x2::coin::Coin). |
| type_struct | VARCHAR(134217728) | Struct name component of a fully-qualified Move type. |
| type_struct_full | VARCHAR(134217728) | Full struct identifier including generic parameters (e.g. Coin). |
| type_num_generics | NUMBER(19,0) | Number of generic type parameters in this Move type. |
| type_param0 | VARCHAR(134217728) | Full string of the first generic type parameter. |
| type_param0_address | VARCHAR(134217728) | Package address of the first generic type parameter. |
| type_param0_module | VARCHAR(134217728) | Module name of the first generic type parameter. |
| type_param0_struct | VARCHAR(134217728) | Struct name of the first generic type parameter. |
| type_param1 | VARCHAR(134217728) | Full string of the second generic type parameter. |
| type_param1_address | VARCHAR(134217728) | Package address of the second generic type parameter. |
| type_param1_module | VARCHAR(134217728) | Module name of the second generic type parameter. |
| type_param1_struct | VARCHAR(134217728) | Struct name of the second generic type parameter. |
| type_param2 | VARCHAR(134217728) | Full string of the third generic type parameter. |
| type_param2_address | VARCHAR(134217728) | Package address of the third generic type parameter. |
| type_param2_module | VARCHAR(134217728) | Module name of the third generic type parameter. |
| type_param2_struct | VARCHAR(134217728) | Struct name of the third generic type parameter. |
| global_change_index | NUMBER(38,0) | Global order of the change. |