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

# Operations 🌱

### Table Details

| Property            | Value                                                                           |
| ------------------- | ------------------------------------------------------------------------------- |
| Table Name          | `stellar_testnet.raw.operations`                                                |
| Table Status        | Beta 🌱                                                                         |
| Unique Key          | `ledger_close_time`, `operation_id`                                             |
| Clustering Key(s)   | `to_date("ledger_close_time")`                                                  |
| Search Optimization | `ledger_sequence`, `transaction_hash`, `operation_id`, `source_account`, `type` |

### Table Columns

| Column Name                | Data Type         | Description                                                                                                                                                                                    |
| -------------------------- | ----------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| source\_account            | VARCHAR(16777216) | The account that submitted the operation                                                                                                                                                       |
| source\_account\_muxed     | VARCHAR(16777216) | The muxed account address (if applicable)                                                                                                                                                      |
| source\_account\_muxed\_id | VARCHAR(16777216) | The muxed ID of the source account                                                                                                                                                             |
| operation\_id              | VARCHAR(16777216) | The unique identifier for this operation                                                                                                                                                       |
| type                       | VARCHAR(16777216) | The type of operation (e.g., payment, create\_account, etc.)                                                                                                                                   |
| type\_id                   | NUMBER(38,0)      | The numeric ID of the operation type                                                                                                                                                           |
| ledger\_sequence           | NUMBER(38,0)      | The sequence number of the ledger containing this operation                                                                                                                                    |
| ledger\_close\_time        | TIMESTAMP\_NTZ(9) | The close time of the ledger containing this operation                                                                                                                                         |
| ledger\_hash               | VARCHAR(16777216) | The hash of the ledger containing this operation                                                                                                                                               |
| transaction\_hash          | VARCHAR(16777216) | The hash of the transaction containing this operation                                                                                                                                          |
| transaction\_index         | NUMBER(38,0)      | The index of the transaction within the ledger                                                                                                                                                 |
| transaction\_result        | VARCHAR(16777216) | The result code of the transaction containing this operation                                                                                                                                   |
| transaction\_successful    | BOOLEAN           | Whether the transaction containing this operation was successful                                                                                                                               |
| operation\_index           | NUMBER(38,0)      | The index of this operation within the transaction                                                                                                                                             |
| operation\_details         | VARIANT           | Detailed information about the operation in JSON format                                                                                                                                        |
| transaction\_events        | VARIANT           | List of Soroban transaction-scoped events emitted during transaction execution, as JSON. These are events not tied to a specific operation (e.g. fee events, transaction-level state changes). |
| \_created\_at              | TIMESTAMP\_NTZ(9) | Timestamp when this record was created                                                                                                                                                         |
| \_updated\_at              | TIMESTAMP\_NTZ(9) | Timestamp when this record was last updated                                                                                                                                                    |

### Related Docs

* [Stellar Raw Operations](/historical-data/supported-blockchains/other-ecosystems/stellar/raw/operations)