search

tulsawebdevs / services-voting

A microservice backend for tracking proposed meetup topics and civic projects and voting on them
1 stars 8 forks source link

Roughdraft for setup on Postgres db with tables for topics, projects,… #2

Closed Nomad-Rob closed 3 months ago

Nomad-Rob commented 3 months ago

Created the Postgres db based off the form data

zenlex commented 3 months ago

@Nomad-Rob one other thing I missed - you'll also need that same flat or pivot user structure to track authors of proposals from the post requests. We'll want to know who created them so we can follow up if needed but we aren't currently returning that authorship info on the GET endpoints for topics/projects so just wanted to make sure you saw that coming in from the form on the POST requests also for creating proposals. I'm ok with flat user_email column or a pivot join to a users list, we should just do it the same way for both votes and proposals in terms of tying them to user emails.