| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| valueid |
bigserial |
19 |
|
√ |
nextval('odm2.spectraresultvalues_valueid_seq'::regclass) |
|
|
| resultid |
int8 |
19 |
|
|
|
|
|
| datavalue |
float8 |
17,17 |
|
|
|
|
|
| valuedatetime |
timestamp |
29,6 |
|
|
|
|
|
| valuedatetimeutcoffset |
int4 |
10 |
|
|
|
|
|
| excitationwavelength |
float8 |
17,17 |
|
|
|
|
|
| emissionwavelength |
float8 |
17,17 |
|
|
|
|
|
| wavelengthunitsid |
int4 |
10 |
|
|
|
|
| units.unitsid
|
fk_spectraresultvalues_wunits C |
|
| censorcodecv |
varchar |
255 |
|
|
|
|
|
| qualitycodecv |
varchar |
255 |
|
|
|
|
|
| timeaggregationinterval |
float8 |
17,17 |
|
|
|
|
|
| timeaggregationintervalunitsid |
int4 |
10 |
|
|
|
|
| units.unitsid
|
fk_spectraresultvalues_aiunits C |
|
Table contained 0 rows at Fri Mar 08 15:58 PST 2019
|
