Database Conventions

Top  Previous  Next

The following sections describe database conventions and system tables for the Crash Magic database.

 

Crash Magic uses several tables to store internal and user data for the program. These tables can be created through the Crash Magic Configuration Editor or created manually with the script produced by the Editor. Each table name must start with the prefix listed in the SQLTblPrifix box of the Crash Magic Configuration Editor for the configuration in use. Table prefix names should be limited to less than four characters.

 

The following is an example of the tables used by Crash Magic with a table prefix of cm1:

cm1ALIASES
cm1CID
cm1UGROUP
cm1LOGGEDIN
cm1PROJECT
cm1PSRATTR
cm1REPORT
cm1STUDY
cm1USER