| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| tageventid |
int4 |
10 |
√ |
|
null |
|
|
| toppid |
varchar |
20 |
√ |
|
null |
|
|
| pttnumber |
int4 |
10 |
√ |
|
null |
|
|
| speciescode |
varchar |
2 |
√ |
|
null |
|
|
| speciesname |
varchar |
80 |
√ |
|
null |
|
|
| startdate |
date |
13 |
√ |
|
null |
|
|
| enddate |
date |
13 |
√ |
|
null |
|
|
| actualpopupdate |
date |
13 |
√ |
|
null |
|
|
| tagid |
int4 |
10 |
√ |
|
null |
|
|
| tagnumber |
varchar |
80 |
√ |
|
null |
|
|
| modelname |
varchar |
40 |
√ |
|
null |
|
|
| eventcomment |
text |
2147483647 |
√ |
|
null |
|
|
| contactcode |
varchar |
20 |
√ |
|
null |
|
|
| projectname |
varchar |
80 |
√ |
|
null |
|
|
| agentcode |
varchar |
20 |
√ |
|
null |
|
|
| eventtypeid |
int4 |
10 |
√ |
|
null |
|
|
| datetime |
timestamptz |
35,6 |
√ |
|
null |
|
|
| deploymenttypeid |
int4 |
10 |
√ |
|
null |
|
|
| clockdrift |
float4 |
8,8 |
√ |
|
null |
|
|
| track |
text |
2147483647 |
√ |
|
null |
|
|
| provisional |
bool |
1 |
√ |
|
null |
|
|
| issattag |
unknown |
2147483647 |
√ |
|
null |
|
|
| datesent |
unknown |
2147483647 |
√ |
|
null |
|
|
| latitude |
float4 |
8,8 |
√ |
|
null |
|
|
| longitude |
float4 |
8,8 |
√ |
|
null |
|
|
Analyzed at Wed Dec 27 13:25 PST 2017
|