Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| sampleid | serial | 10 | √ | nextval('ndb.seq_samples_sampleid'::regclass) |
|
|
An arbitrary Sample identification number. |
|||||||||||||||||
| analysisunitid | int4 | 10 | null |
|
|
Analysis Unit identification number. Field links to the AnalysisUnits table. |
||||||||||||||||||
| datasetid | int4 | 10 | null |
|
|
Dataset identification number. Field links to the Datasets table. |
||||||||||||||||||
| samplename | varchar | 80 | √ | null |
|
|
Sample name if any. |
|||||||||||||||||
| analysisdate | date | 13 | √ | null |
|
|
Date of analysis. |
|||||||||||||||||
| labnumber | varchar | 40 | √ | null |
|
|
Laboratory number for the sample. A special case regards geochronologic samples, for which the LabNumber is the number, if any, assigned by the submitter, not the number assigned by the radiocarbon laboratory, which is in the Geochronology table. |
|||||||||||||||||
| preparationmethod | text | 2147483647 | √ | null |
|
|
Description, notes, or comments on preparation methods. For faunal samples, notes on screening methods or screen size are stored here. |
|||||||||||||||||
| notes | text | 2147483647 | √ | null |
|
|
Free form note or comments about the sample. |
|||||||||||||||||
| recdatecreated | timestamp | 22 | timezone('UTC'::text, now()) |
|
|
|||||||||||||||||||
| recdatemodified | timestamp | 22 | null |
|
|
|||||||||||||||||||
| sampledate | date | 13 | √ | null |
|
|
||||||||||||||||||
| taxonid | int4 | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| samples_pkey | Primary key | Asc | sampleid |
| ix_analysisunitid_samples | Performance | Asc | analysisunitid |
| ix_datasetid_samples | Performance | Asc | datasetid |
| sample_taxon_idx | Performance | Asc | taxonid |