If I've understood the dbsync schema properly then the tx_in table is completely unnecessary. The two fields (tx_in_id & redeemer_id) should just be brought into the tx_out table and left null when a UTXO has not yet been consumed. This would be far more intuitive, or am I missing something?

1 Answer 1


db-sync is insert only. You need to be able to see what the state was at any particular point in time. If it modified rows that wouldn't allow you to do so.

  • Got it. But for my purposes (analysis) lt seems like can merge the tables without messing up the data. Cool.
    – Reddspark
    Mar 12, 2022 at 17:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.