Sample database tables and structure

As a group, the database tables include information on customers and orders, with shipping instructions. The sample tables also include information about sales and inventory. Minor differences in data types exist, depending upon the DBMS you use to install the sample tables. The following diagram shows the basic structure of the sample database.

As a group, the database tables include information on customers and orders, with shipping instructions. The sample tables also include information about sales and inventory. Minor differences in data types exist, depending upon the DBMS you use to install the sample tables.

An additional set of tables is also installed with the sample database. Tables in the additional set have the same names as tables in the first set, with the suffix “2” appended. The four tables in this additional set are:

Tables in the additional set do not contain data. They are used to demonstrate the facilities in Optim™.



Feedback