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
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"