SchemaSpy Analysis of mob_odm2.odm2 Generated by
SchemaSpy
Generated by SchemaSpy on Fri Mar 08 15:58 PST 2019
Database Type: PostgreSQL - 9.2.24 SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table Children Parents Columns Rows Comments
actionannotations 2 3 0
actionby 2 5 0
actiondirectives 2 3 0
actionextensionpropertyvalues 2 4 0
actions 11 2 9 0
affiliations 3 2 10 0
annotations 16 3 9 0
authorlists 2 4 0
calibrationactions 2 2 4 0
calibrationreferenceequipment 2 3 0
calibrationstandards 2 3 0
categoricalresults 1 3 9 0
categoricalresultvalueannotations 2 3 0
categoricalresultvalues 1 1 5 0
citationextensionpropertyvalues 2 4 0
citationexternalidentifiers 2 5 0
citations 10 5 0
cv_actiontype 1 5 23
cv_aggregationstatistic 11 5 18
cv_annotationtype 1 5 25
cv_censorcode 8 5 6
cv_dataqualitytype 1 5 6
cv_datasettype 1 5 5
cv_directivetype 1 5 3
cv_elevationdatum 5 6
cv_equipmenttype 1 5 28
cv_medium 3 5 20
cv_methodtype 1 5 25
cv_organizationtype 1 5 32
cv_propertydatatype 1 5 5
cv_qualitycode 9 5 5
cv_relationshiptype 10 5 29
cv_resulttype 1 5 12
cv_samplingfeaturegeotype 5 8
cv_samplingfeaturetype 5 23
cv_sitetype 1 5 53
cv_spatialoffsettype 1 5 11
cv_speciation 1 5 145
cv_specimentype 1 5 27
cv_status 1 5 4
cv_taxonomicclassifiertype 1 5 14
cv_unitstype 1 5 180
cv_variablename 1 5 810
cv_variabletype 1 5 23
dataloggerfilecolumns 6 12 0
dataloggerfiles 1 1 5 0
dataloggerprogramfiles 1 1 6 0
dataquality 1 2 7 0
datasetcitations 3 4 0
datasets 4 1 6 0
datasetsresults 2 3 0
derivationequations 1 2 0
directives 1 1 3 0
equipment 5 4 12 0
equipmentannotations 2 3 0
equipmentmodels 2 1 8 0
equipmentused 2 3 0
extensionproperties 6 2 5 0
externalidentifiersystems 8 1 5 0
featureactions 2 1 3 0
instrumentoutputvariables 2 4 7 0
maintenanceactions 1 4 0
measurementresults 1 9 13 0
measurementresultvalueannotations 2 3 0
measurementresultvalues 1 1 5 0
methodannotations 2 3 0
methodcitations 3 4 0
methodextensionpropertyvalues 2 4 0
methodexternalidentifiers 2 5 0
methods 6 2 7 0
modelaffiliations 2 5 0
models 3 6 0
organizations 7 2 7 0
people 5 4 0
personexternalidentifiers 2 5 0
pointcoverageresults 1 6 11 0
pointcoverageresultvalueannotations 2 3 0
pointcoverageresultvalues 1 5 11 0
processinglevels 1 4 0
profileresults 1 7 11 0
profileresultvalueannotations 2 3 0
profileresultvalues 1 5 12 0
referencematerialexternalidentifiers 2 5 0
referencematerials 3 2 9 0
referencematerialvalues 1 4 7 0
relatedactions 3 4 0
relatedannotations 3 4 0
relatedcitations 3 4 0
relateddatasets 3 5 0
relatedequipment 3 8 0
relatedfeatures 2 5 0
relatedmodels 2 4 0
relatedresults 3 6 0
resultannotations 2 5 0
resultderivationequations 2 2 0
resultextensionpropertyvalues 2 4 0
resultnormalizationvalues 2 2 0
results 18 8 15 0
resultsdataquality 2 3 0
samplingfeatureannotations 1 3 0
samplingfeatureextensionpropertyvalues 1 4 0
samplingfeatureexternalidentifiers 1 5 0
sectionresults 1 7 11 0
sectionresultvalueannotations 2 3 0
sectionresultvalues 1 7 16 0
simulations 2 12 0
sites 2 5 0
spatialoffsets 1 4 8 0
spatialreferenceexternalidentifiers 2 5 0
spatialreferences 11 5 0
specimenbatchpostions 1 3 0
specimens 1 2 4 0
specimentaxonomicclassifiers 3 4 0
spectraresults 1 7 11 0
spectraresultvalueannotations 2 3 0
spectraresultvalues 1 5 12 0
taxonomicclassifierexternalidentifiers 2 5 0
taxonomicclassifiers 4 2 6 0
timeseriesresults 1 7 11 0
timeseriesresultvalueannotations 2 3 0
timeseriesresultvalues 1 4 9 0
trajectoryresults 1 5 7 0
trajectoryresultvalueannotations 2 3 0
trajectoryresultvalues 1 8 18 0
transectresults 1 6 9 0
transectresultvalueannotations 2 3 0
transectresultvalues 1 8 17 0
units 57 1 5 0
variableextensionpropertyvalues 2 4 0
variableexternalidentifiers 2 5 0
variables 5 3 7 0
           
131 Tables     765 1,546  
0 Views     0