I'm trying to query the token transactions using the schemas of Cardano-db-sync. When querying ADA transactions, I can easily see the input and output addresses with the values sent by joining the tx, tx_in, and tx_out tables, as shown in the examples here.
However, it is not as easy when I try to query token transactions. I used the multi_asset and ma_tx_out tables to identify which token was sent and in which transaction. I can see the address that received the token, but I cannot identify the address that sent the token when there are multiple input addresses.
For example, how can I know that (addr1q8h ... 8k5s6cnspc) sent the token and not the other input address in this transaction? Is it actually possible to do that by only joining the tables?