Heuristics for Joins
By default, Pyramid uses an algorithm that assumes the first column in each table is the primary key column. It then finds each table's primary key column, and looks for tables containing the same column as a foreign key. Matching primary keys to corresponding foreign keys between tables is a common way of defining joins. However, Pyramid also allows you to change the default algorithm used for defining joins. To do this, right click on the canvas and go to the Auto-Relationship sub-menu:
- None: do not use any auto-relationship algorithm, and instead define the relationships manually.
- Use Primary Key as the First Column: by default, this algorithm is used to define relationships between the tables. It takes each table's primary key column and looks for tables that contain the same column as a foreign key.
- Match by Table Name: defines relationships by matching tables my name.
- Match by Column Name: defines relationships by matching columns by name.