Flipside Docs
Search…
Solana Fact Proposal Votes Realms
solana.fact_proposal_votes_realms
This table is in development and will be available in Velocity shortly. Realms is a governance platform on Solana that allows for the easy creation of a gated voting space and allows for proposal creation and voting. More can be found on Realms on their webpage.
The Realms ID and program ID can be found on Realms by clicking on a space, and then clicking on the params button on the far left side of the header. To find the proposal address, click on a proposal and look at the address that appears in the URL. Vote options are sourced from the transaction logs in the solana.fact_transactions table.
​
Field
Type
Description
block_timestamp
timestamp
The time the block began.
block_id
integer
Unique sequential number that identifies the current block.
tx_id
string
A unique key that identifies a transaction.
succeeded
boolean
A boolean that tells if a transaction successfully occurred or failed.
index
integer
Location of the event within the instructions of a transaction.
program_id
string
A program ID belonging to a space. The default program_id is "GovER...", but will vary if a space uses their own smart contract.
realms_id
string
An address unique to each space on Realms. A space can be a voting group, DAO, organization, etc.
proposal
string
An address unique to each proposal on Realms.
voter
string
The wallet address of the user voting on the proposal.
vote_account
string
An account automatically generated when a user casts a vote. This account is owned by the voter.
vote_choice
string
How the user voted. Either YES, NO, or ABSTAIN. Ranked votes are always YES, followed by a non-zero vote_rank.
vote_rank
integer
In a ranked vote, this will be the order of preference. Otherwise 0.
vote_weight
integer
The percentage of voting power put towards the vote option.
Copy link