In which table we should put the foreign key For example I have a table Admin and a table Role. To do one-to-one relationship between these two tables I can put the foreign key either in the Admin or the Role table. My doubt is if its icual put the foreign key either on the Amin or Role table?
The relationship between Admin and Role doesn't seem to be one-to-one. It's either one to many (One Role can be assigned to multiple people, then you will have FK column in Admin table), or many-to-many (then it's gonna be a link table with 2 FKs to each table).