Skip to main content
Schema: blast.defi Table: ez_lending_repayments Type: View This table contains transactions in which a borrower repays their loan (debt) across the ORBIT, JUICE AND INIT protocols. Loans are repaid in the same asset borrowed, plus accrued interest. Borrowers can pay back their loan based on the USD price as they can borrow any of the available stable coins (USDC, DAI, USDT, etc.).

Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERAlso known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
ORIGIN_FROM_ADDRESSTEXTThe from address of this transaction.
ORIGIN_TO_ADDRESSTEXTThe to address of this transaction.
ORIGIN_FUNCTION_SIGNATURETEXTThe function signature of this transaction.
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed. This field will not be unique in this table, as a given transaction can include multiple events.
EVENT_INDEXNUMBEREvent number within a transaction.
CONTRACT_ADDRESSTEXTThe address interacted with for a given event.
EVENT_NAMETEXTThe decoded event name for a given event.
PLATFORMTEXTThe specific protocol where lending event occurred.
PAYERTEXTThe address that initiated the repayment.
BORROWERTEXTAddress that initiated the borrow event.
PROTOCOL_MARKETTEXTThe protocol’s specific lending asset token, ie cWBTC or aETHUni.
TOKEN_ADDRESSTEXTThe address of the token associated with the lending action.
TOKEN_SYMBOLTEXTThe symbol of the token associated with the lending action.
AMOUNT_UNADJFLOATThe non-decimal adjusted amount of tokens involved in the lending transaction.
AMOUNTFLOATThe decimal adjusted amount of tokens involved in the lending transaction, where available.
AMOUNT_USDFLOATThe value of the tokens in USD at the time of the lending transaction, where available.
EZ_LENDING_REPAYMENTS_IDTEXTThe unique identifier for each row in the table.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.