search

specollective / insights-agent-api

2 stars 0 forks source link

Add new Data Model #20

Open dashcraft opened 1 year ago

dashcraft commented 1 year ago

We currently have survey and agent tables, but this is not scaleable.

We need to move the survey table fields to a new table/model called SurveyResults We need to add a new Survey Table, that has the following relationships:

Survey's have many users and many users can have many surveys Surveys have many survey results, survey results only have 1 survey Surveys have many data entries and data entries have one survey Users have many survey results, survey results only have 1 user

dashcraft commented 1 year ago

When this is complete, we'll need to create another ticket for exposing survey results and surveys to the api.

Also, if we can generate a unique identifier that has no special characters (only alpha numeric) for surveys, that'd be great. It doesn't have to be the id, it can be a field, but it needs to be unique and usable for postgres table names.