meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
dictionary:table_descriptions [2023/05/19 17:29] – gregbalcodictionary:table_descriptions [2023/11/30 18:06] (current) – joetulenko
Line 1: Line 1:
 This is a list of all the tables in the database that are relevant to data entry and maintenance, as well as most analysis applications. These are all the tables that are visible to the 'reader' login. This doesn't include a variety of tables with application back-end and user data.  This is a list of all the tables in the database that are relevant to data entry and maintenance, as well as most analysis applications. These are all the tables that are visible to the 'reader' login. This doesn't include a variety of tables with application back-end and user data. 
  
--- Primary site and sample definition tables --+Tables are listed here generally following the structure (cardinality) of ICE-D and by relevance for data entry and analysis.
  
-base_site +\\
-base_sample+
  
-base_core +===Tables used in defining top-level applications===
-base_coresample +
-base_coresamplenuclidematch+
  
---Measurement tables--+ICE-D is organized at the very top level by "Applications", or in other words the various research disciplines where cosmogenic nuclides are applied. For example, researchers who reconstruct alpine glacier histories around the world would put their data into the ICE-D ALPINE application. Whereas researchers who use cosmogenic nuclides to constrain fault slip rates by dating offset features would put their data in the ICE-D TECTONICS application. 
 + 
 +**base_application** [[dictionary:base_application|Details]] 
 + 
 +**base_application_sites** [[dictionary:base_application_sites|Details]] 
 + 
 +---- 
 +\\ 
 + 
 +===Tables having to do with geographic sorting=== 
 + 
 +Because each sample has geographic coordinates, there is not really any fundamental reason to include any kind of geographic region assignment in the database. However, there are some geographic sorting tables that are mainly used to make the 'browse by site' functionality in the web server easier to use.  
 + 
 +**base_continent** [[dictionary:base_continent|Details]] 
 + 
 +**base_sector** [[dictionary:base_sector|Details]] 
 + 
 +**base_region** [[dictionary:base_region|Details]] 
 + 
 +---- 
 +\\ 
 + 
 +===Primary site and sample definition tables=== 
 + 
 +These tables are used to describe the numerous field and geologic observations for 'surface' samples and 'core' samples collected on landforms. In general, landforms associated with specific geologic events 
 + 
 +**base_site** [[dictionary:base_site|Details]] 
 + 
 +**base_sample** [[dictionary:base_sample|Details]] 
 + 
 +**base_core** [[dictionary:base_core|Details]] 
 + 
 +**base_coresample** [[dictionary:base_coresample|Details]] 
 + 
 +**base_coresamplenuclidematch** [[dictionary:base_coresamplenuclidematch|Details]] 
 + 
 + 
 +---- 
 +\\ 
 + 
 +===Measurement tables===
  
 Tables storing data about geochemical measurements on a sample, including cosmogenic nuclide concentrations and other compositional data Tables storing data about geochemical measurements on a sample, including cosmogenic nuclide concentrations and other compositional data
Line 32: Line 69:
 **_u_th_quartz** [[dictionary_u_th_quartz|Details]] **_u_th_quartz** [[dictionary_u_th_quartz|Details]]
  
--- Additional tables -- 
  
-Tables with ancillary data that are not commonly used.+---- 
 +\\
  
-**base_al_stds** [[dictionary:base_al_stds|Details]]+===Tables involved in associating samples with publications===
  
-**base_be_stds** [[dictionary:base_be_stds|Details]]+**base_publication**  [[dictionary:base_publication|Details]]
  
-**base_fieldpropername** [[dictionary:base_fieldpropername|Details]]+**base_samplepublicationsmatch** [[dictionary:base_samplepublicationsmatch|Details]]
  
--- Tables maintained automatically by the server --+---- 
 +\\
  
-These tables don't contain any user-generated data, so are not involved in data upload, but can be used in queries. +===Tables involved in associating samples with images or other data===
  
-**base_calculatedage** [[dictionary:base_calculatedage|Details]]+**base_imagefile** [[dictionary:base_imagefile|Details]]
  
--- Tables used in defining top-level applications -- +**base_imagefilescores** [[dictionary:base_imagefilescores|Details]] 
  
-**base_application** [[dictionary:base_application|Details]]+**base_imageurlpath** [[dictionary:base_imageurlpath|Details]]
  
-**base_application_sites [[dictionary: base_application_sites|Details]]+**base_document** [[dictionary:base_document|Details]]
  
 +**base_sampledocumentmatch** [[dictionary:base_sampledocumentmatch|Details]]
  
 +**base_sampleuserdata** [[dictionary:base_sampleuserdata|Details]]
  
-  +**base_userfieldsproperty** [[dictionary:base_userfieldsproperty|Details]] 
--- Tables used for organizing samples into collections --+ 
 +---- 
 +\\ 
 + 
 +===Tables used for organizing samples into collections===
  
 Mostly the function of these is to organize data for more intelligible display on the web server.  Mostly the function of these is to organize data for more intelligible display on the web server. 
  
-base_calibrationdata +**base_calibrationdata** [[dictionary:base_calibrationdata|Details]]
-base_calibrationdatasample+
  
-base_continent+**base_calibrationdatasample** [[dictionary:base_calibrationdatasample|Details]]
  
-base_project +**base_project** [[dictionary:base_project|Details]]
-base_project_cores +
-base_fundingsource +
-base_project_funding_sources +
-base_project_samples+
  
-base_sector+**base_project_cores** [[dictionary: ase_project_cores|Details]]
  
-base_region+**base_fundingsource** [[dictionary:base_fundingsource|Details]]
  
 +**base_project_funding_sources** [[dictionary:base_project_funding_sources|Details]]
  
--- Tables involved in associating samples with publications+**base_project_samples** [[dictionary:base_project_samples|Details]]
  
-base_publication +---- 
-base_samplepublicationsmatch+\\
  
--- Tables involved in associating samples with images or other data --+===Tables maintained automatically by the server===
  
-base_imagefile +These tables don't contain any user-generated data, so are not involved in data upload, but can be used in queries. 
-base_imagefilescores +
-base_imageurlpath+
  
-base_document +**base_calculatedage** [[dictionary:base_calculatedage|Details]]
-base_sampledocumentmatch+
  
-base_sampleuserdata +---- 
-base_userfieldsproperty+\\ 
 + 
 +===Additional tables=== 
 + 
 +Tables with ancillary data that are not commonly used. 
 + 
 +**base_al_stds** [[dictionary:base_al_stds|Details]] 
 + 
 +**base_be_stds** [[dictionary:base_be_stds|Details]] 
 + 
 +**base_fieldpropername** [[dictionary:base_fieldpropername|Details]]