> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.                                                                                      |