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

# Changes Enriched

### Table Details

| Property            | Value                                                                           |
| ------------------- | ------------------------------------------------------------------------------- |
| Table Name          | `aptos.raw.changes_enriched`                                                    |
| Table Status        | Production-Ready                                                                |
| Unique Key          | `block_timestamp`, `transaction_hash`, `change_index`                           |
| Clustering Key(s)   | `block_timestamp::date`                                                         |
| Search Optimization | `transaction_hash`, `type_module`, `type_struct`, `type_param0_address`, `type` |

### Table Columns

| Column Name                           | Data Type          | Description                                                                                                                                                                                |
| ------------------------------------- | ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| address                               | VARCHAR(16777216)  | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies.                                     |
| change\_index                         | NUMBER(38,0)       | Change index within the transaction.                                                                                                                                                       |
| data                                  | VARIANT            | ABI-encoded non-indexed parameters of an event log, or the calldata of a transaction/trace. Decode using the relevant ABI to extract individual field values.                              |
| handle                                | VARCHAR(16777216)  | Move resource handle (storage address) for this table entry or event key.                                                                                                                  |
| key                                   | VARCHAR(16777216)  | Key field for this event attribute, state entry, or key-value pair.                                                                                                                        |
| state\_key\_hash                      | VARCHAR(16777216)  | Hash of the state key identifying the storage slot being read or written.                                                                                                                  |
| type                                  | VARCHAR(16777216)  | The type of the position on the perpetual.                                                                                                                                                 |
| value                                 | VARCHAR(16777216)  | Amount of native currency (e.g. ETH, MATIC) transferred with this transaction or trace, in the chain's smallest unit (Wei for EVM chains). Zero for calls that don't move native currency. |
| transaction\_hash                     | VARCHAR(16777216)  | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.                                                                                |
| transaction\_index                    | NUMBER(38,0)       | Zero-based position of the transaction within its block. The first transaction in a block has index 0.                                                                                     |
| transaction\_version                  | NUMBER(38,0)       | Monotonically increasing version number of the transaction on the Aptos blockchain. Aptos uses versions rather than block-scoped transaction indices.                                      |
| transaction\_payload\_arguments       | VARIANT            | Array of encoded arguments passed to the transaction's entry function.                                                                                                                     |
| transaction\_payload\_function        | VARCHAR(16777216)  | Fully-qualified Move function identifier called by this transaction (e.g., 0x1::coin::transfer).                                                                                           |
| transaction\_payload\_type            | VARCHAR(16777216)  | Type of the Aptos transaction payload (e.g., entry\_function\_payload, script\_payload, multisig\_payload).                                                                                |
| transaction\_payload\_type\_arguments | VARIANT            | Array of Move type arguments for the generic function called in this transaction.                                                                                                          |
| transaction\_success                  | BOOLEAN            | True if this Aptos transaction executed without errors.                                                                                                                                    |
| transaction\_type                     | VARCHAR(16777216)  | Ethereum transaction envelope type. 0 = Legacy, 1 = Access List (EIP-2930), 2 = EIP-1559 dynamic fee.                                                                                      |
| block\_hash                           | VARCHAR(16777216)  | Cryptographic hash of the block header that contains this record. Uniquely identifies a block.                                                                                             |
| block\_height                         | NUMBER(38,0)       | Number of confirmed blocks between this block and the genesis block (inclusive). Unlike `block_slot`, this only increments for slots that produced a block.                                |
| block\_timestamp                      | TIMESTAMP\_NTZ(9)  | Timestamp (UTC) of the block that contains this record.                                                                                                                                    |
| \_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.                                                                                                                              |
| data\_type                            | VARCHAR(134217728) | Move type of the data stored in this state key or change record.                                                                                                                           |
| type\_address                         | VARCHAR(134217728) | Move package address component of a fully-qualified type (e.g. 0x2 in 0x2::coin::Coin).                                                                                                    |
| type\_module                          | VARCHAR(134217728) | Move module name component of a fully-qualified type (e.g. coin in 0x2::coin::Coin).                                                                                                       |
| type\_struct                          | VARCHAR(134217728) | Struct name component of a fully-qualified Move type.                                                                                                                                      |
| type\_struct\_full                    | VARCHAR(134217728) | Full struct identifier including generic parameters (e.g. Coin).                                                                                                                           |
| type\_num\_generics                   | NUMBER(19,0)       | Number of generic type parameters in this Move type.                                                                                                                                       |
| type\_param0                          | VARCHAR(134217728) | Full string of the first generic type parameter.                                                                                                                                           |
| type\_param0\_address                 | VARCHAR(134217728) | Package address of the first generic type parameter.                                                                                                                                       |
| type\_param0\_module                  | VARCHAR(134217728) | Module name of the first generic type parameter.                                                                                                                                           |
| type\_param0\_struct                  | VARCHAR(134217728) | Struct name of the first generic type parameter.                                                                                                                                           |
| type\_param1                          | VARCHAR(134217728) | Full string of the second generic type parameter.                                                                                                                                          |
| type\_param1\_address                 | VARCHAR(134217728) | Package address of the second generic type parameter.                                                                                                                                      |
| type\_param1\_module                  | VARCHAR(134217728) | Module name of the second generic type parameter.                                                                                                                                          |
| type\_param1\_struct                  | VARCHAR(134217728) | Struct name of the second generic type parameter.                                                                                                                                          |
| type\_param2                          | VARCHAR(134217728) | Full string of the third generic type parameter.                                                                                                                                           |
| type\_param2\_address                 | VARCHAR(134217728) | Package address of the third generic type parameter.                                                                                                                                       |
| type\_param2\_module                  | VARCHAR(134217728) | Module name of the third generic type parameter.                                                                                                                                           |
| type\_param2\_struct                  | VARCHAR(134217728) | Struct name of the third generic type parameter.                                                                                                                                           |
| global\_change\_index                 | NUMBER(38,0)       | Global order of the change.                                                                                                                                                                |
