| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| encounterid |
int4 |
10 |
√ |
|
null |
|
|
| transfercaptainid |
int4 |
10 |
√ |
|
null |
|
|
| transfervesselname |
unknown |
2147483647 |
√ |
|
null |
|
|
| caudallength |
float4 |
8,8 |
√ |
|
null |
|
|
| precaudallength |
float4 |
8,8 |
√ |
|
null |
|
|
| curvedforklength |
float4 |
8,8 |
√ |
|
null |
|
|
| halfgirthcm |
float4 |
8,8 |
√ |
|
null |
|
|
| easeuptoboat |
varchar |
40 |
√ |
|
null |
|
|
| bait |
varchar |
40 |
√ |
|
null |
|
|
| numberofhooks |
float4 |
8,8 |
√ |
|
null |
|
|
| fishingdepth |
float4 |
8,8 |
√ |
|
null |
|
|
| linetest |
varchar |
40 |
√ |
|
null |
|
|
| leadertest |
varchar |
40 |
√ |
|
null |
|
|
| soakfighttime |
time |
15,6 |
√ |
|
null |
|
|
| pullstarttime |
time |
15,6 |
√ |
|
null |
|
|
| setstarttime |
time |
15,6 |
√ |
|
null |
|
|
| surgerytime |
time |
15,6 |
√ |
|
null |
|
|
| surgerycomment |
text |
2147483647 |
√ |
|
null |
|
|
| vesselname |
varchar |
160 |
√ |
|
null |
|
|
| hooktype |
varchar |
40 |
√ |
|
null |
|
|
| departcoast |
date |
13 |
√ |
|
null |
|
|
| buttonsuture1 |
varchar |
80 |
√ |
|
null |
|
|
| buttonsuture2 |
varchar |
80 |
√ |
|
null |
|
|
| closingsuture |
varchar |
80 |
√ |
|
null |
|
|
| setnumber |
unknown |
2147483647 |
√ |
|
null |
|
|
| fishingmethod |
unknown |
2147483647 |
√ |
|
null |
|
|
| tagapplocation |
unknown |
2147483647 |
√ |
|
null |
|
|
| irrigation |
unknown |
2147483647 |
√ |
|
null |
|
|
| sexmaturity |
unknown |
2147483647 |
√ |
|
null |
|
|
Analyzed at Wed Dec 27 13:25 PST 2017
|