Public Interface Export Function › Tasks Related to All Tables › Model Table

Model Table

The Model Table (MODEL) can be referenced from all other tables and is used for model selection. Two of its columns are described in the following:

• NAME—Host Encyclopedia name of the model
• ID—A unique identifier of the model across the encyclopedia

All other tables contain at least two columns, described in the following:

• ID—A unique identifier of this object across the encyclopedia
• MODEL_ID—Identifies the model that contains this object.

  This column is joined with the ID column in the MODEL table to restrict selection to objects in the selected model.

The following syntax:

SELECT
  FROM MODEL, table
  WHERE MODEL.NAME = 'my model name'
  AND table.MODEL_ID = MODEL.ID;

Selects all rows from table that are in model my model name.