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

# Ledger Entry Changes

### Table Columns

Unique Key: `transaction_hash`, `ledger_entry_change_index`

| Column Name                  | Data Type         | Description                                                                                   |
| ---------------------------- | ----------------- | --------------------------------------------------------------------------------------------- |
| ledger\_entry\_change\_type  | VARCHAR           | The type of change made to the ledger entry                                                   |
| ledger\_entry\_change\_index | BIGINT            | The index of this specific ledger entry change within the transaction                         |
| ledger\_entry\_type          | VARCHAR           | The type of ledger entry that was changed                                                     |
| ledger\_entry\_index         | VARCHAR           | The index of this specific ledger entry within the ledger.                                    |
| ledger\_entry\_change\_data  | VARIANT           | JSON object containing the before and after states of the ledger entry, showing what changed. |
| ledger\_index                | BIGINT            | The sequence number of the ledger where this change occurred.                                 |
| ledger\_close\_time          | TIMESTAMP\_NTZ(9) | The timestamp when the ledger containing this change was closed.                              |
| ledger\_hash                 | VARCHAR           | The SHA-512Half hash of the ledger header where this change was recorded.                     |
| transaction\_hash            | VARCHAR           | The hash of the transaction that caused this ledger entry change.                             |
| transaction\_index           | BIGINT            | The index of the transaction within the ledger that caused this change.                       |
| \_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.                                  |