3.2.2  :  Data Models

The structure of the Millennium database is illustrated in the following diagram



In this figure reactangles stand for tables, directed lines for foreign key relations between tables. The names next to the foreign keys correspond to the prefix for the columns in the table from which the foreignk key is pointing. In generel, the target of the foreign key is the primary key of the target table (indicated by the PK prefix). The dashed boxes around the various tables indicate which tables exist in which database. This model has the names corresponding to the full Millennium Run. The same model is reproduced in the milli-Millennium database, though the MPA tables there have an extra "M" in front of their name.

The tables are not complete, the full database schema can be examined from the left menu bar in the main query page.