Table mob_odm2.odm2.results Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
resultid bigserial 19  √  nextval('odm2.results_resultid_seq'::regclass)
categoricalresults.resultid fk_categoricalresults_results C
dataloggerfilecolumns.resultid fk_dataloggerfilecolumns_results C
datasetsresults.resultid fk_datasetsresults_results C
measurementresults.resultid fk_measurementresults_results C
pointcoverageresults.resultid fk_pointcoverageresults_results C
profileresults.resultid fk_profileresults_results C
relatedresults.relatedresultid fk_relatedresults_results_arerelated C
relatedresults.resultid fk_relatedresults_results C
resultannotations.resultid fk_resultannotations_results C
resultderivationequations.resultid fk_resultderivationequations_results C
resultextensionpropertyvalues.resultid fk_resultextensionpropertyvalues_results C
resultnormalizationvalues.resultid fk_resultnormalizationvalues_results C
resultsdataquality.resultid fk_resultsdataquality_results C
sectionresults.resultid fk_sectionresults_results C
spectraresults.resultid fk_spectraresults_results C
timeseriesresults.resultid fk_timeseriesresults_results C
trajectoryresults.resultid fk_trajectoryresults_results C
transectresults.resultid fk_transectresults_results C
resultuuid uuid 2147483647
featureactionid int4 10
featureactions.featureactionid fk_results_featureactions C
resulttypecv varchar 255
cv_resulttype.name fk_results_cv_resulttype C
variableid int4 10
variables.variableid fk_results_variables C
unitsid int4 10
units.unitsid fk_results_units C
taxonomicclassifierid int4 10  √  null
taxonomicclassifiers.taxonomicclassifierid fk_results_taxonomicclassifiers C
processinglevelid int4 10
processinglevels.processinglevelid fk_results_processinglevels C
resultdatetime timestamp 29,6  √  null
resultdatetimeutcoffset int8 19  √  null
validdatetime timestamp 29,6  √  null
validdatetimeutcoffset int8 19  √  null
statuscv varchar 255  √  null
cv_status.name fk_results_cv_status C
sampledmediumcv varchar 255
cv_medium.name fk_results_cv_medium C
valuecount int4 10

Table contained 0 rows at Fri Mar 08 15:58 PST 2019

Indexes:
Column(s) Type Sort Constraint Name
resultid Primary key Asc results_pkey

Close relationships  within of separation: