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

# Effects

### Table Columns

Unique Key: `UNIQUE_ID`

| Column Name         | Description                                                      |
| ------------------- | ---------------------------------------------------------------- |
| ACCOUNT             | The account that was affected by this effect                     |
| ACCOUNT\_MUXED      | The muxed account address (if applicable)                        |
| ACCOUNT\_MUXED\_ID  | The muxed ID of the affected account                             |
| OPERATION\_ID       | The ID of the operation that caused this effect                  |
| TYPE                | The type of effect (e.g., account\_created, payment\_sent, etc.) |
| TYPE\_ID            | The numeric ID of the effect type                                |
| LEDGER\_SEQUENCE    | The sequence number of the ledger containing this effect         |
| LEDGER\_CLOSE\_TIME | The close time of the ledger containing this effect              |
| LEDGER\_HASH        | The hash of the ledger containing this effect                    |
| TRANSACTION\_HASH   | The hash of the transaction that caused this effect              |
| TRANSACTION\_INDEX  | The index of the transaction within the ledger                   |
| TRANSACTION\_RESULT | The result code of the transaction that caused this effect       |
| OPERATION\_INDEX    | The index of the operation within the transaction                |
| EFFECT\_INDEX       | The index of this effect within the operation                    |
| UNIQUE\_ID          | A unique identifier for this effect                              |
| EFFECT\_DETAILS     | Detailed information about the effect in JSON format             |
| \_CREATED\_AT       | Timestamp when this record was created                           |
| \_UPDATED\_AT       | Timestamp when this record was last updated                      |
| \_EXTRA\_FIELDS     | Additional fields not explicitly defined                         |