Do not let any software impress you!

Only let it convince your intellect.
Slider img 1
Do not look for a business paradise!

It is a waste of time.
Slider img 2
Only yourself can push you uphill.

There is no easy road to prizes.
Slider img 3
Productivity is the name of the game.

And you have to conquer it.
Slider img 4
As long as you understand it,

you will start to build your know-how.
Slider img 5
We can help with that.

We have the tools and the method.
Slider img 6

Database Schema



We are storing the Database Schema is stored into the database in separate tables. Those tables are:

1) Core Mykosmos tables:

AU_SYS21: stores all the AU_* named tables.
AU_SYS22: stores all the fields and relations of the AU_* named tables.
AU_SYS23: stores all the indexes of the AU_* named tables.

The developer can not modify or add records to the above tables. The content of those tables is the core of Mykosmos. The content of those tables comes at every Developer installation/update and are into the AU_SYS21.DAT, AU_SYS22.DAT, and AU_SYS23.DAT. We are storing those in the RESOURCES directory.

If the developer wants to “refresh,“ the database goes to “Database Manager“ and imports those tables. Then “Reads Schema“ and “Upgrade Database“ in order core database changes take place into the working database.

2) Extra Fields to AU_* named tables:

AU_ESYS22: stored the extra fields and relations (consistently named e_*) into the AU_* named tables.
AU_ESYS23: stores all the additional indexes (consistently named e_*) of the AU_* named tables.

The developer is the one that maintains the content of the above two tables by adding extra fields and relations to adjust the database schema to the business needs. Note that the relations described in those tables can be with any of the tables of the database.

3) Local tables:

AU_KOS21: stores all the local maintained tables.
AU_KOS22: stores all the fields and relations of the local tables.
AU_KOS23: stores all the indexes of the local tables.

The developer is the one that maintains the content of the above three tables by adding extra tables, fields, and relations to adjust the database schema to the business needs. Note that the relations described in those tables can be with any of the tables of the database.

The table names in the local schema must not start with AU_ to not conflict with core table names.

We can export the content of all the above tables to the corresponding AU_*21.DAT, AU_*22.DAT, AU_*23.DAT into the RESOURCES directory to pack them into the “InstallServer.“

You may have noticed that other AU_*21, AU_*22, AU_*23 tables exist. These are AU_LOC21, AU_LOC22, AU_LOC23, AU_PRO22, AU_PRO23 and were used in older versions of Mykosmos.