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

The orders and items Tables

The orders and items tables are linked by an order_num column that contains an identification number for each order. If an order includes several items, the same order number appears in several rows of the items table. In the items table, the order_num column is a foreign key that references the order_num column in the orders table. Figure 8 shows this relationship.

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