SPECIMEN_UNION
Referencing tables: None
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| acronym | varchar | ||
| id | int | ||
| id_balticdiversity | int | ||
| collection_id | |||
| specimen_id | varchar | ||
| specimen_nr | varchar | ||
| class_id | int | ||
| name | varchar | ||
| species_id | int | ||
| taxon | int | taxon | |
| name_geology | varchar | ||
| name_geology_en | varchar | ||
| mineral_id | int | ||
| rock_id | int | ||
| locality_id | int | locality | |
| locality | varchar | ||
| locality_en | varchar | ||
| depth | double | ||
| latitude | double | ||
| longitude | double | ||
| country | varchar | ||
| country_en | varchar | ||
| maakond | varchar | ||
| vald | varchar | ||
| asustusyksus | varchar | ||
| locality_free | varchar | ||
| stratigraphy | int | stratigraphy | |
| lithostratigraphy | int | stratigraphy | |
| stratigraphy_free | varchar | ||
| agent | varchar | ||
| date_collected | date | ||
| date_collected_free | varchar | ||
| reference | int | reference | |
| reference_txt | varchar | ||
| original_status | varchar | ||
| remarks | text | ||
| date_added | datetime | ||
| date_changed | datetime | ||
| link | varchar | ||
| num_images | int | ||
| database_id | int | ||
| autonumber | int(auto increment) |
