I'm not sure if this is possible: Say I have 2 tables and a many-to-many relationship between them. Let's say a Module can have multiple Lessons, and a Lesson can appear in multiple Modules. However, I'd like the lessons in each module to be in a particular order. In Module 1, Lesson A might appear as the very first lesson, but in Module 2, Lesson A may be the last lesson.
I am using an implicit many-to-many relationship in prisma right now. I'd love to not convert this to an explicit many-to-many, just for adding a simple ordering field. Will I have to? Or is there a way for me to keep implicit many-to-many, but order order the lessons for each module?
I'm using Prisma + MySQL.
