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