Schemas

The ORDERCUST demonstration database is subdivided into the following schemas

• ORDERPROC schema for administering orders,

• PARTS schema for administering components,

• ADDONS schema for administering BLOB objects.

In order to provide a complete description of the tables in the database, the table definition is shown in addition to the data contained in the table. Definition of a table using CREATE TABLE assumes a knowledge of terms such as name, data type and integrity constraint. These are described in section “SQL objects of a SESAM/SQL database”.

NULL values in tables are represented as empty fields.