analysisunits

360389 rows


Description

This table stores the data for Analysis Units.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
analysisunitid serial 10 nextval('ndb.seq_analysisunits_analysisunitid'::regclass)
accumulationrates.analysisunitid fk_accumulationrates_analysisunitsC
analysisunitaltdepths.analysisunitid fk_analysisunitaltdepths_analysisunitsC
analysisunitlithostrat.analysisunitid fk_analysisunitlithostrat_analysisunitsC
chroncontrols.analysisunitid fk_chroncontrols_analysisunitsR
depagents.analysisunitid fk_depagents_analysisunitsC
eventchronology.analysisunitid evc_aluR
relativechronology.analysisunitid fk_relativechronology_analysisunitsC
samples.analysisunitid fk_samples_analysisunitsR
tephras.analysisunitid fk_tephras_analysisunitsC

An arbitrary Analysis Unit identification number.

collectionunitid int4 10 null
collectionunits.collectionunitid fk_analysisunits_collectionunitsC

Collection Unit ID number. Field links to CollectionUnits table. Every Analysis Unit belongs to a Collection Unit.

analysisunitname varchar 80 null

Optional name for an Analysis Unit. Analysis Units are usually designated with either a depth or a name, sometimes both.

depth float8 17,17 null

Optional depth of the Analysis Unit in cm. Depths are typically designated for Analysis Units from cores and for Analysis Units excavated in arbitrary (e.g. 10 cm) levels. Depths are normally the midpoints of arbitrary levels. For example, for a level excavated from 10 to 20 cm or for a core section from 10 to 15 cm, the depth is 15. Designating depths as midpoints and thicknesses facilitates calculation of ages from age models that utilize single midpoint depths for Analysis Units rather than top and bottom depths. Of course, top and bottom depths can be calculated from midpoint depths and thicknesses. For many microfossil core samples, only the midpoint depths are known or published; the diameter or width of the sampling device is often not given.

thickness float8 17,17 null

Optional thickness of the Analysis Unit in cm. For many microfossil core samples, the depths are treated as points, and the thicknesses are not given in the publications, although 0.5 to 1.0 cm would be typical.

faciesid int4 10 null
faciestypes.faciesid fk_analysisunits_faciestypesC

Sedimentary facies of the Analysis Unit. Field links to the FaciesTypes table.

mixed bool 1 null

Indicates whether specimens in the Analysis Unit are of mixed ages, for example Pleistocene fossils occurring with late Holocene fossils. Although Analysis Units may be mixed, samples from the Analysis Unit may not be, for example individually radiocarbon dated specimens.

igsn varchar 40 null

International Geo Sample Number. The IGSN is a unique identifier for a Geoscience sample. They are assigned by the SESAR, the System for Earth Sample Registration (www.geosamples.org), which is a registry that provides and administers the unique identifiers. IGSN’s may be assigned to all types of geoscience samples, including cores, rocks, minerals, and even fluids. Their purpose is to facilitate sharing and correlation of samples and sample-based data. For data in Neotoma, their primary value would be for correlation various samples from the same Analysis Units, for example pollen, charcoal, diatoms, and geochemical analyses. Conceivably, the AnalysisUnitID could be used for this purpose; however, IGSN’s could be assigned by projects before their data are submitted to the database. Moreover, AnalysisUnitID’s are intended to be internal to the database. Although IGSN’s could be assigned to Neotoma Collection Units and Samples, their primary value lies in their assignment to Analysis Units. IGSN’s are not yet assigned to Neotoma Analysis Units; however, that may change after consultation with SESAR.

notes text 2147483647 null

Free form notes or comments about the Analysis Unit.

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
analysisunits_pkey Primary key Asc analysisunitid
analysisunits_collunit_idx Performance Asc collectionunitid
analysisunits_facies_idx Performance Asc faciesid

Relationships