Table topp.public.tblfgarchivalrecovery
This table contains recovery metadata from all archival tagged fishgroup animals. Typically joins will be made to the fgarkey or toppid fields. Important fields are recdate, harvdate, lab_recdate, tagreturned, rdateestimated, and recpositionestimated. 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
fgarkey serial 10  √  nextval('tblfgarchivalrecovery_fgarkey_seq'::regclass) This field should be called eventid. It joins to fgadkey in tblfgarchivaldeployment, fgdkey in tblfgprocessingstatus as well as any other place eventid works for archival tags.
tagcode text 2147483647  √  'unknown'::text Same as tagcode in deployment table.
recvspecies text 2147483647  √  null Same as species in deployment table. Unnecessary and should be deprecated.
recvctag1 text 2147483647  √  null First recovered conventional tag.
rct1type text 2147483647  √  null First conventional tag type.
recvctag2 text 2147483647  √  null Second recovered conventional tag.
rct2type text 2147483647  √  null Second conventional tag type.
addrecvtags text 2147483647  √  null Any recovered tags that do not fit in other tag fields.
recdate text 2147483647  √  null The date the animal is recaptured or tag is recovered.
pendate text 2147483647  √  null The date the animal is put in a pen.
harvdate text 2147483647  √  null The date the tag is removed from the animal.
tagreturned text 2147483647  √  '0'::text Was the tag returned to the Block lab or another location where the data could be downloaded?
tagfunctional text 2147483647  √  '0'::text Probably unnecessary because of fields in tblfgprocessingstatus. Good candidate for deprecation.
recvlat text 2147483647  √  null Recovery latitude. Should be an integer.
sn text 2147483647  √  null Recovery hemisphere where s is south and n is north.
recvlon text 2147483647  √  null Recovery longitude. Should be an integer.
ew text 2147483647  √  null Recovery hemisphere where e is east and w is west.
recvbinfile text 2147483647  √  null Name of the recovered bin file.
recvsourcetype text 2147483647  √  'unknown'::text Will generally be what type of fishing vessel caught the fish but can also be beachcomber, trap etc.
recvsourcename text 2147483647  √  null Name of the fishing vessel.
penname text 2147483647  √  null The name of the pen where the fish was held.
rewardperson text 2147483647  √  null The name of the person who recovered the tag and receives the reward.
rewardaddress text 2147483647  √  null The address of the person who recovered the tag and receives the reward.
paid text 2147483647  √  '0'::text Was the reward paid? Yes is 1 and no is 0.
recvlen1 text 2147483647  √  null The length of the fish in centimeters.
recvlen1type text 2147483647  √  null The type of length measurement, e.g., CFL, SFL or TL.
depstl text 2147483647  √  null The deployment straight length of the fish. No reason for this field in this table. Should be deprecated.
recvgirth text 2147483647  √  null The girth of the fish in centimeters.
recvmass text 2147483647  √  null The mass of the fish in kilograms.
masstype text 2147483647  √  null What condition was the fish, e.g., whole, round, dressed.
masscondition text 2147483647  √  null Seems to be a duplicate of masstype. One of them should be deprecated.
sst text 2147483647  √  null The SST in fahrenheit at fish recapture location.
recvcomment text 2147483647  √  null
willbeprocessed text 2147483647  √  '1'::text Used as an indicator of tag health or recovery type. Handled in processing status now. Good candidate for deprecation.
sex text 2147483647  √  null The sex of the recovered animal.
reclocation text 2147483647  √  null Generic geographic location of recovery. Not very useful. Possible candidate for deprecation.
recvbinpwd text 2147483647  √  null The password used to unlock the Lotek LTD bin file.
rdateestimated text 2147483647  √  '0'::text Is the recovery date an estimate?
rlatdd float8 17,17  √  null The decimal degree recovery latitude.
rlondd float8 17,17  √  null The decimal degree recovery longitude.
recpositionestimated text 2147483647  √  '0'::text Is the recovery position estimated?
unknowndeploy text 2147483647  √  '0'::text There are some old ABFT recoveries where we never received the tag or tag number. We guessed at the possible deployment tags and gave them a value of 1 for this field.
vessel_flag text 2147483647  √  null What country is the recapture vessel from?
lab_recdate text 2147483647  √  null What date did we learn about the recovery? Could also be ingestion date or record creation date.
paid_comment text 2147483647  √  null Comments related to the reward payment.
rcontact text 2147483647  √  null Who informed us of the recovery?
reward_phone text 2147483647  √  null The phone number of the person who recovered the tag and receives the reward.
reward_email text 2147483647  √  null The email address of the person who recoveredthe tag and receives the reward.
rconaddress text 2147483647  √  null Address of the recovery contact person.
rcon_phone text 2147483647  √  null Telephone number of the recovery contact person.
rcon_email text 2147483647  √  null
paid_amount text 2147483647  √  null The dollar amount of the reward.
toppid int4 10  √  null Same as toppid in deployment table.
tkey serial 10  √  nextval('tblfgarchivalrecovery_tkey_seq'::regclass)

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

Indexes:
Column(s) Type Sort Constraint Name
fgarkey Primary key Asc tblfgarchivalrecovery_pkey