Polls #10

New Issue

noah · 2022-12-08T03:14:01Z

noah commented

2022-12-08 03:14:01 +00:00

New idea for a type of forum post: polls.

Top-level forum threads could have a poll attachment (in addition to a comment body as they currently have).

Example use cases of polls:

Classic polls to pick one of the choices
Feature request polls: choices are feature ideas, users can multi-select and vote for the ones they want most, users can write in their own options too and others can vote on those options.

Data schema design:

Polls table with attributes like:
- ID (primary key) and user_id
- Question/prompt text
- Expiration date (optional) - when it expires the poll shows the results and can't be voted on anymore.
- List of choices to pick from (arbitrary number of choices, no reasonable length constraint on each choice text)
- Configurable options per poll:
  - Users can select multiple options? With controls on how many votes each user gets.
  - Users can suggest new options? and it adds to the poll for other users to vote it up.
  - Users can change their vote later?
Votes table to record user responses to a poll
- poll_id, user_id, answer (string)
Forum threads could add a poll_id foreign key for posts that have a poll attachment.

New idea for a type of forum post: polls. Top-level forum threads could have a poll attachment (in addition to a comment body as they currently have). Example use cases of polls: * Classic polls to pick one of the choices * Feature request polls: choices are feature ideas, users can multi-select and vote for the ones they want most, users can write in their own options too and others can vote on those options. Data schema design: * Polls table with attributes like: * ID (primary key) and user_id * Question/prompt text * Expiration date (optional) - when it expires the poll shows the results and can't be voted on anymore. * List of choices to pick from (arbitrary number of choices, no reasonable length constraint on each choice text) * Configurable options per poll: * Users can select multiple options? With controls on how many votes each user gets. * Users can suggest _new_ options? and it adds to the poll for other users to vote it up. * Users can change their vote later? * Votes table to record user responses to a poll * poll_id, user_id, answer (string) * Forum threads could add a poll_id foreign key for posts that have a poll attachment.

noah added the

enhancement

label 2022-12-08 03:14:01 +00:00

noah referenced this issue

2022-12-21 03:16:39 +00:00

Web polls #12

noah closed this issue

2023-03-24 22:48:40 +00:00

Sign in to join this conversation.