Table mob_odm2.odm2.units 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
unitsid serial 10  √  nextval('odm2.units_unitsid_seq'::regclass)
dataloggerfilecolumns.recordingintervalunitsid fk_dataloggerfilecolumns_recordingunits C
dataloggerfilecolumns.scanintervalunitsid fk_dataloggerfilecolumns_scanunits C
dataquality.dataqualityvalueunitsid fk_dataquality_units C
extensionproperties.propertyunitsid fk_extensionproperties_units C
instrumentoutputvariables.instrumentrawoutputunitsid fk_instrumentoutputvariables_units C
measurementresults.timeaggregationintervalunitsid fk_measurementresults_aiunits C
measurementresults.xlocationunitsid fk_measurementresults_xunits C
measurementresults.ylocationunitsid fk_measurementresults_yunits C
measurementresults.zlocationunitsid fk_measurementresults_zunits C
pointcoverageresults.intendedxspacingunitsid fk_pointcoverageresults_xunits C
pointcoverageresults.intendedyspacingunitsid fk_pointcoverageresults_yunits C
pointcoverageresults.zlocationunitsid fk_pointcoverageresults_zunits C
pointcoverageresultvalues.xlocationunitsid fk_pointcoverageresultvalues_xunits C
pointcoverageresultvalues.ylocationunitsid fk_pointcoverageresultvalues_yunits C
profileresults.intendedtimespacingunitsid fk_profileresults_tunits C
profileresults.intendedzspacingunitsid fk_profileresults_dunits C
profileresults.xlocationunitsid fk_profileresults_xunits C
profileresults.ylocationunitsid fk_profileresults_yunits C
profileresultvalues.timeaggregationintervalunitsid fk_profileresultvalues_aiunits C
profileresultvalues.zlocationunitsid fk_profileresultvalues_dunits C
referencematerialvalues.unitsid fk_referencematerialvalues_units C
results.unitsid fk_results_units C
sectionresults.intendedtimespacingunitsid fk_sectionresults_tmunits C
sectionresults.intendedxspacingunitsid fk_sectionresults_xunits C
sectionresults.intendedzspacingunitsid fk_sectionresults_zunits C
sectionresults.ylocationunitsid fk_sectionresults_units C
sectionresultvalues.timeaggregationintervalunitsid fk_sectionresultvalues_aiunits C
sectionresultvalues.xlocationunitsid fk_sectionresultvalues_xunits C
sectionresultvalues.zlocationunitsid fk_sectionresultvalues_zunits C
spatialoffsets.offset1unitid fk_spatialoffsets_offset1units C
spatialoffsets.offset2unitid fk_spatialoffsets_offset2units C
spatialoffsets.offset3unitid fk_spatialoffsets_offset3units C
spectraresults.intendedwavelengthspacingunitsid fk_spectraresults_units C
spectraresults.xlocationunitsid fk_spectraresults_xunits C
spectraresults.ylocationunitsid fk_spectraresults_yunits C
spectraresults.zlocationunitsid fk_spectraresults_zunits C
spectraresultvalues.timeaggregationintervalunitsid fk_spectraresultvalues_aiunits C
spectraresultvalues.wavelengthunitsid fk_spectraresultvalues_wunits C
timeseriesresults.intendedtimespacingunitsid fk_timeseriesresults_tunits C
timeseriesresults.xlocationunitsid fk_timeseriesresults_xunits C
timeseriesresults.ylocationunitsid fk_timeseriesresults_yunits C
timeseriesresults.zlocationunitsid fk_timeseriesresults_zunits C
timeseriesresultvalues.timeaggregationintervalunitsid fk_timeseriesresultvalues_aiunits C
trajectoryresults.intendedtimespacingunitsid fk_trajectoryresults_tunits C
trajectoryresults.intendedtrajectoryspacingunitsid fk_trajectoryresults_tsunits C
trajectoryresultvalues.timeaggregationintervalunitsid fk_trajectoryresultvalues_aiunits C
trajectoryresultvalues.trajectorydistanceunitsid fk_trajectoryresultvalues_distanceunits C
trajectoryresultvalues.xlocationunitsid fk_trajectoryresultvalues_xunits C
trajectoryresultvalues.ylocationunitsid fk_trajectoryresultvalues_yunits C
trajectoryresultvalues.zlocationunitsid fk_trajectoryresultvalues_zunits C
transectresults.intendedtimespacingunitsid fk_transectresults_tmunits C
transectresults.intendedtransectspacingunitsid fk_transectresults_tsunits C
transectresults.zlocationunitsid fk_transectresults_units C
transectresultvalues.timeaggregationintervalunitsid fk_transectresultvalues_aiunits C
transectresultvalues.transectdistanceunitsid fk_transectresultvalues_distanceunits C
transectresultvalues.xlocationunitsid fk_transectresultvalues_xunits C
transectresultvalues.ylocationunitsid fk_transectresultvalues_yunits C
unitstypecv varchar 255
cv_unitstype.name fk_units_cv_unitstype C
unitsabbreviation varchar 50
unitsname varchar 255
unitslink varchar 255  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
unitsid Primary key Asc units_pkey

Close relationships  within of separation: