Figure 1.

Conceptual diagram showing the current structure of the LaMEVE database. All the tables are linked via a one-to-many relationship whereby a single record in the parent table can relate to zero, one or many records in the child table. In instances where there is a many-to-many relationship between entities, this is resolved by using a linking table with a one-to-many relationship to each of the two entities. Dictionaries act as look-up tables for codes used in the main and other entities.