INTRO

The Governance Process in the Uniswap platform consists of three stages.

1. Request for Comment (RFC)

2. Temperature Check

3. Governance Vote

In the first stage, the proposer sends proposal in the forum, the minimum time for this stage is 7 days. In this stage, the proposer answers the community's questions about proposal. The second stage is the temperature survey stage. In this stage, the proposer conducts a quick survey to find out that the majority of the community agrees with proposal. This stage must get a quorum of 10 million votes with 10 million UNI. In this case, the proposal goes to the third stage. The minimum time for the temperature check stage is 5 days. In the third stage, the proposer sends his proposal and the maximum voting time is 7 days. At this stage, the proposed proposal must get 10 million votes to be approved.

METHOD

I must say that I could not establish a proper connection with the database introduced in the text of this challenge. Therefore, using the flipside database, I checked the data related to the Uniswap platform government proposal process in this topic. Using the ethereum.core.ez_decoded_event_logs table and placing the contract address 0x408ed6354d4973f66138c91495f2f2fcbd8724c3, which is Uniswap's address: Governor Bravo, in the ORIGIN_TO_ADDRESS item, filter the data using From EVENT_NAME='VoteCast' and joining this table with the ethereum.core.ez_snapshot table and setting the address of the voters equal and using the filter SPACE_ID = 'uniswap', I called the data related to the Uniswap platform government proposal process. In the ethereum.core.ez_snapshot table. I called parameters like number of votes and voters and number of proposers and number of proposals and related parameters.