This is an old revision of the document!

---

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=

base_site Details

base_sample Details

base_core Details

base_coresample Details

base_coresamplenuclidematch Details

=Measurement tables=

Tables storing data about geochemical measurements on a sample, including cosmogenic nuclide concentrations and other compositional data

_be10_al26_quartz Details

_c14_quartz Details

_cl36 Details

_he3_pxol Details

_he3_quartz Details

_major_element Details

_ne21_quartz Details

_trace_element Details

_u_th_quartz 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.

base_calculatedage Details

=Tables used in defining top-level applications=

base_application Details

base_application_sites Details =Tables used for organizing samples into collections= Mostly the function of these is to organize data for more intelligible display on the web server. base_calibrationdata Details base_calibrationdatasample Details base_project Details base_project_cores Details base_fundingsource Details base_project_funding_sources Details base_project_samples Details base_continent Details base_sector Details base_region Details =Tables involved in associating samples with publications= base_publication Details base_samplepublicationsmatch Details =Tables involved in associating samples with images or other data= base_imagefile Details base_imagefilescores Details base_imageurlpath Details base_document Details base_sampledocumentmatch Details base_sampleuserdata Details base_userfieldsproperty Details =Additional tables= Tables with ancillary data that are not commonly used. base_al_stds Details base_be_stds Details base_fieldpropername** Details