Raw
Transactions
Table Columns
Unique Key: hash
| Column Name | Data Type | Description |
|---|---|---|
| hash | VARCHAR | The hash of the transaction, serving as its unique identifier. This is computed from the transaction data and signing key. |
| transaction_index | BIGINT | The position of this transaction within the ledger, indicating the order of transactions in the ledger. |
| transaction_result | VARCHAR | The result code indicating whether the transaction succeeded or failed (e.g., “tesSUCCESS”, “tecPATH_DRY”, “tefPAST_SEQ”). |
| signing_pub_key | VARCHAR | The public key used to sign this transaction, in hex format. This identifies the account that authorized the transaction. |
| account | VARCHAR | The address that submitted this transaction. This is the account that pays the transaction fee. |
| fee | VARCHAR | The transaction fee in drops (1 XRP = 1,000,000 drops). This is the amount paid to the network for processing the transaction. |
| sequence | BIGINT | The sequence number of the account at the time this transaction was submitted. Each account’s transactions must have sequential sequence numbers. |
| transaction_type | VARCHAR | The type of transaction (e.g., “Payment”, “OfferCreate”, “TrustSet”, “AccountSet”). Determines what the transaction does. |
| transaction_signature | VARCHAR | The cryptographic signature that proves the transaction was authorized by the account owner. |
| flags | BIGINT | Transaction flags that modify the behavior of the transaction. Different transaction types have different flag meanings. |
| last_ledger_sequence | VARCHAR | The highest ledger sequence number this transaction can be included in. If not included by this ledger, the transaction expires. |
| transaction_data | VARIANT | JSON object containing the transaction-specific fields and their values. The structure varies by transaction type. |
| ledger_index | BIGINT | The sequence number of the ledger that contains this transaction. |
| ledger_close_time | TIMESTAMP_NTZ(9) | The timestamp when the ledger containing this transaction was closed. |
| ledger_hash | VARCHAR | The hash of the ledger header that contains this transaction. |
| ledger_entry_change_count | BIGINT | The number of ledger entries that were modified by this transaction. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated in the database. |