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.
Crosweller et al. Journal of Applied Volcanology 2012 1:4 doi:10.1186/2191-5040-1-4