We need to capture a few basic pieces of information for the web portal in the short term, and will need it for future features such as (eventually) name, subscription status, etc.. We can keep this as minimal as possible to streamline the onboarding and mitigate security concerns.
Fields:
[ ] GitHub Username
[ ] Email
[ ] Onboarding Status
[ ] isActive
[ ] Timestamps
Steps
[ ] Create a new file src/server/db/tables/users.table.ts
[ ] Use a similar style to projects.table.ts to create an orchid-orm table
[ ] Add the new Users table to the src/server/db/db.ts db config object
[ ] Create a new migration in the src/server/db/migrations folder
[ ] Run npm run db migrate to create the table in the database
We need to capture a few basic pieces of information for the web portal in the short term, and will need it for future features such as (eventually) name, subscription status, etc.. We can keep this as minimal as possible to streamline the onboarding and mitigate security concerns.
Fields:
Steps
src/server/db/tables/users.table.ts
projects.table.ts
to create an orchid-orm tableUsers
table to thesrc/server/db/db.ts
db config objectsrc/server/db/migrations
foldernpm run db migrate
to create the table in the database