Sample database tables

Optim™ solution is distributed with sample database tables. You can use these sample tables to test and demonstrate the facilities in the solution.

The distributed sample database tables correspond to the tables used in examples in the content. Typically, the examples do not show the "OPTIM_" prefix in table names. The sample tables are:

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

Relationships between tables, described as follows

In this diagram, the relationships between tables are represented by three-letter 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:

The sample database includes four additional tables:

These four tables are empty as distributed and are related in the same way as the similarly named tables that contain data. The empty tables are provided for demonstrating the facilities in the Optim solutions.



Feedback