| id | name | |
|---|---|---|
| 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 |
| 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. |
| 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 |