Finding Relationships in MinistryPlatform
There is much evidence of these Primary/Foreign Key relationships in the platform. Here are three:
Advanced Search
The expandable folders in Advanced Search represent Foreign Keys. When you select these, the Platform adds a JOIN to your query to get fields from related tables. The Advanced Search uses the Table Lookup Convention to represent table joins.
Link Navigation
The small link icons represent Foreign Keys and related tables. Clicking on these follows the relationships to pages which represent the related tables. Clicking the link next to Contact Status: Active navigates to the Contact Statuses page, landing on the record "Active."
Drop-Down Lists and Pick-Lists
When editing a record, drop-down lists and pick-lists represent Foreign Keys. When you select an item, you are storing the Primary Key value of a related table in the Foreign Key Column of the page table.