Database design » Create a one-to-many relationship


To create a relationship, click the Relation icon as shown below, and then drag the mouse cursor from the parent to the child table. creating a relationship (foreign key) After selecting the tables, the relationship creation window will open, where you should enter the name of the foreign key and link the columns of both tables. Note that the related columns should be of the same type. An attempt to bind columns of different types will fail. relationship edit window The relationship is created after clicking the Apply button. relation after insertion

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.