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.

Sign up for GitHub

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

Jump to bottom

Add UserAnswers model and DB schema to orm.js #72

Closed
alodahl opened this issue Sep 13, 2020 · 1 comment · Fixed by #97
Closed

Add UserAnswers model and DB schema to orm.js #72

alodahl opened this issue Sep 13, 2020 · 1 comment · Fixed by #97
Assignees
@ambikasadhu1101
Labels
backend GHC2020 Project GraceHopperOSD Reserved for GHC Open Source Day! Hacktoberfest Priority 1 Do first!
Projects
Open-source issue board - Keyboard Sh...

Comments

@alodahl
Copy link
Collaborator

alodahl commented Sep 13, 2020 •
edited by vegetabill

A a new model in orm.js based on this definition

user_answers table / UserAnswers model

All of these columns are NOT NULL unless otherwise specified.

  • id: primary key / integer sequence
  • user_id: string (foreign key to users.id)
  • question_number: integer
  • is_correct: boolean
  • elapsed_time_ms: integer
  • created_at : timestamp (we don't need updated_at since this is immutable. this name can be configured in the sequelize model as we don't want the default camel case name)

Please use the sequelize docs
@alodahl alodahl added authentication backend GHC2020 Project GraceHopperOSD Reserved for GHC Open Source Day! Priority 3 Must finish before moving on to Priority 4. labels Sep 13, 2020
@vegetabill vegetabill changed the title Spike: plan a schema/model and field/column for Auth0 id Update User schema and model Oct 1, 2020
@vegetabill vegetabill changed the title Update User schema and model Update the models / db schema in orm.js Oct 1, 2020
@vegetabill vegetabill changed the title Update the models / db schema in orm.js Add UserAnswers model and DB schema to orm.js Oct 1, 2020
@vegetabill vegetabill added Priority 1 Do first! and removed Priority 3 Must finish before moving on to Priority 4. authentication labels Oct 1, 2020
@vegetabill vegetabill mentioned this issue Oct 1, 2020
Closed
@ambikasadhu1101
Copy link
Contributor

I'd like to work on this

@alodahl alodahl mentioned this issue Oct 1, 2020
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ambikasadhu1101 ambikasadhu1101

Labels
backend GHC2020 Project GraceHopperOSD Reserved for GHC Open Source Day! Hacktoberfest Priority 1 Do first!
Projects
Open-source issue board - Keyboard Sh...
  
Done
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

orm.js updated with model for UserAnswers ambikasadhu1101/keyboard-shortcuts-practice
3 participants
@vegetabill @alodahl @ambikasadhu1101