Hey guys, I'm new here and new to Prisma. I would ...
# orm-helpa
Adam Herbert
10/08/2021, 5:32 AMHey guys, I'm new here and new to Prisma. I would love some help, I am building a workout app using Prisma and MySQL and I'm struggling with designing the schema. I basically am unsure how to allow users to complete a workout and store their results. I have made a post with my initial models - https://stackoverflow.com/questions/69490891/workouts-app-schema-for-mysql-using-prisma. Any help or advice would be much appreciated.
d
Diego Feder
10/08/2021, 2:19 PMHey Adam.
I think your issue is more related to Database Architecture than to Prisma.
It could be good for you to design a ERD (Entity Relationship Diagram) and map everything you’re trying to design in your system.
Also, do you really the ‘Block’ model? If it’s really tied to a month, could it then be just a Workout “length” property?
a
Adam Herbert
10/09/2021, 6:50 AMThanks so much for the reply Diego, really appreciate it. Awesome, I have been through the videos and I am currently reworking my ERD 🙂
Adam Herbert
10/09/2021, 6:56 AMI'm slightly confused re your suggestion about removing the block and adding a length field. Just to clarify, a block would be 4 weeks, containing 5 workouts per week. A workout would be something like 'legs'. Would you suggest leaving the block table out completely?
2 Views