Sample Database Tables

Optim™ is distributed with sample database tables. These tables correlate with the tables used in the examples within this manual.

The sample database tables distributed with Optim are as follows. (Table names are prefixed with a Creator ID, which is specified at installation.)

•  OPTIM_SALES •  OPTIM_MALE_RATES
•  OPTIM_CUSTOMERS •  OPTIM_FEMALE_RATES
•  OPTIM_ORDERS •  OPTIM_SHIP_TO
•  OPTIM_DETAILS •  OPTIM_SHIP_INSTR
•  OPTIM_ITEMS •  OPTIM_STATE_LOOKUP
Note: The tables used in examples in this manual 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.

Relationship between tables, described as follows.

In this diagram, the relationships between tables are represented by three-character codes consisting of the letter "R", the first letter of the parent table, and the first letter of the child table.

The relationships between tables are as follows:

The sample database includes four additional tables:

•   OPTIM_CUSTOMERS2 •  OPTIM_DETAILS2
•   OPTIM_ORDERS2 •  OPTIM_ITEMS2

These four tables are distributed empty and are related in the same way as the similarly named tables described previously. The empty tables are provided for demonstrating the Insert Process.

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