View topp.public.tblabft_deploy_rec_all
This view gathers all essential ABFT deploy, recovery and processing data. It calculates deployage using Restrepo 2010.

 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
toppid int4 10  √  null
seriesname text 2147483647  √  null
taggingdate timestamp 29,6  √  null
tagcode text 2147483647  √  null
ptt int4 10  √  null
dlatdd float8 17,17  √  null
dlondd float8 17,17  √  null
len1 text 2147483647  √  null
mass text 2147483647  √  null
progpopdate text 2147483647  √  null
successful text 2147483647  √  null
recdate timestamp 29,6  √  null
harvdate timestamp 29,6  √  null
popdate timestamp 29,6  √  null
rdateestimated text 2147483647  √  null
poppositiontype text 2147483647  √  null
actpoplat float8 17,17  √  null
actpoplon float8 17,17  √  null
tagreturned text 2147483647  √  null
recvsourcetype text 2147483647  √  null
reclocation text 2147483647  √  null
rlatdd float8 17,17  √  null
rlondd float8 17,17  √  null
tagtype text 2147483647  √  null
breedingstatus text 2147483647  √  null
qc_breed text 2147483647  √  null
recvlen1 text 2147483647  √  null
recvlen1type text 2147483647  √  null
recvmass text 2147483647  √  null
masstype text 2147483647  √  null
naturalmortality text 2147483647  √  null
recvcomment text 2147483647  √  null
qc_track text 2147483647  √  null
recpositionestimated text 2147483647  √  null
dnanumber text 2147483647  √  null
dnasamplelocation text 2147483647  √  null
unknowndeploy text 2147483647  √  null
geo_daterange_days int4 10  √  null
deployage numeric 131089  √  null
tagging_mortality text 2147483647  √  null
spawn_behavior text 2147483647  √  null
ssm_complete text 2147483647  √  null
gom_fish text 2147483647  √  null
med_fish text 2147483647  √  null
attach text 2147483647  √  null
project text 2147483647  √  null
geolocated text 2147483647  √  null
ssm_version text 2147483647  √  null
findlats_outfile text 2147483647  √  null
popdate_geo timestamp 29,6  √  null
poplat_geo float8 17,17  √  null
poplon_geo float8 17,17  √  null
tagmodel text 2147483647  √  null
lab_recdate text 2147483647  √  null

Analyzed at Wed Dec 27 13:25 PST 2017