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

The call_type and cust_calls Tables

The call_type and cust_calls tables are joined by the call_code column. The same call code can appear in more than one row of the cust_calls table because many customers can have the same type of problem. In the cust_calls table, the call_code column is a foreign key that references the call_code column in the call_type table. Figure 13 shows this relationship.

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