| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The block timestamp of this transaction in UTC |
| BLOCK_NUMBER | NUMBER | The block number at which the transaction is finalized. |
| TX_HASH | TEXT | Transaction hash is a unique 66-character identifier that is generated when a transaction is executed. |
| ACTION | TEXT | The action that the user is taking. Borrow: user is borrowing an asset Repay: user is repaying the asset that they have borrowed in a previous loan Add collateral: user is depositing collateral for their loan. This happens some times in the same transaction as the borrowing transaction and some times in a separate transaction. Remove collateral: user is withdrawing collateral. This happens some times in the same transaction as the borrowing transaction and some times in a separate transaction. |
| BLOCKCHAIN | TEXT | BLOCKCHAIN column |
| PLATFORM | TEXT | This field denotes which application the liquidity pool belongs to. |
| ORIGIN_FROM_ADDRESS | TEXT | The address of the user who initiates the transaction. |
| ORIGIN_TO_ADDRESS | TEXT | The person who initiates the depositing transaction has to interact with this address. This address belongs to the lending platform or directs the transactio there. |
| ORIGIN_FUNCTION_SIGNATURE | TEXT | ORIGIN_FUNCTION_SIGNATURE column |
| ASSET | TEXT | ASSET column |
| BORROWER | TEXT | Its the address of the user who is Borrowing or repaying the loan, depending on the action. |
| BORROWER_IS_A_CONTRACT | TEXT | If the depositor of collateral is a contract then its a Yes, if the depositor of collateral is a normal address it is a No. |
| LENDING_POOL_ADDRESS | TEXT | The contract address for the lending pool. |
| AMOUNT | FLOAT | The meaning depends on the action: Borrow: The amount of the asset that the user is borrowing or Repay: The amount of the asset that the user is repaying Add collateral: The amount of collateral that the user is depositing Remove collateral: The amount of collateral that the user is withdrawing |
| AMOUNT_USD | FLOAT | The meaning depends on the action: Borrow: The amount of the asset in USD that the user is borrowing or Repay: The amount of the asset in USD that the user is repaying Add collateral: The amount of collateral in USD that the user is depositing Remove collateral: The amount of collateral in USD that the user is withdrawing |
| LENDING_POOL | TEXT | The name of the lending pool. |
| SYMBOL | TEXT | The symbol of the asset/collateral that is payed or received, depending on the action |
| _LOG_ID | TEXT | This is the primary key for this table. This is a concatenation of the transaction hash and the event index at which the event occurred. This field can be used within other event based tables such as & . |
