Database Conventions

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