Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
analysisunitid | serial | 10 | √ | nextval('ndb.seq_analysisunits_analysisunitid'::regclass) |
|
|
An arbitrary Analysis Unit identification number. |
|||||||||||||||||||||
collectionunitid | int4 | 10 | null |
|
|
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 |
|
|
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 |