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

# Events 🌱

### Table Details

| Property            | Value                                                |
| ------------------- | ---------------------------------------------------- |
| Table Name          | `stellar_testnet.raw.events`                         |
| Table Status        | Beta 🌱                                              |
| Unique Key          | `ledger_close_time`, `unique_id`                     |
| Clustering Key(s)   | `to_date("ledger_close_time")`                       |
| Search Optimization | `ledger_sequence`, `transaction_hash`, `contract_id` |

### Table Columns

| Column Name             | Data Type         | Description                                                                    |
| ----------------------- | ----------------- | ------------------------------------------------------------------------------ |
| contract\_id            | VARCHAR(16777216) | Address of the Soroban contract that emitted this event.                       |
| topics                  | VARIANT           | Array of topic values for the event (for filtering/indexing), as JSON.         |
| data                    | VARIANT           | Event payload data, as JSON.                                                   |
| event\_type             | VARCHAR(16777216) | Type of event (contract, system, diagnostic).                                  |
| event\_index            | NUMBER(38,0)      | Position of this event within its transaction.                                 |
| extension               | VARCHAR(16777216) | Reserved extension field, as JSON.                                             |
| ledger\_sequence        | NUMBER(38,0)      | Sequence of the ledger containing this event.                                  |
| ledger\_close\_time     | TIMESTAMP\_NTZ(9) | Time the containing ledger was closed (Unix timestamp).                        |
| ledger\_hash            | VARCHAR(16777216) | Hash of the ledger containing this event.                                      |
| transaction\_hash       | VARCHAR(16777216) | Hash of the transaction that produced this event.                              |
| transaction\_index      | NUMBER(38,0)      | Position of the transaction within its ledger.                                 |
| transaction\_result     | VARCHAR(16777216) | Result code of the parent transaction, as JSON.                                |
| transaction\_successful | BOOLEAN           | True if the parent transaction succeeded.                                      |
| operation\_index        | NUMBER(38,0)      | Position of the operation that produced this event (null for tx-level events). |
| unique\_id              | VARCHAR(16777216) | A synthetic primary key for this event row.                                    |
| \_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.                  |