| id | varbinary | Unique identifier of the proposal |
| app | varchar | Application or client used to create the proposal |
| end | bigint | Unix timestamp when voting ends |
| body | varchar | Full markdown body/description of the proposal |
| ipfs | varchar | IPFS hash of the proposal data |
| type | varchar | Voting type (e.g. single-choice, weighted, ranked-choice, approval) |
| space | varchar | Snapshot space (DAO) the proposal belongs to |
| start | bigint | Unix timestamp when voting begins |
| title | varchar | Title of the proposal |
| votes | bigint | Total number of votes cast on the proposal |
| author | varbinary | Address of the proposal creator |
| quorum | double | Minimum voting power required for the proposal to pass |
| scores | varchar | JSON-encoded final scores for each choice |
| symbol | varchar | Token symbol used for voting power display |
| choices | varchar | JSON-encoded array of available voting choices |
| created | bigint | Unix timestamp when the proposal was created |
| flagged | bigint | Flag indicating if the proposal has been flagged (1 = flagged) |
| network | varchar | Blockchain network ID used for strategy execution |
| plugins | varchar | JSON-encoded plugin configurations |
| privacy | varchar | Privacy mode for the vote (e.g. shutter for encrypted voting) |
| updated | bigint | Unix timestamp of the last update |
| snapshot | bigint | Block number snapshot used for voting power calculation |
| discussion | varchar | URL to an external discussion thread |
| strategies | varchar | JSON-encoded array of voting strategies |
| validation | varchar | JSON-encoded validation settings for proposal creation |
| scores_state | varchar | State of score calculation (e.g. final) |
| scores_total | double | Sum of all voting power across all choices |
| scores_updated | bigint | Unix timestamp when scores were last updated |
| scores_by_strategy | varchar | JSON-encoded breakdown of scores by each strategy |
