gnucash sql lite tables

[Mark Fischer]

I am trying to write a report in iReport from gnucash.

I am able to follow the schedxactions table to the slots table and the
from-sched-xaction KVP.  I can't figure out how sched-xaction or
sched-xaction/credit-formula are related to from-sched-xaction.

What I am trying to get is the next scheduled time for the transaction the
amount and the name.

Thanks for any help you can provide.