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 is described in the surrounding text. - end figure description
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]