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

# Decoded Traces

The decoded traces table contains decoded trace inputs and outputs based the trace selector and contract ABIs.

### Table Columns

Unique Key: `trace_id`

| Column Name                   | Data Type         | Description                                                                                                 | Example                                                                                                                                    |
| ----------------------------- | ----------------- | ----------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------ |
| name                          | VARCHAR           | Decoded trace call name.                                                                                    | transfer                                                                                                                                   |
| input\_params                 | VARIANT           | Decoded input data in JSON format.                                                                          | `{ "dst": "0x7a250d5630b4cf539739df2c5dacb4c659f2488d", "wad": "78435934549592564" }`                                                      |
| output\_params                | VARIANT           | Decoded output data in JSON format.                                                                         | `{ "arg": "True" }`                                                                                                                        |
| transaction\_hash             | VARCHAR           | Unique identifier of the transaction that contains this trace.                                              | 0x1082e21d7a815d737447d984c9a7d10945263934b53b362a036e3812372b07ee                                                                         |
| transaction\_index            | BIGINT            | The position of this transaction in the block that it belongs to. The first transaction has index 0.        | 0                                                                                                                                          |
| from\_address                 | VARCHAR           | The address of the sending party of this trace.                                                             | 0x43d6722b48b40d095e20f8ce7dd90e38f7dede47                                                                                                 |
| to\_address                   | VARCHAR           | The address of the receiving party of this trace (null for contract creation).                              | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2                                                                                                 |
| value                         | VARCHAR\*         | The amount of ether moved from the from\_address to to\_address.                                            | 0                                                                                                                                          |
| input                         | VARCHAR           | The bytecode of the call that is made to another smart contract.                                            | 0xa9059cbb0000000000000000000000007a250d5630b4cf539739df2c5dacb4c659f2488d0000000000000000000000000000000000000000000000000116a911207449f4 |
| output                        | VARCHAR           | The bytecode answer the smart contract that was called gives back.                                          | 0x0000000000000000000000000000000000000000000000000000000000000001                                                                         |
| trace\_type                   | VARCHAR           | The value of the method such as call, create, create2, suicide.                                             | call                                                                                                                                       |
| call\_type                    | VARCHAR           | The type of method such as call, delegatecall, staticcall. Learn more here.                                 | call                                                                                                                                       |
| reward\_type                  | VARCHAR           | Populated when trace\_type = reward. Possible values: block, uncle                                          |                                                                                                                                            |
| gas                           | BIGINT            | Gas provided with the trace call, in wei.                                                                   | 151133                                                                                                                                     |
| gas\_used                     | BIGINT            | The amount of gas consumed, in wei.                                                                         | 29962                                                                                                                                      |
| subtraces                     | BIGINT            | Number of children traces.                                                                                  | 0                                                                                                                                          |
| trace\_address                | VARCHAR           | The address of the trace within the call graph. More detail to come soon.                                   | 3,0                                                                                                                                        |
| error                         | VARCHAR           | Human readable developer error message. Examples: "Out of gas", "Reverted", etc.                            |                                                                                                                                            |
| status                        | BIGINT            | Success status of the trace. Either 1 (success) or 0 (failure).                                             | 1                                                                                                                                          |
| block\_timestamp              | TIMESTAMP\_NTZ(9) | The time when the block that contains this log was included on the blockchain.                              | 2023-04-03 22:01:59.000                                                                                                                    |
| block\_number                 | BIGINT            | The length of the chain, in blocks.                                                                         | 16971316                                                                                                                                   |
| block\_hash                   | VARCHAR           | Unique identifier of the block that includes this log.                                                      | 0xa21af1110bb2aab30679c39bd2cfa84a19ec39e43edcc4114a5e41ccfcd34ba3                                                                         |
| trace\_id                     | VARCHAR           | Unique identifier for this trace. Generated by combining trace\_type, transaction\_hash and trace\_address. | call\_0x1082e21d7a815d737447d984c9a7d10945263934b53b362a036e3812372b07ee\_3\_0                                                             |
| selector                      | VARCHAR           | Selector of the txn.                                                                                        | 0xa9059cbb                                                                                                                                 |
| input\_params\_keys\_mapping  | ARRAY             | Input parameters mapping.                                                                                   | \[ "dst", "wad" ]                                                                                                                          |
| output\_params\_keys\_mapping | ARRAY             | Output parameters mapping.                                                                                  | \[ "arg" ]                                                                                                                                 |
| interface\_id                 | VARCHAR           | Interface ID.                                                                                               | 76c51e4145c1160d3ab0018a65355f06                                                                                                           |
| \_created\_at                 | TIMESTAMP\_NTZ(9) | Timestamp of the entry creation.                                                                            | 2024-02-26 22:14:24.402                                                                                                                    |
| \_updated\_at                 | TIMESTAMP\_NTZ(9) | Timestamp of the entry update.                                                                              | 2024-02-26 22:14:24.402                                                                                                                    |