Table Hierarchies

The following illustration shows how the hierarchical tables of the superstores_demo database are related. The foreign key and primary relationships between the two tables are indicated by shaded arrows that point from the customer.custnum and customer.loc columns to the location.location_id columns.
Figure 1: Hierarchies of superstores_demo Tables

Labelled rectangles depict 6 tables and their column names. Here retail_customer and whlsale_customer are subtables of customer, and location_us and location_non_us are subtables of location. End figure description