Table topp.deprecated.old_tblfgarchivaldeployment 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
fgadkey int4 10  √  null
angler text 2147483647  √  null
baittype text 2147483647  √  null
butlength text 2147483647  √  null
butnumber text 2147483647  √  null
button text 2147483647  √  null
buttonsuture text 2147483647  √  null
buttontype text 2147483647  √  null
capcomments text 2147483647  √  null
capvessel text 2147483647  √  null
closingsuture 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
daystartlat text 2147483647  √  null
daystartlong text 2147483647  √  null
daystarttimelocal text 2147483647  √  null
daystartsst text 2147483647  √  null
dlatmin text 2147483647  √  null
dlatdeg text 2147483647  √  null
dlondeg text 2147483647  √  null
dlonmin text 2147483647  √  null
deploycomment text 2147483647  √  null
dnanumber text 2147483647  √  null
dnasamplelocation text 2147483647  √  null
ease2boat text 2147483647  √  null
endtime text 2147483647  √  null
ew text 2147483647  √  null
fdcomment text 2147483647  √  null
fishdetect text 2147483647  √  null
fishingdepth text 2147483647  √  null
fishmethod text 2147483647  √  null
fighttime text 2147483647  √  null
gpsused text 2147483647  √  null
halfgirth text 2147483647  √  null
handlingtime text 2147483647  √  null
hooktype text 2147483647  √  null
injuries text 2147483647  √  null
irrigation text 2147483647  √  null
leadtagger 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
mass text 2147483647  √  null
masstype text 2147483647  √  null
numberofhooks text 2147483647  √  null
ns text 2147483647  √  null
penetrationdepth text 2147483647  √  null
progdate text 2147483647  √  null
projectid text 2147483647  √  null
projectname text 2147483647  √  null
pulltime text 2147483647  √  null
project text 2147483647  √  null
releasetype text 2147483647  √  null
seastate text 2147483647  √  null
seriesname text 2147483647  √  null
settime text 2147483647  √  null
sex text 2147483647  √  null
species text 2147483647  √  null
sst text 2147483647  √  null
sstdate text 2147483647  √  null
ssttime text 2147483647  √  null
sstprobe text 2147483647  √  null
sstalgorithm text 2147483647  √  null
stoptime text 2147483647  √  null
soakfighttime text 2147483647  √  null
successful text 2147483647  √  null
surgeryboat text 2147483647  √  null
tageventcomment text 2147483647  √  null
taggingdate text 2147483647  √  null
taggingtime text 2147483647  √  null
tagcode text 2147483647  √  null
tagposition text 2147483647  √  null
tagteam text 2147483647  √  null
tagapplocation text 2147483647  √  null
tagreleasecomment text 2147483647  √  null
tid text 2147483647  √  null
toppid text 2147483647  √  null
transferboat text 2147483647  √  null
transfercaptain text 2147483647  √  null
weather text 2147483647  √  null

Table contained 1,779 rows at Wed Dec 27 13:21 PST 2017