id | SERIAL | Surrogate primary key for the table, used for joins and change tracking. |
name | TEXT | Short internal name for the pool archetype (e.g., uniswap_v2). |
dex_family | TEXT | DEX protocol family name (Uniswap, Balancer, Curve, etc.). |
version | TEXT | Semantic version or revision tag for the pool archetype. |
has_amp_param | BOOLEAN | True if AMM uses amplification coefficient (stable pools). |
has_weights | BOOLEAN | True if pool uses explicit token weights. |
has_tick_spacing | BOOLEAN | True if pool uses ticks or price ranges (CLAMM/UniV3). |
num_tokens_min | SMALLINT | Minimum number of tokens in this pool type. |
num_tokens_max | SMALLINT | Maximum number of tokens in this pool type (NULL = unbounded). |
fee_model | TEXT | Fee computation model name. |
notes | TEXT | Free-form notes describing quirks or routing considerations for the pool type. |
