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 base_sample

base_core base_coresample base_coresamplenuclidematch

–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

– Additional tables –

Tables with ancillary data that are not commonly used.

base_al_stds Details

base_be_stds Details

base_fieldpropername 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 base_calibrationdatasample

base_continent

base_project base_project_cores base_fundingsource base_project_funding_sources base_project_samples

base_sector

base_region

– Tables involved in associating samples with publications

base_publication base_samplepublicationsmatch

– Tables involved in associating samples with images or other data –

base_imagefile base_imagefilescores base_imageurlpath

base_document base_sampledocumentmatch

base_sampleuserdata base_userfieldsproperty