Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
toppid |
text |
2147483647 |
√ |
|
null |
|
|
pttnumber |
int4 |
10 |
√ |
|
null |
|
ptts.pttnumber
|
Implied Constraint R |
|
fgsdkey |
int4 |
10 |
√ |
|
null |
|
|
commonname |
text |
2147483647 |
√ |
|
null |
|
|
seriesname |
text |
2147483647 |
√ |
|
null |
|
|
taggingdate |
text |
2147483647 |
√ |
|
null |
|
|
taggingtime |
text |
2147483647 |
√ |
|
null |
|
|
tagcode |
text |
2147483647 |
√ |
|
null |
|
|
ptt |
text |
2147483647 |
√ |
|
null |
|
|
argosaccno |
text |
2147483647 |
√ |
|
null |
|
|
progdate |
text |
2147483647 |
√ |
|
null |
|
|
popoffdate |
text |
2147483647 |
√ |
|
null |
|
|
psatleaderno |
text |
2147483647 |
√ |
|
null |
|
|
darttype |
text |
2147483647 |
√ |
|
null |
|
|
leaderlength |
text |
2147483647 |
√ |
|
null |
|
|
penetrationdepth |
text |
2147483647 |
√ |
|
null |
|
|
contag1number |
text |
2147483647 |
√ |
|
null |
|
|
contag1type |
text |
2147483647 |
√ |
|
null |
|
|
contag1position |
text |
2147483647 |
√ |
|
null |
|
|
contag2number |
text |
2147483647 |
√ |
|
null |
|
|
contag2type |
text |
2147483647 |
√ |
|
null |
|
|
contag2position |
text |
2147483647 |
√ |
|
null |
|
|
tag2code |
text |
2147483647 |
√ |
|
null |
|
|
tag2ptt |
text |
2147483647 |
√ |
|
null |
|
|
tag2progdate |
text |
2147483647 |
√ |
|
null |
|
|
tag2position |
text |
2147483647 |
√ |
|
null |
|
|
irrigation |
text |
2147483647 |
√ |
|
null |
|
|
tagposition |
text |
2147483647 |
√ |
|
null |
|
|
tageventcomment |
text |
2147483647 |
√ |
|
null |
|
|
species |
text |
2147483647 |
√ |
|
null |
|
|
leadtagger |
text |
2147483647 |
√ |
|
null |
|
|
tagteam |
text |
2147483647 |
√ |
|
null |
|
|
sex |
text |
2147483647 |
√ |
|
null |
|
|
len1 |
text |
2147483647 |
√ |
|
null |
|
|
len1type |
text |
2147483647 |
√ |
|
null |
|
|
len2 |
text |
2147483647 |
√ |
|
null |
|
|
len2type |
text |
2147483647 |
√ |
|
null |
|
|
mass |
text |
2147483647 |
√ |
|
null |
|
|
masstype |
text |
2147483647 |
√ |
|
null |
|
|
halfgirth |
text |
2147483647 |
√ |
|
null |
|
|
tagreleasecomment |
text |
2147483647 |
√ |
|
null |
|
|
surgeryboat |
text |
2147483647 |
√ |
|
null |
|
|
gpsused |
text |
2147483647 |
√ |
|
null |
|
|
dlatdeg |
text |
2147483647 |
√ |
|
null |
|
|
dlatmin |
text |
2147483647 |
√ |
|
null |
|
|
ns |
text |
2147483647 |
√ |
|
null |
|
|
dlondeg |
text |
2147483647 |
√ |
|
null |
|
|
dlonmin |
text |
2147483647 |
√ |
|
null |
|
|
ew |
text |
2147483647 |
√ |
|
null |
|
|
stoptime |
text |
2147483647 |
√ |
|
null |
|
|
endtime |
text |
2147483647 |
√ |
|
null |
|
|
fishdetect |
text |
2147483647 |
√ |
|
null |
|
|
fishmethod |
text |
2147483647 |
√ |
|
null |
|
|
fdcomment |
text |
2147483647 |
√ |
|
null |
|
|
sst |
text |
2147483647 |
√ |
|
null |
|
|
sstdate |
text |
2147483647 |
√ |
|
null |
|
|
ssttime |
text |
2147483647 |
√ |
|
null |
|
|
sstprobe |
text |
2147483647 |
√ |
|
null |
|
|
sstalgorithm |
text |
2147483647 |
√ |
|
null |
|
|
correctedsstc |
text |
2147483647 |
√ |
|
null |
|
|
weather |
text |
2147483647 |
√ |
|
null |
|
|
seastate |
text |
2147483647 |
√ |
|
null |
|
|
angler |
text |
2147483647 |
√ |
|
null |
|
|
linetest |
text |
2147483647 |
√ |
|
null |
|
|
leadertest |
text |
2147483647 |
√ |
|
null |
|
|
ease2boat |
text |
2147483647 |
√ |
|
null |
|
|
capturevessel |
text |
2147483647 |
√ |
|
null |
|
|
hooktype |
text |
2147483647 |
√ |
|
null |
|
|
leadertype |
text |
2147483647 |
√ |
|
null |
|
|
baittype |
text |
2147483647 |
√ |
|
null |
|
|
fishingdepth |
text |
2147483647 |
√ |
|
null |
|
|
fighttime |
text |
2147483647 |
√ |
|
null |
|
|
handlingtime |
text |
2147483647 |
√ |
|
null |
|
|
injuries |
text |
2147483647 |
√ |
|
null |
|
|
tagapplication |
text |
2147483647 |
√ |
|
null |
|
|
capcomments |
text |
2147483647 |
√ |
|
null |
|
|
dnasamplelocation |
text |
2147483647 |
√ |
|
null |
|
|
dnanumber |
text |
2147483647 |
√ |
|
null |
|
|
deploycomment |
text |
2147483647 |
√ |
|
null |
|
|
project |
text |
2147483647 |
√ |
|
null |
|
|
Table contained 30 rows at Wed Dec 27 13:21 PST 2017
|