View topp.public.tblshark_deploy_rec_all 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
sgdepkey int4 10  √  null
toppid int4 10  √  null
tagcode text 2147483647  √  null
ptt int4 10  √  null
seriesname text 2147483647  √  null
tagdate date 13  √  null
dlatdd float8 17,17  √  null
dlondd float8 17,17  √  null
len1 text 2147483647  √  null
len1type text 2147483647  √  null
len2 text 2147483647  √  null
len2type text 2147483647  √  null
commonname text 2147483647  √  null
nickname text 2147483647  √  null
fin_id text 2147483647  √  null
sex text 2147483647  √  null
progpopdate text 2147483647  √  null
tagtype text 2147483647  √  null
dnanumber text 2147483647  √  null
rdate date 13  √  null
popdate date 13  √  null
poplon float8 17,17  √  null
poplat float8 17,17  √  null
reclon float8 17,17  √  null
reclat float8 17,17  √  null
rdateestimated text 2147483647  √  null
recpositionestimated text 2147483647  √  null
fish_recaptured text 2147483647  √  null
recvsourcetype text 2147483647  √  null
reclocation text 2147483647  √  null
rlength float4 8,8  √  null
rlentype text 2147483647  √  null
recvcomment text 2147483647  √  null
prematurerelease text 2147483647  √  null
geolocated text 2147483647  √  null
ssm_complete text 2147483647  √  null
ssm_version text 2147483647  √  null
findlats_outfile text 2147483647  √  null
comments text 2147483647  √  null
mod_popdate text 2147483647  √  null
mod_poplon float8 17,17  √  null
mod_poplat float8 17,17  √  null
lab_recdate text 2147483647  √  null
hawaii_track text 2147483647  √  null
cafe_track text 2147483647  √  null
naturalmortality text 2147483647  √  null
tagging_mortality text 2147483647  √  null
ssm_tracklen_km int4 10  √  null
straight_distance int4 10  √  null
popmonth float8 17,17  √  null
popyear float8 17,17  √  null

Analyzed at Wed Dec 27 13:25 PST 2017