| project | VARCHAR(16777216) | Project slug of the lending protocol emitting the event (e.g. blend). |
| protocol | VARCHAR(16777216) | Specific protocol or pool identifier that qualifies the project. |
| lending_event | VARCHAR(16777216) | Category of the lending event (e.g. deposits, withdrawals, loans, repayments, liquidations). |
| event_name | VARCHAR(16777216) | Raw name of the Soroban event that produced this record. |
| market_address | VARCHAR(16777216) | Soroban contract address (C…) of the lending market or pool involved in the event. |
| depositor_address | VARCHAR(16777216) | Stellar account (G…) or contract (C…) address that deposited or supplied assets to the protocol. |
| target_address | VARCHAR(16777216) | Stellar account (G…) or contract (C…) address receiving the tokens. |
| token_address | VARCHAR(16777216) | Contract address or asset identifier of the token involved in the event. |
| token_symbol | VARCHAR(16777216) | Ticker symbol of the token (e.g. USDC, XLM). |
| token_decimals | NUMBER(38,0) | Number of decimal places used to represent the token’s smallest unit; used to normalize raw amounts. |
| raw_amount_str | VARCHAR(16777216) | Unnormalized token amount in base units, stored as a string. |
| amount_str | VARCHAR(16777216) | Normalized token amount stored as a string to preserve full precision. |
| amount | FLOAT | Token amount normalized by the token’s decimal precision (raw amount / 10^decimals). |
| usd_amount | FLOAT | USD value of the token amount at the time of the event. |
| usd_exchange_rate | FLOAT | Token-to-USD exchange rate used to compute the USD value. |
| extra_fields | VARIANT | VARIANT catch-all holding additional event fields not mapped to a dedicated column. |
| transaction_hash | VARCHAR(16777216) | Hash of the Stellar transaction that produced this record. |
| transaction_index | NUMBER(38,0) | Position of the transaction within its ledger. |
| operation_index | NUMBER(38,0) | Index of the operation within the transaction. |
| event_index | NUMBER(38,0) | Index of this event within the transaction. |
| topics0_symbol | VARCHAR(16777216) | First Soroban event topic, the event name symbol. |
| ledger_sequence | NUMBER(38,0) | Stellar ledger sequence number (ledger height). |
| ledger_close_time | TIMESTAMP_NTZ(9) | Timestamp (UTC) when the Stellar ledger closed and was validated by the network. |
| ledger_hash | VARCHAR(16777216) | Hash of the Stellar ledger containing this transaction. |
| transaction_successful | BOOLEAN | True if the Stellar transaction was included in a ledger and executed without errors. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. |
| _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. |
