RNames - Help - Database Structure

Database Structure

Simplified structure of the RNames Database (rnames.luomus.fi/). The database contains eight related tables (blue and red objects) of which the object “Relations” is central. In “Relations” correlated stratigraphic units are listed by reference. Three output tables (yellow objects) list time binned stratigraphic units based on a search algorithm that uses “Relations” via R-Package RMySQL (the scripts are available under github.com/bjoekroe/RNames). Global Stages after Cooper et al. (2012). Abbreviations: ID, identifier; StS, Stage Slice (Bergström et al., 2009); TS, Time Slice (Webby et al., 2004)