Table topp.deprecated.shark_table 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
sgkey int4 10  √  null
tblsharkdeployment_actpopdate text 2147483647  √  null
tblsharkdeployment_baittype text 2147483647  √  null
tblsharkdeployment_commonname text 2147483647  √  null
tblsharkdeployment_contag1number text 2147483647  √  null
tblsharkdeployment_contag1position text 2147483647  √  null
tblsharkdeployment_contag1type text 2147483647  √  null
tblsharkdeployment_contag2number text 2147483647  √  null
tblsharkdeployment_contag2position text 2147483647  √  null
tblsharkdeployment_contag2type text 2147483647  √  null
tblsharkdeployment_correctedsst text 2147483647  √  null
tblsharkdeployment_dlatdeg text 2147483647  √  null
tblsharkdeployment_dlatmin text 2147483647  √  null
tblsharkdeployment_dlondeg text 2147483647  √  null
tblsharkdeployment_dlonmin text 2147483647  √  null
tblsharkdeployment_darttype text 2147483647  √  null
tblsharkdeployment_deploykey text 2147483647  √  null
tblsharkdeployment_ew text 2147483647  √  null
tblsharkdeployment_ease2boat text 2147483647  √  null
tblsharkdeployment_famename text 2147483647  √  null
tblsharkdeployment_fighttime text 2147483647  √  null
tblsharkdeployment_fishmethod text 2147483647  √  null
tblsharkdeployment_fishingdepth text 2147483647  √  null
tblsharkdeployment_gpsused text 2147483647  √  null
tblsharkdeployment_halfgirth text 2147483647  √  null
tblsharkdeployment_handlingtime text 2147483647  √  null
tblsharkdeployment_hooktype text 2147483647  √  null
tblsharkdeployment_injuries text 2147483647  √  null
tblsharkdeployment_irrigation text 2147483647  √  null
tblsharkdeployment_leadtagger text 2147483647  √  null
tblsharkdeployment_leaderlength text 2147483647  √  null
tblsharkdeployment_leadertest text 2147483647  √  null
tblsharkdeployment_leadertype text 2147483647  √  null
tblsharkdeployment_len1 text 2147483647  √  null
tblsharkdeployment_len1type text 2147483647  √  null
tblsharkdeployment_linetest text 2147483647  √  null
tblsharkdeployment_loopnum text 2147483647  √  null
tblsharkdeployment_loopposition text 2147483647  √  null
tblsharkdeployment_masstype text 2147483647  √  null
tblsharkdeployment_masskg text 2147483647  √  null
tblsharkdeployment_ns text 2147483647  √  null
tblsharkdeployment_project text 2147483647  √  null
tblsharkdeployment_psatleadernumber text 2147483647  √  null
tblsharkdeployment_ptt text 2147483647  √  null
tblsharkdeployment_penetrationdepth text 2147483647  √  null
tblsharkdeployment_progdate text 2147483647  √  null
tblsharkdeployment_progpopdate text 2147483647  √  null
tblsharkdeployment_pulltime text 2147483647  √  null
tblsharkdeployment_releasecomment text 2147483647  √  null
tblsharkdeployment_releasedevice text 2147483647  √  null
tblsharkdeployment_sst text 2147483647  √  null
tblsharkdeployment_seastate text 2147483647  √  null
tblsharkdeployment_seriesname text 2147483647  √  null
tblsharkdeployment_setnumber text 2147483647  √  null
tblsharkdeployment_setstarttime text 2147483647  √  null
tblsharkdeployment_settime text 2147483647  √  null
tblsharkdeployment_sex text 2147483647  √  null
tblsharkdeployment_sexmaturity text 2147483647  √  null
tblsharkdeployment_species text 2147483647  √  null
tblsharkdeployment_toppid text 2147483647  √  null
tblsharkdeployment_tag2code text 2147483647  √  null
tblsharkdeployment_tagapplocation text 2147483647  √  null
tblsharkdeployment_tagcode text 2147483647  √  null
tblsharkdeployment_tagposition text 2147483647  √  null
tblsharkdeployment_tagteam text 2147483647  √  null
tblsharkdeployment_taggingdate text 2147483647  √  null
tblsharkdeployment_taggingtime text 2147483647  √  null
tblsharkdeployment_taggingvessel text 2147483647  √  null
tblsharkdeployment_transfercaptain text 2147483647  √  null
tblsharkdeployment_weather text 2147483647  √  null
tblsharkdeployment_tagnumber text 2147483647  √  null
tblsharkdeployment_sgdepkey int4 10  √  null
tblsharkfiles_sgadkey text 2147483647  √  null
tblsharkfiles_tagcode text 2147483647  √  null
tblsharkfiles_ptt text 2147483647  √  null
tblsharkfiles_taggingdate text 2147483647  √  null
tblsharkfiles_instreportfile text 2147483647  √  null
tblsharkfiles_instdir text 2147483647  √  null
tblsharkfiles_patprogrepfile text 2147483647  √  null
tblsharkfiles_patprogdir text 2147483647  √  null
tblsharkfiles_spotprogrepfile text 2147483647  √  null
tblsharkfiles_spotprogdir text 2147483647  √  null
tblsharkfiles_rawwchfile text 2147483647  √  null
tblsharkfiles_rawwchdir text 2147483647  √  null
tblsharkfiles_wcgfile text 2147483647  √  null
tblsharkfiles_wcgdir text 2147483647  √  null
tblsharkfiles_wchfile text 2147483647  √  null
tblsharkfiles_wchdir text 2147483647  √  null
tblsharkfiles_xlsfile text 2147483647  √  null
tblsharkfiles_xlsdir text 2147483647  √  null
tblsharkfiles_tkey int4 10  √  null
tblsharkrecovery_actew text 2147483647  √  null
tblsharkrecovery_actns text 2147483647  √  null
tblsharkrecovery_actpopdate text 2147483647  √  null
tblsharkrecovery_actpoplat text 2147483647  √  null
tblsharkrecovery_actpoplon text 2147483647  √  null
tblsharkrecovery_gender text 2147483647  √  null
tblsharkrecovery_rcomments text 2147483647  √  null
tblsharkrecovery_rconaddress text 2147483647  √  null
tblsharkrecovery_rcontcomments text 2147483647  √  null
tblsharkrecovery_rdate text 2147483647  √  null
tblsharkrecovery_rgirth text 2147483647  √  null
tblsharkrecovery_rinjuries text 2147483647  √  null
tblsharkrecovery_rkey text 2147483647  √  null
tblsharkrecovery_rlentype text 2147483647  √  null
tblsharkrecovery_rlength text 2147483647  √  null
tblsharkrecovery_rmass text 2147483647  √  null
tblsharkrecovery_rmasstype text 2147483647  √  null
tblsharkrecovery_rpaid text 2147483647  √  null
tblsharkrecovery_rpaidto text 2147483647  √  null
tblsharkrecovery_rsource text 2147483647  √  null
tblsharkrecovery_rtagcomments text 2147483647  √  null
tblsharkrecovery_rtagnumber text 2147483647  √  null
tblsharkrecovery_rtime text 2147483647  √  null
tblsharkrecovery_rcontact text 2147483647  √  null
tblsharkrecovery_reclocation text 2147483647  √  null
tblsharkrecovery_recvcomment text 2147483647  √  null
tblsharkrecovery_returnedtags text 2147483647  √  null
tblsharkrecovery_toppid text 2147483647  √  null
tblsharkrecovery_tabkey text 2147483647  √  null
tblsharkrecovery_sgrckey int4 10  √  null

Table contained 390 rows at Wed Dec 27 13:21 PST 2017