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 |
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.
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.