Raw
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 |