[US-1] Create users model and users table - Githubissues

H-BAHDON / class-of-our-own

At Code Your Future, trainee progress is tracked on a trainee tracker against milestones set by the Director of Education. But each trainee at CYF is on their own personal journey towards employment, and should really set their own milestones on their own roadmap.

MIT License

2 stars 1 forks source link

[US-1] Create users model and users table #38

Closed alexeyschepin closed 11 months ago

alexeyschepin commented 11 months ago

We need to create a User model and corresponding users table in our backend using the sequelize package. This is an essential step for managing user data within the application.

Read sequelize documentation first

Model Basics
Model Querying - Basics
Migrations
Have a look at how Users implemented in Jarrod's template

Users attributes:

id: integer
email: string
firstName: string
lastName: string
role: string
accessToken: string
refreshToken: string
createdAt: date
updatedAt: date

Check if any attributes are missing.

Acceptance criteria

sequalize's DB configuration setup in /server/config.js.
sequalize's file paths setup in .sequelizerc.
Users class has /server/models/users.js path.
Users has all necessary attributes defines.
DB migration lives in /server/migrations/ folder.