SPECIMEN_IDENTIFICATION_GEOLOGY
Referencing tables: None
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| specimen | int | specimen | |
| current | tinyint | ||
| class_id | int | ||
| mineral_id | int | ||
| rock | int | rock | |
| name | varchar | ||
| name_en | varchar | ||
| agent | int | agent | |
| date_identified | date | ||
| date_identified_free | varchar | ||
| reference | int | reference | |
| type | int | list_identification_type | |
| remarks | text | ||
| id | int(auto increment) | ||
| timestamp | datetime |
