Tables


SchemaSpy Analysis of neotomadev.ndb

Generated on Wed Nov 28 14:49 PST 2018

XML Representation
Insertion Order Deletion Order
TABLES 148
VIEWS 3
COLUMNS 929
Constraints 202

Database Properties

Database Type: PostgreSQL - 9.6.11

Tables

Table / View Children Parents Columns Rows Type Comments
accumulationrates 0 3 6 1089 Table
agetypes 5 0 6 5 Table
aggregatechronologies 1 2 10 4 Table
aggregatedatasets 3 1 6 6 Table
aggregateordertypes 1 0 5 7 Table
aggregatesampleages 0 3 5 162 Table
aggregatesamples 0 2 4 234 Table
analysisunitaltdepths 0 2 5 6302 Table
analysisunitaltdepthscales 1 1 7 32 Table
analysisunitlithostrat 0 2 4 0 Table
analysisunits 9 2 11 235852 Table
calibrationcurves 2 1 5 11 Table
calibrationprograms 2 0 5 71 Table
chroncontrolaccuracydirections 1 0 4 3 Table
chroncontrolaccuracydistributions 1 0 4 4 Table
chroncontrolaccuracyranks 1 0 4 8 Table
chroncontrolprecisionranks 1 0 4 8 Table
chroncontrolranks 0 5 9 0 Table
chroncontrols 3 4 13 63324 Table
chroncontrolscal14c 0 3 5 3686 Table
chroncontroltypes 2 0 5 94 Table
chronologies 3 3 13 18116 Table
collectiontypes 2 0 4 10 Table
collectionunits 6 7 20 20568 Table
collectors 0 2 6 18650 Table
constituentdatabases 2 1 6 28 Table
contacts 13 1 17 8631 Table
contactstatuses 1 0 5 7 Table
contextsdatasettypes 0 2 4 79 Table
data 7 2 6 5382825 Table
dataprocessors 0 2 4 40434 Table
datasetdatabases 0 2 4 32098 Table
datasetdoi 0 1 4 6331 Table
datasetpis 0 2 5 38951 Table
datasetpublications 0 2 5 27909 Table
datasets 17 3 8 32688 Table
datasetsubmissions 0 4 9 40819 Table
datasetsubmissiontypes 1 0 4 9 Table
datasettaxagrouptypes 0 2 4 137 Table
datasettaxonnotes 0 3 7 788 Table
datasettypes 5 0 4 34 Table
datasetvariables 0 2 5 0 Table
datataxonnotes 0 2 7 0 Table
depagents 0 2 4 5272 Table
depagenttypes 1 0 4 19 Table
depenvttypes 2 0 5 211 Table
dsageranges 0 2 4 0 View
dsdatasample 0 3 4 0 View
dslinks 0 2 3 0 View

A view intended to link dataset ID, site ID and collection unit ID simply.

ecolgroups 0 3 5 29853 Table
ecolgrouptypes 1 0 4 177 Table
ecolsettypes 1 0 4 21 Table
elementdatasettaxagroups 0 0 5 787 Table
elementmaturities 3 0 4 11 Table
elementportions 3 0 4 52 Table
elementsymmetries 3 0 4 8 Table
elementtaxagroupmaturities 0 2 4 38 Table
elementtaxagroupportions 0 2 4 408 Table
elementtaxagroups 3 2 5 671 Table
elementtaxagroupsymmetries 0 2 4 446 Table
elementtypes 5 0 4 614 Table
embargo 1 0 3 0 Table
eventchronology 0 2 7 106 Table
eventpublications 0 2 4 100 Table
events 3 1 12 107 Table
eventtypes 1 1 5 9 Table
externaldatabases 2 0 6 6 Table
externalpublications 0 2 5 1318 Table
externaltaxa 0 2 6 3334 Table
faciestypes 1 0 4 102 Table
formtaxa 0 3 7 3 Table
fractiondated 1 0 4 28 Table
geochroncontrols 0 2 4 23472 Table
geochronology 2 3 14 24125 Table
geochronpublications 0 2 4 16772 Table
geochrontypes 1 0 4 17 Table
geopoliticalunits 1 0 7 9947 Table
isobiomarkerbandtypes 0 1 5 9 Table
isobiomarkertypes 1 0 4 4 Table
isoinstrumentation 0 4 10 4 Table
isoinstrumentationtypes 1 0 4 4 Table
isomatanalsubstrate 0 2 4 19 Table
isomaterialanalyzedtypes 2 0 4 12 Table
isometadata 0 4 12 148 Table
isopretratmenttypes 1 0 5 28 Table
isosampleintrosystemtypes 1 0 4 4 Table
isosampleorigintypes 0 0 4 6 Table
isosamplepretreatments 0 2 6 150 Table
isoscaletypes 1 0 5 8 Table
isospecimendata 0 2 5 222 Table
isosrmetadata 0 2 6 0 Table
isostandards 0 3 6 0 Table
isostandardtypes 1 0 5 20 Table
isostratdata 0 3 6 92 Table
isosubstratetypes 2 0 4 11 Table
isovariablescaletypes 0 2 4 14 Table
keywords 1 0 4 3 Table
lakeparameters 0 2 5 2747 Table
lakeparametertypes 1 0 6 21 Table
lithology 0 1 8 14148 Table
lithostrat 1 1 6 16 Table
lithostratunits 1 0 5 5 Table
publicationauthors 0 2 9 18445 Table
publicationeditors 0 1 8 793 Table
publications 12 1 26 9097 Table
publicationtranslators 0 1 8 4 Table
publicationtypes 1 0 4 13 Table
radiocarbon 0 1 12 20647 Table
radiocarboncalibration 0 0 2 45101 Table
radiocarbonmethods 1 0 4 5 Table
relativeagepublications 0 2 4 90 Table
relativeages 2 2 11 607 Table
relativeagescales 1 0 4 8 Table
relativeageunits 1 0 4 12 Table
relativechronology 0 2 7 4486 Table
repositoryinstitutions 2 0 6 355 Table
repositoryspecimens 0 2 5 3666 Table
rocktypes 2 0 6 206 Table
sampleages 1 2 8 306795 Table
sampleanalysts 0 2 6 177091 Table
samplekeywords 0 2 4 4491 Table
samples 8 3 12 266327 Table
sitegeopolitical 0 2 5 39611 Table
siteimages 0 2 9 9 Table
sites 4 0 13 16073 Table
sitestemp 0 0 13 16073 Table
specimendates 1 5 10 2192 Table
specimendatescal 0 3 10 2162 Table
specimendomesticstatustypes 1 0 4 4 Table
specimengenbank 0 1 2 3 Table
specimens 4 8 17 728 Table
specimensextypes 1 0 4 3 Table
specimentaphonomy 0 2 4 159 Table
summarydatataphonomy 0 2 4 39242 Table
synonyms 0 3 6 2079 Table
synonymtypes 1 0 4 18 Table
synonymy 0 5 11 15582 Table
sysdiagrams 0 0 5 0 Table
taphonomicsystems 2 0 5 9 Table
taphonomicsystemsdatasettypes 0 2 4 11 Table
taphonomictypes 2 1 6 76 Table
taxa 15 2 14 31515 Table
taxaalthierarchy 0 3 3 0 Table
taxaalthierarchytypes 1 0 3 1 Table
taxagrouptypes 3 0 4 53 Table
tephras 0 2 6 97 Table
unitsdatasettypes 0 2 4 245 Table
variablecontexts 2 0 4 39 Table
variableelements 1 4 8 673 Table
variables 7 4 7 33975 Table
variableunits 4 0 4 122 Table