Table topp.deprecated.shark_url_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
satdeploymentid int4 10  √  null
instrreporturl text 2147483647  √  null
progreporturl text 2147483647  √  null
pttnumber int4 10  √  null
ptts.pttnumber Implied Constraint R
startdate date 13  √  null
enddate date 13  √  null
diagurl text 2147483647  √  null
prvurl text 2147483647  √  null
taburl text 2147483647  √  null
flagurl text 2147483647  √  null
toppid text 2147483647  √  null
speciesname text 2147483647  √  null
actualpopupdate date 13  √  null
tagnumber text 2147483647  √  null
comment text 2147483647  √  null
contact text 2147483647  √  null
projectname text 2147483647  √  null
modelname text 2147483647  √  null
testingnote text 2147483647  √  null
owner text 2147483647  √  null
eventid int4 10  √  null
minimal_deploys.eventid Implied Constraint R
las text 2147483647  √  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_tagcode text 2147483647  √  null
tblsharkfiles_ptt text 2147483647  √  null
tblsharkfiles_taggingdate text 2147483647  √  null
tblsharkfiles_rawwchfile text 2147483647  √  null
tblsharkfiles_rawwchdir 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 522 rows at Wed Dec 27 13:21 PST 2017


Close relationships: