Table topp.public.tblfgarchivaldeployment
This table contains deployment metadata from all archival tagged fishgroup animals. Typically joins will be made to the fgadkey or toppid fields. Important fields used as query filters are project, seriesname, successful, taggingdate, tagmodel, tagtype and releasetype. This can be a confusing table. There are probably some unnecessary fields. All of the yes/no fields use 1 and 0 as their values and should be changed from type text to integer. All date fields should be converted from type text to date or timestamp.

 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 serial 10  √  nextval('tblfgarchivaldeployment_fgadkey_seq'::regclass) This field should be called eventid. It joins to fgarkey in tblfgarchivalrecovery, fgdkey in tblfgprocessingstatus and fgapkey in tblfgarchivalprogramming as well as any other place eventid works for archival tags. It breaks down into several components. The first 2 digits are species ID. Digits 3 and 4 representdeployment year. Digits 5 - 7 count from 1 and represent individual animal deployments for the year.Digits 8 and 9 count from 0 and represent individual tags from the individual animal deployment.
angler text 2147483647  √  null Who caught the animal to be tagged?
baittype text 2147483647  √  null What type of bait was used to catch the fish?
butlength text 2147483647  √  null
butnumber text 2147483647  √  null
button text 2147483647  √  null
buttonsuture text 2147483647  √  null
buttontype text 2147483647  √  null
capcomments text 2147483647  √  null For comments related to animal capture, e.g., "Associated with Dolphins.".
capvessel text 2147483647  √  null What vessel was used to capture the fish?
closingsuture text 2147483647  √  null
commonname text 2147483647  √  'unknown'::text Matches commonname in toppspecies table.
contag1number text 2147483647  √  null Serial number of first conventional tag.
contag1position text 2147483647  √  null Where on the fish was conventional tag 1 applied.
contag1type text 2147483647  √  null Generally either floy or hallprint.
contag2number text 2147483647  √  null Serial number of second conventional tag.
contag2position text 2147483647  √  null Where on the fish was conventional tag 2 applied.
contag2type text 2147483647  √  null Generally either floy or hallprint.
correctedsst text 2147483647  √  null
daystartlat text 2147483647  √  null Only rarely used by ABFT. Candidate for deprecation.
daystartlong text 2147483647  √  null Only rarely used by ABFT. Candidate for deprecation.
daystarttimelocal text 2147483647  √  null Only rarely used by ABFT. Candidate for deprecation.
daystartsst text 2147483647  √  null Only rarely used by ABFT. Candidate for deprecation.
dlatmin text 2147483647  √  null The latitude minute value of deployment location. Generally in decimal minute format.
dlatdeg text 2147483647  √  null The latitude degree value of deployment location.
dlondeg text 2147483647  √  null The longitude degree value of deployment location.
dlonmin text 2147483647  √  null The longitude minute value of deployment locations. Generally in decimal minute format.
deploycomment text 2147483647  √  null Generic comments field.
dnanumber text 2147483647  √  null What number is on the DNA vial.
dnasamplelocation text 2147483647  √  null What part of the fish was sampled for DNA.
ease2boat text 2147483647  √  null Very confusing field of limited use. Sometimes it has a value like "Easy" or sometimes it is "Medium", but often it is fight time which already has its own field. Candidate for deprecation.
ew text 2147483647  √  null Deployment hemisphere where e is east and w is west.
fishdetect text 2147483647  √  null Hardly ever used and confusing. Candidate for deprecation.
fishingdepth text 2147483647  √  null Another confusing field. Sometimes it gets bathymetric depth and sometimes depth of lure etc. Candidate for deprecation.
fishmethod text 2147483647  √  null How the animal was caught.
fighttime text 2147483647  √  null Time in minutes to land the fish.
gpsused text 2147483647  √  null What GPS was used to generate deployment location?
halfgirth text 2147483647  √  null What is the half girth measurement in centimeters?
handlingtime text 2147483647  √  null Time in minutes from when the fish was brought to the boat until it was released.
hooktype text 2147483647  √  null What type of hook was used to catch fish.
injuries text 2147483647  √  null What injuries happened to the fish during capture and/or tagging.
irrigation text 2147483647  √  null Was the fish irrigated during tagging?
leadtagger text 2147483647  √  null The person attaching the tag to the fish.
leadertest text 2147483647  √  null The leader line test in pounds.
leadertype text 2147483647  √  null The material of the leader line.
len1 text 2147483647  √  null The length of the fish in centimeters.
len1type text 2147483647  √  null How was the fish length measured, e.g., CFL, SFL or TL.
len2 text 2147483647  √  null A second length measurement of the fish in centimeters.
len2type text 2147483647  √  null Same as len1type but for second measurement.
linetest text 2147483647  √  null Fishing line test in pounds.
mass text 2147483647  √  null The mass of the fish in kilograms.
masstype text 2147483647  √  null How was the mass measurement taken, e.g., estimated, measured, LMDerived.
ns text 2147483647  √  null Deployment hemisphere where s is south and n is north.
penetrationdepth text 2147483647  √  null
progdate text 2147483647  √  null Programming date of tag. Duplicate of info in programming table. Candidate for deprecation.
project text 2147483647  √  'unknown'::text The group responsible for tagging, e.g., TOPP, GTOPP, NonTOPP, IGFA or TAG. Not a seriously important field but can be useful in queries.
releasetype text 2147483647  √  'unknown'::text Generally not too important except in the case of PBFT released from a pen or into a pen only, e.g., Pen2wild or Pen.
seastate text 2147483647  √  null Description of ocean conditions like wave height.
seriesname text 2147483647  √  'unknown'::text Simple geographic desciptor of deployment locationincluding year.
sex text 2147483647  √  null Never used for fish. The sex of the fish where F = female, M = male and U = unknown.
species text 2147483647  √  'unknown'::text Matches genus and species from toppspecies table.
sst text 2147483647  √  null The sea surface temperature in degrees celsius.
sstdate text 2147483647  √  null The date the SST was measured.
ssttime text 2147483647  √  null
sstprobe text 2147483647  √  null The instument used to measure SST.
sstalgorithm text 2147483647  √  null The sensor correction algorithm applied to the raw SST reading.
successful text 2147483647  √  '1'::text Was the deployment successful? Almost always true but there are some PBFT that died in pen before release. Yes is 1 and no is 0.
surgeryboat text 2147483647  √  null What boat did the tagging take place on?
tageventcomment text 2147483647  √  null For comments related to the tagging event, e.g., "Fish tagged itself. Beautiful implantation.".
taggingdate text 2147483647  √  null Local date at deployment of tag.
taggingtime text 2147483647  √  null Local time at deployment of tag.
tagcode text 2147483647  √  'unknown'::text Serial number of tag with prefix identifying manufacturer and model. The prefix matches tagcode in tbltopptags. This prefix is unnecessary given the tagmodel field and will be deprecated in future.
tagposition text 2147483647  √  null Where on the fish was the tag placed?
tagteam text 2147483647  √  null Who was involved in the tagging event?
tagapplocation text 2147483647  √  null Another confusing and unnecessary field. Candidate for deprecation.
tagreleasecomment text 2147483647  √  null For comments related to the release event, e.g., "Looked good going out the door.".
tid text 2147483647  √  null Unknown. Probably an early version of tkey. Should be deprecated.
transferboat text 2147483647  √  null Was a boat used to transfer the fish to the tagging boat? If so what was the name of the boat?
transfercaptain text 2147483647  √  null Was a boat used to transfer the fish to the tagging boat? If so who was the captain of the boat?
weather text 2147483647  √  null General description of temperature and cloud cover.
addtag text 2147483647  √  null Never used and confusing. Should be deprecated.
datesstcorrected text 2147483647  √  null Why is this important? Should be in processing table if anywhere. Candidate for deprecation.
daystarttime text 2147483647  √  null
tagmodel text 2147483647  √  'unknown'::text Should match model name in tbltmarchival.
tagtype text 2147483647  √  'archival'::text Probably unnecessary for this table as it will almost always be archival.
dlatdd float8 17,17  √  null Deployment latitude in decimal degrees.
dlondd float8 17,17  √  null Deployment longitude in decimal degrees.
mrna_number text 2147483647  √  null What number is on the mRNA vial?
toppid int4 10  √  null The basic ID number for a specific animal deployment.Matches the first 7 digits of eventid.
tkey serial 10  √  nextval('tblfgarchivaldeployment_tkey_seq'::regclass)
stableiso_num text 2147483647  √  null
deployloc_estimated int4 10  √  0 A yes/no field indicating the deployment lat and lon are estimated positions.

Table contained 2,702 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
fgadkey Primary key Asc tblfgarchivaldeployment_pkey