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

> Human-readable ethereum function signatures and log events.

The decoded schema is nested under the common database. Our decoded bucket of data comprises of 2 tables - function\_signatures and event\_signatures. Each signature is a mapping between the human-readable function signature and the 4-byte function selector used by EVM. See the official Ethereum Contract ABI documentation for more information.

## Function Signatures Table Columns

| Column Name      | Data Type | Description                                       | Example                                                               |
| ---------------- | --------- | ------------------------------------------------- | --------------------------------------------------------------------- |
| `text_signature` | VARCHAR   | The text representation of the function signature | `swapExactTokensForTokens(uint256,uint256,address[],address,uint256)` |
| `hex_signature`  | VARCHAR   | The hex encoded 4-byte function selector          | `0x38ed1739`                                                          |

Each signature is a mapping between the human-readable event signature and the 32-byte event selector used by the EVM. See the official Ethereum Contract ABI documentation for more information.                                                              |

## Event Signatures Table Columns

| Column Name      | Data Type | Description                                    | Example                                                              |
| ---------------- | --------- | ---------------------------------------------- | -------------------------------------------------------------------- |
| `text_signature` | VARCHAR   | The text representation of the event signature | `Transfer(address,address,uint256)`                                  |
| `hex_signature`  | VARCHAR   | The hex encoded 32-byte event selector         | `0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef` |