Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

back: link roles to users in User Service #79

Closed
codegold79 opened this issue Dec 13, 2019 · 2 comments · Fixed by #86
Closed

back: link roles to users in User Service #79

codegold79 opened this issue Dec 13, 2019 · 2 comments · Fixed by #86
Assignees

Comments

@codegold79
Copy link
Collaborator

RoleIDs are not stored in the user table, nor is there a joint table that links user IDs and roleIDs. Consider these as well as other alternatives for linking users and roles.

@daved
Copy link
Member

daved commented May 21, 2020

AC

  • Create join table for users to have multiple roles
  • Update relevant migration file(s)
  • Ensure the user message contains the role ids
  • (Daved) Investigate data structures for queries with joins
  • (Daved) Investigate how limit/offset are affected by row data being duplicated in joins

*It's likely that we'll discuss whether to make multiple queries or a single query with fancy structure handling in order to hydrate a user and the related role data collection.

@daved
Copy link
Member

daved commented Oct 22, 2020

Closed by #86

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants