input-output-hk
🛠️ [TASK] : DB Schema design for Vote Buffering
Summary
Design a DB Schems where votes are buffered before being written to imutable logs
Description
Design a DB table schema that is sufficient to store unique votes per proposal, per challenge, per registered voter, per fund. DB Design to include any additions needed for the Fund, Proposal and Challenge tables to hold the necessary id's. The aim here is not to re-implement jormungandr in a DB, but to rationalize the schema. If possible, there should be 1 voteplan per challenge. Challenges should be able to have different configurations in the same fund. We should re-use id's that already exist and not create multiple different id's for the same proposal or challenge which are used in different contexts. The only requirement is that the votes can be validly created, signed and tallied. Compatibility with Jormungandr limitations at the blockchain level is not required, and should not be aimed for.
