STRATIGRAPHY
Contents: stratigraphic classifications
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 | User who first saved record | |
| date_added | datetime | Timestamp when record was created | |
| user_changed | varchar | User who last saved record | |
| date_changed | datetime | ||
| stratigraphy | varchar | name of stratigraphic unit, to avoid confusion it is always used together with unit except for system and higher rank units | |
| stratigraphy_en | varchar | name of stratigraphic unit in English | |
| stratigraphy_ru | varchar | ||
| stratigraphy_lv | varchar | ||
| stratigraphy_original | varchar | name in original publication | |
| reference | int | reference | |
| author_id | int | Author of the original name, does not necessarily coincide with original publication | |
| author_free | varchar | ||
| year | int | Year of the name given, does not necessarily coincide with original publication | |
| etymon | varchar | ||
| etymon_en | varchar | ||
| original_locality | varchar | ||
| original_rank | varchar | ||
| index_main | varchar | Unit index in HTML format, Schmidt index when using Estonian schema | |
| index_main_html | varchar | ||
| index_additional | varchar | Additional index for stratigraphic unit in HTML format, EGK index when using Estonian schema | |
| index_additional_html | varchar | ||
| index_old | varchar | ||
| color_code_cgmw | varchar | ||
| color_code_usgs | varchar | ||
| color_code_additional | varchar | hexadecimal RGB color code (for example white - ffffff, yellow - ffff00), for international units alternative USGS color palette is used | |
| hierarchy_code | varchar | hierarchy code, used to rank the records in the new version | |
| hierarchy_string | varchar | ||
| parent | int | hierarchy code for unit one rank higher (parent) | stratigraphy |
| type | int | type of unit, with options: chronostratigraphy, lithostratigraphy, biostratigraphy etc | list_stratigraphy_type |
| rank | int | rank in hierarchy depending on type of stratigraphy, available options when using lithostratigraphic unit: group, formation, member, bed | list_stratigraphy_rank |
| level | int | ||
| scope | int | geographic extent of the unit and its usability; available options: global, basin (paleocontinent), regional (region on a continent), local (limited area) | list_stratigraphy_scope |
| status | int | status of the unit, available options: formally defined (global units defined by GSSP), formally approved, | list_stratigraphy_status |
| region | varchar | üksuse kasutatavuse piirkond | |
| region_en | varchar | ||
| lithology | varchar | litoloogia lühiiseloomustus | |
| lithology_en | varchar | ||
| max_thickness | double | ||
| biostratigraphy_group_id | int | takson biostratigraafiliste üksuste puhul | |
| description | text | üksuse lühikirjeldus, tutvustus või iseloomustus | |
| description_en | text | ||
| definition | text | üksuse definitsioon | |
| definition_en | text | ||
| synonym_id | int | ||
| synonym | varchar | sünonüümide loetelu | |
| age_base | double | alumise piiri vanus, kasutatakse ainult kronostratigraafiliste üksuste puhul, ühikuks mega- aastad (Ma, miljon aastat) | |
| age_top | double | alumise piiri vanus, kasutatakse ainult kronostratigraafiliste üksuste puhul, ühikuks mega- aastad (Ma, miljon aastat) | |
| age_precision | double | alumise piiri vanus, kasutatakse ainult kronostratigraafiliste üksuste puhul, ühikuks mega-aastad (Ma, miljon aastat) | |
| age_reference | int | viide antud vanusemäärangule | reference |
| age_chronostratigraphy | int | vanus, lito- jm. ühikute puhul. väikseima mahuga kronostrt. üksus kuhu antud üksus mahub | 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 | lisainfo vabas vormis | |
| id | int(auto increment) | Automatically generated unique sequential primary key (record ID) | |
| timestamp | datetime | ajatempel, mis kajastab samuti andmete viimast muutmist, sisestab andmebaasimootor |
