STRATIGRAPHY
Referencing tables: classification | collection | drillcore_box | locality | locality_description | locality_stratigraphy | reference | rock | sample | sample_series | specimen | stratigraphy_reference | stratigraphy_stratotype | stratigraphy_synonym | list_stratigraphy_rank | list_stratigraphy_scope | list_stratigraphy_status | list_stratigraphy_type | taxon | taxon_occurrence | taxon_type_specimen |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| stratigraphy | varchar | ||
| stratigraphy_en | varchar | ||
| stratigraphy_original | varchar | ||
| author_free | varchar | ||
| year | int | ||
| etymon | varchar | ||
| etymon_en | varchar | ||
| original_locality | varchar | ||
| original_rank | varchar | ||
| index_main | varchar | ||
| index_main_html | varchar | ||
| index_additional | varchar | ||
| index_additional_html | varchar | ||
| index_old | varchar | ||
| color_code_cgmw | varchar | ||
| color_code_additional | varchar | ||
| hierarchy_string | varchar | ||
| parent | int | stratigraphy | |
| type | int | list_stratigraphy_type | |
| rank | int | list_stratigraphy_rank | |
| scope | int | list_stratigraphy_scope | |
| status | int | list_stratigraphy_status | |
| region | varchar | ||
| region_en | varchar | ||
| lithology | varchar | ||
| lithology_en | varchar | ||
| max_thickness | double | ||
| description | text | ||
| description_en | text | ||
| definition | text | ||
| definition_en | text | ||
| age_base | double | ||
| age_top | double | ||
| age_precision | double | ||
| age_reference | int | reference | |
| age_chronostratigraphy | int | stratigraphy | |
| sort_within_parent | int | ||
| approved_ics | tinyint | ||
| approved_esk | tinyint | ||
| maaamet_kood | int | ||
| is_private | tinyint | ||
| remarks | text | ||
| id | int(auto increment) |
