[ETL] Use revenue + roundStakes from truevals to update slots. Use revenue + roundStakes from payouts to calculate user-relative revenue.

[idiom-bytes]

Background / motivation

Previous ETL implementation has a bunch of artifacts that need to be moved around... After hooking up slots, remove revenue & roundSumStakes from payout.

• Previous implementation for payout, also retrieves slots data.
• revenue/roundSumStakes from slots data is stored in payouts table
• payouts table if anything, should calculate user-relative-revenue but does not

I made some adjustments here as a pseudo-implementation but will implement these later after update & slots is integrated.

TODOs / DoD

After getting insert + updates in place, cleanup payout event and how user-relative-revenue is being calculated.

Tasks:

• Remove revenue and slots data from payouts table
• Calculate userRevenue inside payout (by using slots data) such that we have easy-to-access user-relative-revenue
• Revenues[] inside event truevals.slot[] also includes all user-relative revenue, but this would lead to a lot of joins
• Rather, we can optimize 1->N joins, by simply calculating user-relative revenue in the payouts event

[idiom-bytes]

This is now tracked with #1299, closing here and addressing this 1 by 1.