Touchstone 2022 Database Reference
AIRDBAdmin Database
Description

The AIRDBAdmin database stores the scripts needed to create or upgrade the AIRExposure and  AIRResult tables.

Schema Diagram

You can view a diagram of the AIRDBAdmin database in Schema Diagrams.

Tables
TableDescription
Stores information about any packages applied to the database.
Stores information about the version of the database.

Stores information about the packages applied to the environment.

During system events such as register or upgrade events, the system uses the information in the table to determine whether a package applies to a target database.

Stores the SQL scripts that comprise packages.

Stores information about the scripts that Touchstone uses to create databases dynamically.

The content of the script is available in tScriptContent Table.

Stores the content of the scripts that Touchstone uses to create databases dynamically. 

More information about the scripts is available in tScript Table.

Stores a list of all SID (sequential identifier) tables in the database and the last SID value in each table. After each insert operation, Touchstone updates the SID value.
Stores information about upgrade scripts.

Stores database version information that Touchstone uses when dynamically creating databases.