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

Connect to real DB #1

Open
danielxhogan opened this issue Oct 4, 2023 · 0 comments
Open

Connect to real DB #1

danielxhogan opened this issue Oct 4, 2023 · 0 comments

Comments

@danielxhogan
Copy link
Owner

danielxhogan commented Oct 4, 2023

Ceate a DB on Planetscale and connect to prisma. Look over my old schema and start constructing the new schema. Extra fields I'll need to store will be:
User

  • role: for if a user is on free plan, paid plan, or admin(me)

New tables:

Follows:
keep track of what users follow what other users

MovieNights:
keep track of all scheduled movie nights and related info

MovieNightGuest:
for each movie night keep track of the guests that were invited, and whether they accepted, declined, or not responded

Notifications:
when a user gets invited to a movie night, create a notification for that user

Special Features:
Create a table to store data on all special features. Keep track of what movie they are associated with, title, subtitle, url, number of likes.

Articles:
Same as above

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

No branches or pull requests

1 participant