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

# Settlement Pools

### Table Columns

| Column Name               | Data Type | Description                                                                                                                                                                                                                    |
| ------------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| project                   |           | Business name of the protocol being used (e.g. `uniswap`, `aave`, `lido`, `paraswap`). Consistent across verticals — every table with a `project` column uses this field to identify the top-level protocol brand.             |
| protocol                  |           | Specific version or variant of the protocol (e.g. `uniswap_v3`, `aave_v2`, `stargate_v2`). Qualifies the `project` field with version information.                                                                             |
| version                   |           | Schema version discriminator.                                                                                                                                                                                                  |
| chain                     |           | Slug identifying the blockchain this record belongs to (e.g. `ethereum`, `base`, `avalanche`, `solana`). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. |
| pool\_address             |           | Address of the EIP-1167 SettlementPool clone that holds the user's USDC collateral.                                                                                                                                            |
| pool\_uuid                |           | Off-chain identifier for the pool (uint128, kept as varchar). Joins to the V2 settlement records.                                                                                                                              |
| creator\_address          |           | Address that created the pool (the OLP vault).                                                                                                                                                                                 |
| rfq\_uuid                 |           | RFQ identifier (uint128, varchar) tied to the pool creation.                                                                                                                                                                   |
| parent\_quote\_uuid       |           | Parent quote identifier (uint128, varchar) for the pool-creating quote.                                                                                                                                                        |
| fee\_paid\_by             |           | Address that paid the pool-creation fee.                                                                                                                                                                                       |
| creation\_fee\_raw        |           | Raw pool-creation fee in USDC base units (6 decimals), as a string.                                                                                                                                                            |
| creation\_fee\_usdc       |           | Pool-creation fee normalized to USDC.                                                                                                                                                                                          |
| transaction\_hash         |           | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.                                                                                                                    |
| created\_block\_number    |           | Block number of the pool-creation transaction.                                                                                                                                                                                 |
| created\_block\_timestamp |           | Block timestamp (UTC) of the pool creation.                                                                                                                                                                                    |
| unique\_key               |           | Unique record key.                                                                                                                                                                                                             |
| \_created\_at             |           | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed.                                                                                                                  |
| \_updated\_at             |           | Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration).                                                                     |