- Telegram authentication for voting (docs)
- You can create a poll without authenticating youself
- You can see polls without authenticating youself, but you won't be able to vote
- Sorting options (name/most voted)
- Poll shareable via id (random hash)
- Customization on creation page
- Single/multi-vote
- Show/hide voters
- Poll duration
- Allow users to add new options
- Probably AWS Lightsail for starter
- Docker alpine everything
- Should work as an independent API
- PostgreSQL
- Physical deletion
- user(id*, first_name, last_name, username, photo_url)
- poll(id*, description, multi_vote, show_voters, allow_add, end_date)
- poll_option(id*, poll_id^, description)
- poll_vote(option_id*^, user_id*^)
*
: pk
^
: fk cascade
?
: nullable