> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Repayments

### Table Details

| Property     | Value                           |
| ------------ | ------------------------------- |
| Table Name   | `stellar.lending.repayments`    |
| 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.                   |
| borrower\_address       | VARCHAR(16777216) | Stellar account (G...) or contract (C...) address that borrowed from the lending protocol.             |
| repayer\_address        | VARCHAR(16777216) | Stellar account (G...) or contract (C...) address that repaid the debt (may differ from the borrower). |
| 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.                                          |