Relationships Between Tables
Tables in PhixFlow are relational, which means that information in one table can be related to information in another table. Data can then be accessed in many different views without requiring duplication. See Creating Dashboards and Reports (Charts and Graphs).
A line connects the Primary Key or Secondary Key of one table to a Foreign Key in a different table and represents a relationship. See Relationship. Click on the image below to enlarge it.
One-to-Many and Many-to-One
The relationship line between a Primary Key or Secondary Key and Foreign Key represents a one-to-many relationship. In the below example, one teacher runs many courses.
A many-to-one relationship is implied when you read a relationship in the opposite direction. In the below example, many courses are run by one teacher. Click on the image below to enlarge it.
Many-to-Many
Many-to-many relationship can be supported with an intermediate table.