14.7. The Order Entry Schema

Before I move on to talking about active transactions, let's talk about the sample schema you'll be using for your transaction examples. The Order Entry (OE) schema contains a product set that is available for orders, and it is associated with the Human Resources (HR) schema you may already be familiar with. In this case, some of those employees are sales representatives who will take orders on behalf of your customers. Listing 14-1 shows the names of the tables in the default Order Entry schema.

Example 14.1. Order Entry (OE) Schema Tables

TABLE_NAME
------------------------------
CATEGORIES
CUSTOMERS
INVENTORIES
ORDERS
ORDER_ITEMS
PRODUCT_DESCRIPTIONS
PRODUCT_INFORMATION
WAREHOUSES