In most databases, relationships are defined with a primary key, PK, in table A and a foreign key, FK, in table B. However, some databases use multiple columns as the PK, which is known as a composite key.
Is it possible within Quick to establish relationships, like HasMany, if the tables use composite keys?
It might not be documented the best, but you can use composite or compound keys in both primary keys and relationships in Quick.
And each relationship method shows that it can take an array of keys as the foreign or related keys. It will also use multiple if the primary key of the related entity is a compound key.
This is great! Thanks @elpete. I submitted a change request to the docs to help explain composite relationships. Feel free to edit/change as you see fit.