Connect to real DB #1
Description
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