Table description
This table provides insights into votes cast on proposals, highlighting voting patterns and outcomes.Table Schema
| Column Name | Type | Description |
|---|---|---|
| cb | bigint | Internal cursor/batch identifier |
| id | varbinary | Unique identifier of the vote |
| vp | double | Total voting power used for this vote |
| app | varchar | Application or client used to cast the vote |
| ipfs | varchar | IPFS hash of the vote data |
| space | varchar | Snapshot space (DAO) the vote was cast in |
| voter | varbinary | Address of the voter |
| choice | varchar | The choice(s) selected by the voter (JSON-encoded for weighted/ranked votes) |
| reason | varchar | Optional text reason provided by the voter |
| created | bigint | Unix timestamp when the vote was cast |
| metadata | varchar | Additional metadata associated with the vote |
| proposal | varbinary | Identifier of the proposal being voted on |
| vp_state | varchar | State of voting power calculation (e.g. final) |
| vp_by_strategy | varchar | Breakdown of voting power by each strategy (JSON-encoded) |