|
|
|
|
|
|
The Example Environment Structure
The example environment contains the following schemas: the MIMER_STORE schema, the MIMER_STORE_MUSIC schema, the MIMER_STORE_BOOK schema and the MIMER_STORE_WEB schema.
For more information, see the Mimer SQL User's Manual, Appendix A, The Example Environment.
The MIMER_STORE Schema
In this base schema most of the objects supported by Mimer SQL are introduced: collations, databanks, domains, idents, sequences, synonyms, tables and views. They are used to demonstrate some of the functionality that is available - constraints; primary, unique and foreign keys; secondary indices, NOT NULL, default values, and column and table check clauses. The schema also includes examples of PSM routines and triggers.
This schema contains the following tables: currencies, countries, categories, formats, producers, products, images, items, customers, orders, order_items, stop_words.
The MIMER_STORE_MUSIC Schema
This schema groups objects related to music and contains the following tables: artist, titles, tracks, samples
The MIMER_STORE_BOOK Schema
This schema groups objects related to books and contains the following tables: titles, authors, keywords
The MIMER_STORE_WEB Schema
This schema groups objects related to the Web business area and contains the following tables: which contains the following table: sessions
 Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |
|
|
|
|
|
|