STRATIGRAPHY
Referencing tables: classification | collection | drillcore_box | locality | locality_description | locality_stratigraphy | rock | sample | sample_series | specimen | specimen_union | stratigraphy_reference | stratigraphy_stratotype | stratigraphy_synonym | 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_ru | varchar | ||
| stratigraphy_lv | varchar | ||
| stratigraphy_original | varchar | ||
| reference | int | reference | |
| author_id | int | ||
| 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_usgs | varchar | ||
| color_code_additional | varchar | ||
| hierarchy_code | varchar | ||
| hierarchy_string | varchar | ||
| parent | int | stratigraphy | |
| type | int | list_stratigraphy_type | |
| rank | int | list_stratigraphy_rank | |
| level | int | ||
| scope | int | list_stratigraphy_scope | |
| status | int | list_stratigraphy_status | |
| region | varchar | ||
| region_en | varchar | ||
| lithology | varchar | ||
| lithology_en | varchar | ||
| max_thickness | double | ||
| biostratigraphy_group_id | int | ||
| description | text | ||
| description_en | text | ||
| definition | text | ||
| definition_en | text | ||
| synonym_id | int | ||
| synonym | varchar | ||
| age_base | double | ||
| age_top | double | ||
| age_precision | double | ||
| age_reference | int | reference | |
| age_chronostratigraphy | int | stratigraphy | |
| sort_within_parent | int | ||
| in_estonia | tinyint | ||
| in_east_baltic | tinyint | ||
| in_scandinavia | tinyint | ||
| approved_ics | int | ||
| approved_esk | int | ||
| maaamet_kood | int | ||
| has_paleomap | int | ||
| paleomap_layers | varchar | ||
| private | tinyint | ||
| is_private | tinyint | ||
| remarks | text | ||
| id | int(auto increment) | ||
| timestamp | datetime |
