Table mob_odm2.odm2.transectresultvalues 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
valueid bigserial 19  √  nextval('odm2.transectresultvalues_valueid_seq'::regclass)
transectresultvalueannotations.valueid fk_transectresultvalueannotations_transectresultvalues C
resultid int8 19
transectresults.resultid fk_transectresultvalues_transectresults C
datavalue float8 17,17
valuedatetime timestamp 29,6
valuedatetimeutcoffset int4 10
xlocation float8 17,17
xlocationunitsid int4 10
units.unitsid fk_transectresultvalues_xunits C
ylocation float8 17,17
ylocationunitsid int4 10
units.unitsid fk_transectresultvalues_yunits C
transectdistance float8 17,17
transectdistanceaggregationinterval float8 17,17
transectdistanceunitsid int4 10
units.unitsid fk_transectresultvalues_distanceunits C
censorcodecv varchar 255
cv_censorcode.name fk_transectresultvalues_cv_censorcode C
qualitycodecv varchar 255
cv_qualitycode.name fk_transectresultvalues_cv_qualitycode C
aggregationstatisticcv varchar 255
cv_aggregationstatistic.name fk_transectresultvalues_cv_aggregationstatistic C
timeaggregationinterval float8 17,17
timeaggregationintervalunitsid int4 10
units.unitsid fk_transectresultvalues_aiunits C

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

Indexes:
Column(s) Type Sort Constraint Name
valueid Primary key Asc transectresultvalues_pkey
resultid + datavalue + valuedatetime + valuedatetimeutcoffset + xlocation + xlocationunitsid + ylocation + ylocationunitsid + transectdistance + transectdistanceaggregationinterval + transectdistanceunitsid + censorcodecv + qualitycodecv + aggregationstatisticcv + timeaggregationinterval + timeaggregationintervalunitsid Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc transectresultvalues_resultid_datavalue_valuedatetime_value_key

Close relationships  within of separation: