Sorry I get confused on the code I need to put in place in the table files to indicate that I have a foreign key back to a table. So here it goes:
I have a clients table with a primary key with a column name of id. I I also have a Deliveries table that has a client_id column that is a foreign key back to the clients table referencing the id column. What do I put in both the Clients Table and the Deliveries Table during initialization.
is in my Deliveries Table class but this produces an inner join where it thinks the Clients table has the column client_id but in fact the Deliveries table has the client_id foreign key. So does the above code need to go in the ClientsTable class?