Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
prog |
text |
2147483647 |
√ |
|
null |
|
|
ptt |
text |
2147483647 |
√ |
|
null |
|
|
len |
text |
2147483647 |
√ |
|
null |
|
|
satellite |
text |
2147483647 |
√ |
|
null |
|
|
class |
text |
2147483647 |
√ |
|
null |
|
|
pass |
int4 |
10 |
√ |
|
null |
|
|
passdate |
timestamptz |
35,6 |
√ |
|
null |
|
|
passtime |
timestamptz |
35,6 |
√ |
|
null |
|
|
latitude |
float8 |
17,17 |
√ |
|
null |
|
|
longitude |
float8 |
17,17 |
√ |
|
null |
|
|
comment |
text |
2147483647 |
√ |
|
null |
|
|
frequency |
int4 |
10 |
√ |
|
null |
|
|
power |
int4 |
10 |
√ |
|
null |
|
|
iq |
int4 |
10 |
√ |
|
null |
|
|
dups |
int4 |
10 |
√ |
|
null |
|
|
msgdate |
timestamptz |
35,6 |
√ |
|
null |
|
|
msgtime |
timestamptz |
35,6 |
√ |
|
null |
|
|
latitude2 |
float8 |
17,17 |
√ |
|
null |
|
|
longitude2 |
float8 |
17,17 |
√ |
|
null |
|
|
duration |
int4 |
10 |
√ |
|
null |
|
|
error_radius |
int4 |
10 |
√ |
|
null |
|
|
error_semi.major.axis |
int4 |
10 |
√ |
|
null |
|
|
error_semi.minor.axis |
int4 |
10 |
√ |
|
null |
|
|
error_ellipse.orientation |
int4 |
10 |
√ |
|
null |
|
|
offset |
bool |
1 |
√ |
|
null |
|
|
offset_orientation |
bool |
1 |
√ |
|
null |
|
|
sensor_.01 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.02 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.03 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.04 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.05 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.06 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.07 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.08 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.09 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.10 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.11 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.12 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.13 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.14 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.15 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.16 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.17 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.18 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.19 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.20 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.21 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.22 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.23 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.24 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.25 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.26 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.27 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.28 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.29 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.30 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.31 |
int4 |
10 |
√ |
|
null |
|
|
sensor_.32 |
bool |
1 |
√ |
|
null |
|
|
wc_id |
text |
2147483647 |
√ |
|
null |
|
|
Table contained 72,150 rows at Wed Dec 27 13:28 PST 2017
|