Every UNICOM Intelligence Data File is a file-based database that contains a SchemaVersion table, a Levels table, and an L1 table. If there are lower levels in the data hierarchy (that is, Metadata Model (MDM) variables within loops and grids), the UNICOM Intelligence Data File contains extra tables called L2, L3, L4, and so on, where each additional table represents one lower-level.

The following diagram shows an example schema that contains three lower-level tables:

To query the tables in the schema directly, you must run the SQLite3 command line access program, which you can download from this website:

However, do not use this method to update data or change the schema, because the UNICOM Intelligence Data File CDSC might no longer be able to use the file.