| pool_id | bigint | Unique surrogate primary key for the AMM pool record |
| amm_account_id | bigint | The on-ledger account that represents this AMM pool (→ accounts) |
| amm_account_address | string | XRPL address of the AMM pool’s on-ledger account |
| token_a_id | bigint | Surrogate key for the first asset in the pool (→ tokens) |
| token_a_currency | string | Currency code of the first pool asset (e.g. XRP, USD, or a hex-encoded custom code) |
| token_a_issuer_address | string | XRPL address of the account that issued the first pool asset; null if the asset is XRP |
| token_a_pool_balance | double | Current reserve of the first asset held in the pool; shifts with each swap |
| token_b_id | bigint | Surrogate key for the second asset in the pool (→ tokens) |
| token_b_currency | string | Currency code of the second pool asset (e.g. XRP, USD, or a hex-encoded custom code) |
| token_b_issuer_address | string | XRPL address of the account that issued the second pool asset; null if the asset is XRP |
| token_b_pool_balance | double | Current reserve of the second asset held in the pool; shifts with each swap |
| lp_token_id | bigint | Surrogate key for the LP token issued to liquidity providers in exchange for their deposit (→ tokens) |
| lp_token_currency | string | Currency code of the LP token representing a proportional share of this pool |
| lp_token_balance | varchar | Total outstanding LP token supply across all liquidity providers, stored as a string to preserve XRPL IOU precision; cast to a numeric type for arithmetic. Decreases as providers withdraw |
| trading_fee | double | Percentage fee charged on each swap through this pool; collected and shared among liquidity providers |
| created_ledger_index | bigint | Ledger index at which this AMM pool was created |
| created_timestamp | timestamp | Timestamp when this AMM pool was created |
| last_updated_ledger_index | bigint | Ledger index of the most recent swap, deposit, or withdrawal that changed this pool’s state |
| last_updated_timestamp | timestamp | Timestamp of the most recent change to this pool’s state |
| current_xrp_balance | double | Current XRP balance of the AMM pool account, if one of the paired assets is XRP |
| is_deleted | boolean | Whether this pool has been dissolved and is no longer active on the ledger |
| deleted_timestamp | timestamp | Timestamp when this pool was dissolved; null if still active |
