Online Documentation for SQL Manager for PostgreSQL
To establish a new relation (which is the foreign key in terms of database management):
- press the Create relation button on the New object toolbar;
- click the entity where the referential constraint should be created;
- click the referred entity;
- specify new foreign key properties using Foreign key Editor.
Hint: To create a relation, you can also use the corresponding item of the context menu.
Once the relation is created, it is displayed as a line between two entities in the diagram area. The style the line is drawn is determined by the diagram notation.