Touchstone 4.0 Database Documentation
Schema Diagrams

The following schema diagrams illustrate the relationship between the tables in the Touchstone databases. 


The key icons () represent primary keys.

The key icons that connect tables () represent the parent-child relationship between those tables.

The FKs are referred to as Sequential Identifiers (SID), which are unique identifiers generated by the application.

Table properties are dynamic, which means they display information only when the user selects certain configuration options.

In the AIRResult database, the primary keys point toward the Dim tables, which are the main (parent) tables that store data about the exposure objects (such as contract, location, layer, or accumulator). The (child) By tables, which store the analysis results, contain the foreign keys (FK) that reference the primary keys in the parent tables.



AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.