Database design » Creating a recursive relations


Recursive relationships are created by foreign keys that refer to the same table. The simplest example of such a relationship is the employee table, where each of them has a supervisor, also an employee of the company. The creation of such a relationship is the same as the normal one, with the difference that the parent and child tables are the same table. creating a recursive relationship In the relationship edit window, you can see the same table as parent and child. recursive relation - editing window Recursive relation in the diagram: recursive relation in the diagram

This site uses cookies. Learn more about the purpose of their use and changes in cookie settings.
By using the website you agree to the use of cookies in accordance with current browser settings.