## Geologists

id | name | email
--- | --- | ---
1 | John Doe | john@example.com
2 | Jane Smith | jane@example.com
3 | Michael Johnson | michael@example.com
4 | Emily Davis | emily@example.com
5 | David Brown | david@example.com

## Specimens

id | type | description
--- | --- | ---
1 | Rock | Igneous rock formed by cooling of magma.
2 | Fossil | Remains or impressions of prehistoric life preserved in petrified form or as a mold.
3 | Mineral | Naturally occurring solid substance with a definite chemical composition.
4 | Gemstone | Polished stone used to make jewelry or decorative objects.
5 | Metal Ore | Natural occurrence of metal-containing minerals from which metals are extracted.

## Geologists_Specimens

geologistId | specimenType
--- | ---
(→ Geologists.id) | (→ Specimens.type)
1 | Rock
2 | Rock
3 | Rock
4 | Rock
5 | Rock
1 | Fossil
2 | Fossil
3 | Fossil
4 | Fossil
5 | Fossil