id | BIGINT | Surrogate identity for the swap-fee record (auto-incremented). |
pool_uid | BYTEA | Pool identifier (internal). Join to pool metadata and fee terms. |
block_number | BIGINT | Block height where the swap was observed. |
block_time | TIMESTAMPTZ | UTC timestamp of the block containing the swap event. |
tx_index | INTEGER | Transaction index within the block. |
log_index | INTEGER | Log index within the transaction. |
token_in | BYTEA | 20-byte address of the input token (direction of swap). |
token_out | BYTEA | 20-byte address of the output token (direction of swap). |
fee_token | BYTEA | 20-byte token address the fee is denominated in (must equal token_in or token_out). |
amount_in | NUMERIC(78,18) | Executed input amount (decimals-adjusted). |
amount_out | NUMERIC(78,18) | Executed output amount (decimals-adjusted). |
fee_amount_total | NUMERIC(78,18) | Total fee amount in fee_token units (decimals-adjusted). |
fee_amount_user | NUMERIC(78,18) | User/LP share of fees in fee_token units (nullable). |
fee_amount_protocol | NUMERIC(78,18) | Protocol share of fees in fee_token units (nullable). |
fee_amount_extra | NUMERIC(78,18) | Extra destination share of fees in fee_token units (nullable). |
_tracing_id | BYTEA | Deterministic BlockDB lineage identifier for the swap-fee record. |
_genesis_tracing_ids | BYTEA[] | Tracing IDs for the raw artifacts (blocks/logs) that seeded this record. |
_parent_tracing_ids | BYTEA[] | Tracing IDs for upstream derived records referenced during computation (e.g., fee terms). |
_created_at | TIMESTAMPTZ | Record creation timestamp. |
_updated_at | TIMESTAMPTZ | Record update timestamp. |
