Deposit

Indexes deposits for specified addresses.

Useful for

• seeing all incoming transactions for an address;
• waiting and reacting for a transaction to arrive;

Cardano DB Sync equivalent SQL

SELECT block.slot_no
     , block.hash
     , tx.hash
     , tx_out.address
     , tx_out.value
  FROM block
  JOIN tx ON tx.block_id = block.id
  JOIN tx_out ON tx_out.tx_id = tx.id