| 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. |
| borrower_address | VARCHAR(16777216) | Stellar account (G…) or contract (C…) address that borrowed from the lending protocol. |
| liquidator_address | VARCHAR(16777216) | Stellar account (G…) or contract (C…) address that triggered the liquidation and received the seized collateral. |
| collateral_token_address | VARCHAR(16777216) | Contract address or asset identifier of the token seized as collateral. |
| collateral_token_symbol | VARCHAR(16777216) | Ticker symbol of the collateral token. |
| collateral_token_decimals | NUMBER(38,0) | Number of decimal places used to represent the collateral token’s smallest unit. |
| collateral_raw_amount_str | VARCHAR(16777216) | Unnormalized collateral amount in base units, stored as a string. |
| collateral_amount_str | VARCHAR(16777216) | Normalized collateral amount stored as a string to preserve full precision. |
| collateral_amount | FLOAT | Collateral amount normalized by the token’s decimal precision. |
| collateral_usd_amount | FLOAT | USD value of the seized collateral at the time of the event. |
| collateral_usd_exchange_rate | FLOAT | Collateral-token-to-USD exchange rate used to compute the USD value. |
| repay_token_address | VARCHAR(16777216) | Contract address or asset identifier of the token used to repay the debt. |
| repay_token_symbol | VARCHAR(16777216) | Ticker symbol of the token used to repay the debt. |
| repay_token_decimals | NUMBER(38,0) | Number of decimal places used to represent the repayment token’s smallest unit. |
| repay_raw_amount_str | VARCHAR(16777216) | Unnormalized amount of debt repaid in base units, stored as a string. |
| repay_amount_str | VARCHAR(16777216) | Normalized amount of debt repaid stored as a string to preserve full precision. |
| repay_amount | FLOAT | Amount of debt repaid normalized by the token’s decimal precision. |
| repay_usd_amount | FLOAT | USD value of the debt repaid at the time of the event. |
| repay_usd_exchange_rate | FLOAT | Repayment-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. |
