Database

The framework works using a database (MS-Access, MS-SQL Server) . The database comes with "ready" system tables. Those tables have names that start with the characters AU_. The system tables contain the basics of the business programming logic. (user names, company organogramm, contacts etc) The schema of the hole database i(system tables and developer provided tables) is stored into a set of "schema describing tables".

AU_SYS21	Table names and primary keys
AU_SYS22	Field names and relations
AU_SYS23	Index names

Contains tables that have names starting with an "AU_". Those tables store information about the users of an application, the company organogramm etc . This Schema is updated only with updates of kosmos AutoPilot.

AU_KOS21	Table names and primary keys
AU_KOS22	Field names and relations
AU_KOS23	Index names

Contains the tables that you the developer put into the database in order to store data for the specific application. This Schema is updated only with updates from the developer.

AU_LOC21	Table names and primary keys
AU_LOC22	Field names and relations
AU_LOC23	Index names

Contains the tables that the developer or his customer puts into the database in order to extent the functionality of the tables of the "standard application". This Schema is updated only with updates from the developer or the customer's programmer (if has the permission for that)

AU_PRO22	Field names and relations
AU_PRO23	Index names

Contains not extra tables but fields into the tables of the "standard application". This Schema is updated only with updates from the developer or the customer's programmer (if has the permission for that)