Sample Database Tables

The sample database tables distributed with Optim™ correlate to the tables used in these examples.

The Optim sample database tables are:

  • OPTIM_SALES
  • OPTIM_CUSTOMERS
  • OPTIM_ORDERS
  • OPTIM_DETAILS
  • OPTIM_ITEMS
  • OPTIM_MALE_RATES
  • OPTIM_FEMALE_RATES
  • OPTIM_SHIP_TO
  • OPTIM_SHIP_INSTR
  • OPTIM_STATE_LOOKUP
Note: The tables used here do not contain the prefix “OPTIM_” in their names.

The major relationships between pairs of tables in the sample database are shown in the following diagram. The arrows indicate the flow from parent to child.

graphic image of sample database tables

The sample database includes four additional tables: OPTIM_CUSTOMERS2, OPTIM_ORDERS2, OPTIM_DETAILS2, OPTIM_ITEMS2.

These four tables are distributed empty and are related in the same way as the similarly named tables in the sample database. The empty tables are provided for demonstrating the facilities in Optim.

For a complete description of the sample database tables, see the Installation and Configuration Guide.