Database Table Overview#
This page provides an overview of all tables in the database, including row counts, sizes, and documentation status.
| Table | Description | Columns | Size |
|---|---|---|---|
accumulationrates |
No description | 6 | 120 kB |
agetypes |
Lookup table of Age Types or units. This table is referenced by the Chronolog... | 6 | 24 kB |
aggregatechronologies |
This table stores metadata for Aggregate Chronologies. An Aggregate Chronolog... | 10 | 64 kB |
aggregatedatasets |
Aggregate Datasets are aggregates of samples of a particular data type. Some ... | 6 | 32 kB |
aggregateordertypes |
Lookup table for Aggregate Order Types. Table is referenced by the AggregateD... | 5 | 32 kB |
aggregatesampleages |
This table stores the links to the ages of samples in an Aggregate Dataset. T... | 5 | 56 kB |
aggregatesamples |
This table stores the samples in Aggregate Datasets. | 4 | 416 kB |
analysisunitaltdepths |
No description | 5 | 632 kB |
analysisunitaltdepthscales |
No description | 7 | 32 kB |
analysisunitlithostrat |
No description | 4 | 8192 bytes |
analysisunits |
This table stores the data for Analysis Units. | 11 | 69 MB |
calibrationcurves |
No description | 5 | 24 kB |
calibrationprograms |
No description | 5 | 24 kB |
chroncontrolaccuracydirections |
No description | 4 | 24 kB |
chroncontrolaccuracydistributions |
No description | 4 | 24 kB |
chroncontrolaccuracyranks |
No description | 4 | 24 kB |
chroncontrolprecisionranks |
No description | 4 | 24 kB |
chroncontrolranks |
No description | 9 | 8192 bytes |
chroncontrols |
This table stores data for Chronology Controls, which are the age-depth contr... | 13 | 75 MB |
chroncontrolscal14c |
No description | 5 | 632 kB |
chroncontroltypes |
Lookup table of Chronology Control Types. This table is referenced by the Chr... | 5 | 32 kB |
chronologies |
This table stores Chronology data. A Chronology refers to an explicit chronol... | 13 | 9560 kB |
collectiontypes |
This table is a lookup table for types of Collection Units, or Collection Typ... | 4 | 24 kB |
collectionunits |
This table stores data for Collection Units. | 20 | 23 MB |
collectors |
The Collectors table lists the people who collected Collection Units. | 6 | 4376 kB |
constituentdatabases |
No description | 7 | 32 kB |
contactreferences |
No description | 3 | 48 kB |
contacts |
This table lists persons and organizations referenced by the Chronologies, Co... | 17 | 3944 kB |
contactstatuses |
Lookup table of Contact Statuses. Table is referenced by the Contacts table. | 5 | 24 kB |
contextsdatasettypes |
No description | 4 | 32 kB |
data |
The primary data table in the database. Each occurrence of a Variable in a sa... | 6 | 1159 MB |
dataprocessors |
No description | 4 | 5176 kB |
datasetdatabases |
No description | 4 | 19 MB |
datasetdoi |
No description | 5 | 10 MB |
datasetpis |
No description | 5 | 39 MB |
datasetpublications |
This table lists the publications for datasets. | 5 | 23 MB |
datasets |
This table stores the data for Datasets. A Dataset is the set of samples for ... | 8 | 25 MB |
datasetsubmissions |
Submissions to the database are of Datasets. Submissions may be original subm... | 9 | 23 MB |
datasetsubmissiontypes |
Lookup table of Dataset Submission Types. Table is referenced by the DatasetS... | 4 | 24 kB |
datasettaxagrouptypes |
No description | 4 | 32 kB |
datasettaxonnotes |
No description | 7 | 360 kB |
datasettypes |
Lookup table for Dataset Types. Table is referenced by the Datasets table. | 4 | 24 kB |
datasetvariables |
No description | 5 | 8192 bytes |
datataxonnotes |
No description | 7 | 16 kB |
datauncertainties |
No description | 5 | 8016 kB |
decayconstants |
No description | 4 | 32 kB |
depagents |
Deposition Agents for Analysis Units. Individual Analysis Units may be listed... | 4 | 1736 kB |
depagenttypes |
Lookup table of Depositional Agents. Table is referenced by the DepAgents table. | 4 | 56 kB |
depenvttypes |
Lookup table of Depositional Environment Types. Table is referenced by the Co... | 5 | 64 kB |
depthreferencesystem |
No description | 4 | 64 kB |
ecolgroups |
Taxa are assigned to Sets of Ecological Groups. A taxon may be assigned to mo... | 5 | 20 MB |
ecolgrouptypes |
Lookup table of Ecological Group Types. Table is referenced by the EcolGroups... | 4 | 32 kB |
ecolsettypes |
Lookup table of Ecological Set Types. Table is referenced by the EcolGroups t... | 4 | 24 kB |
elementdatasettaxagroups |
No description | 5 | 184 kB |
elementmaturities |
No description | 4 | 40 kB |
elementportions |
No description | 4 | 56 kB |
elementsymmetries |
No description | 4 | 40 kB |
elementtaxagroupmaturities |
No description | 4 | 24 kB |
elementtaxagroupportions |
No description | 4 | 56 kB |
elementtaxagroups |
No description | 5 | 344 kB |
elementtaxagroupsymmetries |
No description | 4 | 56 kB |
elementtypes |
No description | 4 | 408 kB |
embargo |
No description | 3 | 8192 bytes |
entitycovers |
No description | 4 | 40 kB |
entitycovertypes |
No description | 3 | 32 kB |
entitydripheight |
No description | 4 | 40 kB |
entitygeology |
No description | 3 | 48 kB |
entitylandusecover |
No description | 4 | 48 kB |
entityrelationship |
No description | 3 | 0 bytes |
entitysamples |
No description | 8 | 56 kB |
entityvegetationcover |
No description | 4 | 48 kB |
eventchronology |
No description | 7 | 192 kB |
eventpublications |
No description | 4 | 88 kB |
events |
No description | 12 | 80 kB |
eventtypes |
No description | 5 | 24 kB |
externalcontacts |
No description | 3 | 488 kB |
externaldatabases |
No description | 6 | 24 kB |
externalgeochronology |
No description | 3 | 1304 kB |
externalpublications |
No description | 5 | 128 kB |
externalspeleothemdata |
No description | 4 | 56 kB |
externaltaxa |
No description | 6 | 18 MB |
faciestypes |
Lookup table of Facies Types. Table is referenced by the AnalysisUnits table. | 4 | 24 kB |
formtaxa |
No description | 7 | 24 kB |
fractiondated |
No description | 4 | 24 kB |
geochroncontrols |
No description | 4 | 23 MB |
geochronology |
This table stores geochronologic data. Geochronologic measurements are from g... | 14 | 21 MB |
geochronpublications |
Publications in which Geochronologic measurements are reported. Many older ra... | 4 | 15 MB |
geochrontypes |
Lookup table for Geochronology Types. Table is referenced by the Geochronolog... | 4 | 24 kB |
geopaths |
No description | 2 | 1256 kB |
geopoliticalunits |
Lookup table of GeoPoliticalUnits. Table is referenced by the SiteGeoPolitica... | 7 | 4328 kB |
hiatuschronology |
No description | 4 | 64 kB |
hiatuses |
No description | 4 | 48 kB |
isobiomarkerbandtypes |
No description | 5 | 24 kB |
isobiomarkertypes |
No description | 4 | 24 kB |
isoinstrumentation |
No description | 10 | 40 kB |
isoinstrumentationtypes |
No description | 4 | 24 kB |
isomatanalsubstrate |
No description | 4 | 24 kB |
isomaterialanalyzedtypes |
No description | 4 | 24 kB |
isometadata |
No description | 13 | 536 kB |
isopretreatmenttypes |
No description | 5 | 24 kB |
isosampleintrosystemtypes |
No description | 4 | 24 kB |
isosampleorigintypes |
No description | 4 | 24 kB |
isosamplepretreatments |
No description | 6 | 120 kB |
isoscaletypes |
No description | 5 | 24 kB |
isospecimendata |
No description | 6 | 448 kB |
isosrmetadata |
No description | 6 | 32 kB |
isostandards |
No description | 6 | 8192 bytes |
isostandardtypes |
No description | 5 | 24 kB |
isostratdata |
No description | 6 | 72 kB |
isosubstratetypes |
No description | 4 | 24 kB |
isovariablescaletypes |
No description | 4 | 24 kB |
keywords |
Lookup table of Keywords referenced by the SampleKeywords table. The table pr... | 4 | 24 kB |
lakeparameters |
No description | 5 | 5776 kB |
lakeparametertypes |
A set of variables associated with lakes, including area, depth and volume. | 6 | 24 kB |
landusetypes |
No description | 4 | 80 kB |
leadmodelbasis |
No description | 2 | 32 kB |
leadmodels |
No description | 3 | 72 kB |
lithology |
This table stores the lithologic descriptions of Collection Units. | 8 | 7048 kB |
lithostrat |
No description | 6 | 24 kB |
lithostratunits |
No description | 5 | 24 kB |
publicationauthors |
This table lists authors as their names are given in publications. Only the i... | 9 | 13 MB |
publicationeditors |
This table stores the editors of publications for which chapters or sections ... | 8 | 456 kB |
publications |
This table stores publication or bibliographic data. The table is designed wi... | 28 | 26 MB |
publicationtranslators |
No description | 8 | 24 kB |
publicationtypes |
Lookup table of Publication Types. This table is referenced by the Publicatio... | 4 | 24 kB |
radiocarbon |
No description | 12 | 3944 kB |
radiocarboncalibration |
Radiocarbon calibration table. This table is intended for quick calibration o... | 2 | 2608 kB |
radiocarbonmethods |
No description | 4 | 24 kB |
relativeagepublications |
This table stores Publications in which Relative Ages are reported for Collec... | 4 | 64 kB |
relativeages |
Lookup table of RelativeAges. Table is referenced by the RelativeChronology t... | 11 | 216 kB |
relativeagescales |
Lookup table of Relative Age Scales. Table is referenced by the RelativeAges ... | 4 | 24 kB |
relativeageunits |
Lookup table of RelativeAgeUnits. Table is referenced by the RelativeAges table. | 4 | 24 kB |
relativechronology |
This table stores relative chronologic data. Relative Ages are assigned to An... | 7 | 1704 kB |
repositoryinstitutions |
A lookup table of institutions that are repositories for fossil specimens. Ta... | 6 | 80 kB |
repositoryspecimens |
This table lists the repositories in which fossil specimens have been accessi... | 5 | 2144 kB |
rocktypes |
No description | 6 | 72 kB |
sampleages |
This table stores sample ages. Ages are assigned to a Chronology. Because the... | 8 | 383 MB |
sampleanalysts |
This table lists the Sample Analysts. | 6 | 114 MB |
samplekeywords |
This table lists the Sample Analysts. | 4 | 6584 kB |
samples |
This table stores sample data. Samples belong to Analysis Units, which belong... | 12 | 252 MB |
sitegeopolitical |
This table lists the GeoPolitical units in which sites occur. | 6 | 20 MB |
siteimages |
This table stores hyperlinks to jpeg images of sites. | 9 | 48 kB |
sitelandusecover |
No description | 4 | 8192 bytes |
sites |
The Sites table stores information about sites or localities, including name,... | 13 | 1361 MB |
sitestemp |
No description | 13 | 5112 kB |
sitevegetationcover |
No description | 4 | 8192 bytes |
specimendates |
This table enables queries for dated specimens of individual taxa. Although t... | 10 | 1008 kB |
specimendatescal |
No description | 10 | 320 kB |
specimendomesticstatustypes |
No description | 4 | 24 kB |
specimengenbank |
No description | 2 | 24 kB |
specimens |
No description | 17 | 464 kB |
specimensextypes |
No description | 4 | 24 kB |
specimentaphonomy |
No description | 4 | 56 kB |
speleothemcollectionunits |
No description | 3 | 72 kB |
speleothemdriptypes |
No description | 4 | 32 kB |
speleothementitystatuses |
No description | 2 | 64 kB |
speleothems |
No description | 8 | 72 kB |
speleothemtypes |
No description | 4 | 32 kB |
summarydatataphonomy |
No description | 4 | 3200 kB |
synonyms |
This table lists common synonyms for taxa in the Taxa table. No effort has be... | 6 | 872 kB |
synonymtypes |
Lookup table of Synonym Types. Table is referenced by the Synonyms table. | 4 | 24 kB |
synonymy |
The synonymy table links dataset-level synonymies to particular publications ... | 11 | 4320 kB |
sysdiagrams |
No description | 5 | 16 kB |
taphonomicsystems |
No description | 5 | 32 kB |
taphonomicsystemsdatasettypes |
No description | 4 | 24 kB |
taphonomictypes |
No description | 6 | 32 kB |
taxa |
This table lists all taxa in the database. Most taxa are biological taxa; how... | 14 | 43 MB |
taxaalthierarchy |
No description | 3 | 8192 bytes |
taxaalthierarchytypes |
No description | 3 | 32 kB |
taxagrouptypes |
Lookup table for Taxa Group Types. This table is referenced by the Taxa table. | 4 | 24 kB |
taxonpaths |
No description | 2 | 16 kB |
tephras |
Tephras lookup table. This table stores recognized tephras with established a... | 6 | 72 kB |
uncertaintybases |
No description | 2 | 48 kB |
unitsdatasettypes |
Join table, associating measurement units with various datasettypes. | 4 | 72 kB |
uraniumseries |
No description | 10 | 112 kB |
uraniumseriesdata |
No description | 2 | 80 kB |
variablecontexts |
Variable Contexts lookup table. Table is referenced by the Variables table. | 4 | 56 kB |
variableelements |
Lookup table of Variable Elements. Table is referenced by the Variables table. | 8 | 112 kB |
variables |
This table lists Variables, which always consist of a Taxon and Units of meas... | 7 | 18 MB |
variableunits |
Lookup table of Variable Units. Table is referenced by the Variables table. | 4 | 32 kB |
vegetationcovertypes |
No description | 4 | 80 kB |
Documentation Coverage#
Contributing to Documentation
Tables marked with ⚠️ need documentation. Use the template to create new table documentation.
Statistics#
- Total Tables: [Calculated dynamically]
- Total Rows: [Calculated dynamically]
- Total Size: [Calculated dynamically]
- Documentation Complete: [Percentage]
Data Quality#
See the Data Quality Report for current test results.
Danger
Pass Rate: 37.5% (6/16 tests passing)
- ❌ Passed: 6
- ❌ Failed: 10
View Full Report | Last updated: 1764636412.5957298
Generated: 2026-01-06