is there a point of a one to one relationship.
Is there ever a use case to create a seperate table for a one to one relationship. Because what is the difference of storing it the same table.
6 Replies
Imo it helps reduce the bulk of a commonly accessed table by moving some of its columns to a separate table
E.g., employee table is one to one matched to an Id card table
Idk, first thing that came to my mind
I'd assume there are some performance benefits to this, if used correctly
I'd say its pretty rare to have a link table for one-to-one. Much more common is that you just have a foreign key column
or an owned object
thanks
$close
Use the /close command to mark a forum thread as answered