Table topp.public.tblsgarchivaldeployment
This table is almost never used. It is rare for an archival deployment on a shark. The table structure is similar to 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
tkey serial 10  √  nextval('tblsgarchivaldeployment_tkey_seq'::regclass)
sgdepkey int4 10
toppid int4 10  √  null
commonname text 2147483647  √  null
seriesname text 2147483647  √  null
taggingdate date 13  √  null
taggingtime time 15,6  √  null
tagcode text 2147483647  √  null
dlatdd float4 8,8  √  null
dlondd float4 8,8  √  null
tag2code text 2147483647  √  null
tag2ptt 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
button text 2147483647  √  null
buttontype text 2147483647  √  null
buttonsuture text 2147483647  √  null
buttonlength text 2147483647  √  null
butnumber text 2147483647  √  null
closingsuture 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 float4 8,8  √  null
len1type text 2147483647  √  null
len2 float4 8,8  √  null
len2type text 2147483647  √  null
mass float4 8,8  √  null
masstype text 2147483647  √  null
halfgirth float4 8,8  √  null
tagreleasecomment text 2147483647  √  null
surgeryboat text 2147483647  √  null
gpsused text 2147483647  √  null
dlatdeg float4 8,8  √  null
dlatmin float4 8,8  √  null
ns text 2147483647  √  null
dlondeg float4 8,8  √  null
dlonmin float4 8,8  √  null
ew text 2147483647  √  null
stoptime time 15,6  √  null
endtime time 15,6  √  null
fishdetect text 2147483647  √  null
fishmethod text 2147483647  √  null
fdcomment text 2147483647  √  null
sst float4 8,8  √  null
sstdate date 13  √  null
ssttime time 15,6  √  null
sstprobe text 2147483647  √  null
sstalgorithm text 2147483647  √  null
correctedsst float4 8,8  √  null
weather text 2147483647  √  null
seastate text 2147483647  √  null
angler text 2147483647  √  null
linetest text 2147483647  √  null
leadertest text 2147483647  √  null
leadertype text 2147483647  √  null
ease2boat text 2147483647  √  null
capvessel text 2147483647  √  null
hooktype text 2147483647  √  null
baittype text 2147483647  √  null
fishingdepth text 2147483647  √  null
fighttime text 2147483647  √  null
handlingtime text 2147483647  √  null
injuries text 2147483647  √  null
tagapplocation text 2147483647  √  null
capcomments text 2147483647  √  null
dnasamplelocation text 2147483647  √  null
dnanumber text 2147483647  √  null
deploycomment text 2147483647  √  null
tagmodel text 2147483647  √  null
mrna_number text 2147483647  √  null
successful text 2147483647  √  null
animal_id serial 10  √  nextval('tblsgarchivaldeployment_animal_id_seq'::regclass)

Table contained 28 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
sgdepkey Primary key Asc tblsgarchivaldeployment_pkey