One to Many Self Relations...

I have been trying to establish a self relation in my schema and have not find anything valuable yet.
What I want is this:
A user will have one of two roles "EDITORS"/"ADMIN".
An admin user will have editors associated with them.
An Editor user will have only one Admin to them.
Also I am using Planetscale :})
My current schema throws this error when i try to run studio
Error: There is not enough information to infer relation "users.adminToeditors"
Screenshot_2023-11-14_133423.png
Was this page helpful?