Prisma creates tables in MYSQL for each relation rather than having the foreign key reference in the actual node table. Is there anyway to have the foreign keys in the corresponding tables and resolve all the underscore relation tables ?

This workflow will improve with datamodel v2, https://github.com/prisma/prisma/issues/3408 look specifically for relations, feedback welcomed 🙏 Feel free to reach out if you have any questions.