Table topp.deprecated.glnfgsatdeployments 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
fgsdkey int4 10  √  null
angler text 2147483647  √  null
argosaccno text 2147483647  √  null
baittype text 2147483647  √  null
capcomments text 2147483647  √  null
capturevessel text 2147483647  √  null
correctedsstc text 2147483647  √  null
commonname 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
dlatdeg text 2147483647  √  null
dlatmin text 2147483647  √  null
ns text 2147483647  √  null
dlondeg text 2147483647  √  null
dlonmin text 2147483647  √  null
darttype text 2147483647  √  null
deploycomment text 2147483647  √  null
daystartlat text 2147483647  √  null
daystartlon text 2147483647  √  null
daystartsst text 2147483647  √  null
daystarttimelocal text 2147483647  √  null
dnasamplelocation text 2147483647  √  null
dnanumber text 2147483647  √  null
ease2boat text 2147483647  √  null
endtime text 2147483647  √  null
ew text 2147483647  √  null
fishdetect text 2147483647  √  null
fishingdepth text 2147483647  √  null
fighttime text 2147483647  √  null
fishmethod text 2147483647  √  null
fdcomment text 2147483647  √  null
gpsused text 2147483647  √  null
halfgirth text 2147483647  √  null
handlingtime text 2147483647  √  null
hooktype text 2147483647  √  null
linetest text 2147483647  √  null
leadertest text 2147483647  √  null
leadertype text 2147483647  √  null
injuries text 2147483647  √  null
irrigation text 2147483647  √  null
localendtime text 2147483647  √  null
localssttime text 2147483647  √  null
localstoptime text 2147483647  √  null
localtagtime text 2147483647  √  null
leaderlength text 2147483647  √  null
leadtagger 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
numberofhooks text 2147483647  √  null
penetrationdepth text 2147483647  √  null
pullstarttime text 2147483647  √  null
tagreleasecomment text 2147483647  √  null
surgeryboat text 2147483647  √  null
progdate text 2147483647  √  null
popoffdate text 2147483647  √  null
ptt text 2147483647  √  null
psatleaderno text 2147483647  √  null
releasetype text 2147483647  √  null
soaktime text 2147483647  √  null
successful text 2147483647  √  null
seastate text 2147483647  √  null
seriesname text 2147483647  √  null
stoptime text 2147483647  √  null
species text 2147483647  √  null
sex text 2147483647  √  null
sst text 2147483647  √  null
sstdate text 2147483647  √  null
ssttime text 2147483647  √  null
sstprobe text 2147483647  √  null
sstalgorithm text 2147483647  √  null
tag2code text 2147483647  √  null
tag2ptt text 2147483647  √  null
tag2progdate text 2147483647  √  null
tag2position text 2147483647  √  null
tagteam text 2147483647  √  null
transferboat text 2147483647  √  null
transfercaptain text 2147483647  √  null
tagposition text 2147483647  √  null
tageventcomment text 2147483647  √  null
tagapplication text 2147483647  √  null
toppid text 2147483647  √  null
taggingdate text 2147483647  √  null
taggingtime text 2147483647  √  null
tagcode text 2147483647  √  null
weather text 2147483647  √  null
project text 2147483647  √  null

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