ROCK
Referencing tables: locality_description | rock_classification | rock_element | rock_image | rock_locality | rock_mineral | rock_property | rock_reference | rock_synonym | rock_tree | sample | specimen_identification_geology |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| name | varchar | ||
| name_en | varchar | ||
| name_ru | varchar | ||
| rock_type | int | rock_type | |
| rock_rank | int | rock_rank | |
| parent | int | rock | |
| rock_group | int | rock | |
| synonym_of | int | rock | |
| sort | int | ||
| description | text | ||
| description_en | text | ||
| description_ru | text | ||
| description_in_estonia | text | ||
| description_in_estonia_en | text | ||
| description_in_estonia_ru | text | ||
| description_usage | text | ||
| description_usage_en | text | ||
| description_usage_ru | text | ||
| description_author | varchar | ||
| in_estonia | tinyint | ||
| is_resource | tinyint | ||
| stratigraphy | int | stratigraphy | |
| lithostratigraphy | int | stratigraphy | |
| mindat_id | int | ||
| meteorite_id | int | ||
| link_wikipedia | varchar | ||
| link_wikipedia_en | varchar | ||
| link_wikipedia_ru | varchar | ||
| ima_status | int | ||
| formula | varchar | ||
| formula_html | varchar | ||
| mineral_id | int | ||
| remarks | text | ||
| is_private | tinyint | ||
| in_portal | tinyint | ||
| id | int(auto increment) | ||
| timestamp | datetime |
