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