Table Details
| Property | Value |
|---|---|
| Table Name | stellar.lending.defaulted_debt |
| Table Status | Production-Ready |
| Unique Key | transaction_hash, unique_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| 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. |
| 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. |
| 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. |