Home | Previous Page | Next Page   Appendix A. The stores_demo Database > Primary-Foreign Key Relationships >

The cust_calls and customer Tables

The cust_calls table and the customer table are joined by the customer_num column. The same customer number can appear in more than one row of the cust_calls table if the customer calls the distributor more than once with a problem or question. In the cust_calls table, the customer_num column is a foreign key that references the customer_num column in the customer table. Figure 12 shows this relationship.

Figure 12. Tables That the customer_num Column Joins
begin figure description -- This figure shows data from portions of rows in the cust_calls table and in the customer table, where the customer_num column in the cust_calls table is a foreign key that references the customer_num column in the customer table.  -- end figure description
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]