View topp.public.tblmarlin_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
eventid 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
commonname text 2147483647  √  null
progpopdate text 2147483647  √  null
fish_num int4 10  √  null
popdate date 13  √  null
poplon float8 17,17  √  null
poplat float8 17,17  √  null
recdate text 2147483647  √  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
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
popdate_geoloc text 2147483647  √  null
poplon_geoloc float8 17,17  √  null
poplat_geoloc float8 17,17  √  null
lab_recdate text 2147483647  √  null
naturalmortality text 2147483647  √  null
tagging_mortality text 2147483647  √  null
ssm_tracklen_nm int4 10  √  null
straight_distance int4 10  √  null
pin_broken text 2147483647  √  null

Analyzed at Wed Dec 27 13:25 PST 2017