| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| eventid |
int4 |
10 |
√ |
|
null |
|
|
| tagcode |
text |
2147483647 |
√ |
|
null |
|
|
| tagnumber |
text |
2147483647 |
√ |
|
null |
|
|
| tagdate |
date |
13 |
√ |
|
null |
|
|
| end_date |
timestamp |
29,6 |
√ |
|
null |
|
|
| tagmodel |
text |
2147483647 |
√ |
|
null |
|
|
| commonname |
text |
2147483647 |
√ |
|
null |
|
|
| genus |
text |
2147483647 |
√ |
|
null |
|
|
| species |
text |
2147483647 |
√ |
|
null |
|
|
| lsdname |
text |
2147483647 |
√ |
|
null |
|
|
| toppid |
int4 |
10 |
√ |
|
null |
|
|
| ptt |
int4 |
10 |
√ |
|
null |
|
|
| seriesname |
text |
2147483647 |
√ |
|
null |
|
|
| dlatdd |
float8 |
17,17 |
√ |
|
null |
|
|
| dlondd |
float8 |
17,17 |
√ |
|
null |
|
|
| deplength |
text |
2147483647 |
√ |
|
null |
|
|
| deplen_type |
text |
2147483647 |
√ |
|
null |
|
|
| tagtype |
text |
2147483647 |
√ |
|
null |
|
|
| reclon |
float8 |
17,17 |
√ |
|
null |
|
|
| reclat |
float8 |
17,17 |
√ |
|
null |
|
|
| poplon |
float8 |
17,17 |
√ |
|
null |
|
|
| poplat |
float8 |
17,17 |
√ |
|
null |
|
|
| modpoplon |
float8 |
17,17 |
√ |
|
null |
|
|
| modpoplat |
float8 |
17,17 |
√ |
|
null |
|
|
| rdateestimated |
text |
2147483647 |
√ |
|
null |
|
|
| recpositionestimated |
text |
2147483647 |
√ |
|
null |
|
|
| fish_recaptured |
text |
2147483647 |
√ |
|
null |
|
|
| reclength |
text |
2147483647 |
√ |
|
null |
|
|
| reclen_type |
text |
2147483647 |
√ |
|
null |
|
|
| geolocated |
text |
2147483647 |
√ |
|
null |
|
|
| ssm_complete |
text |
2147483647 |
√ |
|
null |
|
|
| ssm_version |
text |
2147483647 |
√ |
|
null |
|
|
| findlats_outfile |
text |
2147483647 |
√ |
|
null |
|
|
| wc_id |
text |
2147483647 |
√ |
|
null |
|
|
Table contained 5,638 rows at Wed Dec 27 13:21 PST 2017
|
