Structure of the Tables

The stores_demo database contains information about a fictitious sporting-goods distributor that services stores in the western United States. This database includes the following tables:

• customer (page The customer Table)
• orders (page The orders Table)
• items (page The items Table)
• stock (page The stock Table)
• catalog (page The catalog Table)
• cust_calls (page The cust_calls Table)
• call_type (page The call_type Table)
• manufact (page The manufact Table)
• state (page The state Table)

Sections that follow describe each table. The unique identifying value for each table (primary key) is shaded.