| valueid |
bigserial |
19 |
|
√ |
nextval('odm2.trajectoryresultvalues_valueid_seq'::regclass) |
|
|
| resultid |
int8 |
19 |
|
|
|
|
|
| datavalue |
float8 |
17,17 |
|
|
|
|
|
| valuedatetime |
timestamp |
29,6 |
|
|
|
|
|
| valuedatetimeutcoffset |
int4 |
10 |
|
|
|
|
|
| xlocation |
float8 |
17,17 |
|
|
|
|
|
| xlocationunitsid |
int4 |
10 |
|
|
|
|
| units.unitsid
|
fk_trajectoryresultvalues_xunits C |
|
| ylocation |
float8 |
17,17 |
|
|
|
|
|
| ylocationunitsid |
int4 |
10 |
|
|
|
|
| units.unitsid
|
fk_trajectoryresultvalues_yunits C |
|
| zlocation |
float8 |
17,17 |
|
|
|
|
|
| zlocationunitsid |
int4 |
10 |
|
|
|
|
| units.unitsid
|
fk_trajectoryresultvalues_zunits C |
|
| trajectorydistance |
float8 |
17,17 |
|
|
|
|
|
| trajectorydistanceaggregationinterval |
float8 |
17,17 |
|
|
|
|
|
| trajectorydistanceunitsid |
int4 |
10 |
|
|
|
|
| units.unitsid
|
fk_trajectoryresultvalues_distanceunits C |
|
| censorcodecv |
varchar |
255 |
|
|
|
|
|
| qualitycodecv |
varchar |
255 |
|
|
|
|
|
| timeaggregationinterval |
float8 |
17,17 |
|
|
|
|
|
| timeaggregationintervalunitsid |
int4 |
10 |
|
|
|
|
| units.unitsid
|
fk_trajectoryresultvalues_aiunits C |
|
