| project | VARCHAR(16777216) | Project slug of the DEX that owns the pool: aquarius or aqua_router (Aquarius), soroswap, phoenix or sushiswap. |
| protocol | VARCHAR(16777216) | Protocol identifier that qualifies the project: aquarius, soroswap, phoenix or sushiswap_v3. |
| date_added | TIMESTAMP_NTZ(9) | Date the factory/protocol contract was registered as a pool source. |
| contract_id | VARCHAR(16777216) | Factory/router contract that emitted the pool creation event. For Phoenix, the factory contract whose diagnostic event the pool was discovered from. |
| liquidity_pool_address | VARCHAR(16777216) | Contract address of the liquidity pool. |
| token0_contract_id | VARCHAR(16777216) | Contract id of the pool’s first token. Null for Phoenix pools. |
| token1_contract_id | VARCHAR(16777216) | Contract id of the pool’s second token. Null for Phoenix pools. |
| fee_bps | VARCHAR(16777216) | Pool swap fee as emitted at pool creation, stored as a string. Units differ by protocol: Aquarius reports basis points from its add_pool event, while SushiSwap V3 holds the raw fee tier from its pool_created event, not converted to basis points. Null for Soroswap and Phoenix. |
| event_type | VARCHAR(16777216) | Type of the event that created the pool. For Phoenix, the type of the most recent factory diagnostic event that references the pool. Null for SushiSwap V3 pools. |
| event_index | NUMBER(38,0) | Index of the creation event within its transaction. Null for SushiSwap V3 pools. |
| extension | VARCHAR(16777216) | XDR extension data on the creation event, used for forward-compatible changes. Null for SushiSwap V3 pools. |
| ledger_sequence | NUMBER(38,0) | Sequence number of the Stellar ledger containing the pool creation event. |
| ledger_close_time | TIMESTAMP_NTZ(9) | Timestamp (UTC) when the Stellar ledger containing the pool creation event closed and was validated by the network. |
| ledger_hash | VARCHAR(16777216) | Hash of the Stellar ledger containing the pool creation event. |
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| transaction_index | NUMBER(38,0) | Position of the transaction within its ledger. |
| transaction_result | VARCHAR(16777216) | Stellar transaction result code. |
| transaction_successful | VARCHAR(16777216) | Whether the creation transaction succeeded. Null for SushiSwap V3 pools. |
| unique_id | VARCHAR(16777216) | Unique identifier of the pool creation event, carried over from the Stellar raw events tables. Null for SushiSwap V3 pools. |
| _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. |
