Hey everyone, what's a good way to turn an implicit many to many relation to be explicit.
I suddenly have a use where i need to do aggregate in the intermediate table.
Thank you for making Prisma btw, this is awesome
n
Nurul
04/29/2022, 9:41 AM
Hey Muhajir 👋
That would have to be done in multiple steps, so something like this:
1. Create the explicit table
2. Migrate existing data from the implicit table
3. Delete the implicit table and connect to the explicit one
m
muhajir
04/30/2022, 2:52 AM
Thanks @Nurul , is this a simple thing to do, I might do this multiple times in the future. Or should I just default to explicit table
n
Nurul
05/02/2022, 9:46 AM
If you are just starting out I would recommend starting with a explicit table to avoid all the hassles in future