Table topp.deprecated.new_tblsharkdeployment Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
sgdepkey int4 10
actpopdate text 2147483647  √  null
angler text 2147483647  √  null
baittype text 2147483647  √  null
commonname text 2147483647  √  null
contag1number text 2147483647  √  null
contag1position text 2147483647  √  null
contag1type text 2147483647  √  null
contag2number text 2147483647  √  null
contag2position text 2147483647  √  null
contag2type text 2147483647  √  null
correctedsst text 2147483647  √  null
dlatdeg text 2147483647  √  null
dlatmin text 2147483647  √  null
dlondeg text 2147483647  √  null
dlonmin text 2147483647  √  null
dnanumber text 2147483647  √  null
dnasamplelocation text 2147483647  √  null
darttype text 2147483647  √  null
deploycomment text 2147483647  √  null
deploykey text 2147483647  √  null
ew text 2147483647  √  null
ease2boat text 2147483647  √  null
famename text 2147483647  √  null
fighttime text 2147483647  √  null
fishmethod text 2147483647  √  null
fishingdepth text 2147483647  √  null
gpsused text 2147483647  √  null
halfgirth text 2147483647  √  null
handlingcomments text 2147483647  √  null
handlingtime text 2147483647  √  null
hooktype text 2147483647  √  null
injuries text 2147483647  √  null
irrigation text 2147483647  √  null
leadtagger text 2147483647  √  null
leaderlength text 2147483647  √  null
leadertest text 2147483647  √  null
leadertype text 2147483647  √  null
len1 text 2147483647  √  null
len1type text 2147483647  √  null
len2 text 2147483647  √  null
len2type text 2147483647  √  null
linetest text 2147483647  √  null
loopnum text 2147483647  √  null
loopposition text 2147483647  √  null
masstype text 2147483647  √  null
masskg text 2147483647  √  null
ns text 2147483647  √  null
numberhooks text 2147483647  √  null
prboattack text 2147483647  √  null
project text 2147483647  √  null
psatleadernumber text 2147483647  √  null
ptt text 2147483647  √  null
penetrationdepth text 2147483647  √  null
probe text 2147483647  √  null
progdate text 2147483647  √  null
progpopdate text 2147483647  √  null
pulltime text 2147483647  √  null
releasecomment text 2147483647  √  null
releasedevice text 2147483647  √  null
sst text 2147483647  √  null
seastate text 2147483647  √  null
seriesname text 2147483647  √  null
setnumber text 2147483647  √  null
setstarttime text 2147483647  √  null
settime text 2147483647  √  null
sex text 2147483647  √  null
sexmaturity text 2147483647  √  null
species text 2147483647  √  null
toppid text 2147483647  √  null
tag2code text 2147483647  √  null
tagapplocation text 2147483647  √  null
tagcode text 2147483647  √  null
tageventcomment text 2147483647  √  null
tagposition text 2147483647  √  null
tagteam text 2147483647  √  null
taggingdate text 2147483647  √  null
taggingtime text 2147483647  √  null
taggingvessel text 2147483647  √  null
transfercaptain text 2147483647  √  null
weather text 2147483647  √  null
tagnumber text 2147483647  √  null
tag2ptt text 2147483647  √  null
tag2progdate text 2147483647  √  null
tag1side text 2147483647  √  null
tag2side text 2147483647  √  null
popup_comment text 2147483647  √  null
argosaccno text 2147483647  √  null

Table contained 697 rows at Wed Dec 27 13:21 PST 2017