View topp.public.tm_acoustic_with_eventid
Joins management table and deploy info.

 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
serialnum text 2147483647  √  null
idcode int4 10  √  null
invoicedate text 2147483647  √  null
ordernumber text 2147483647  √  null
tagfamily text 2147483647  √  null
interval_min text 2147483647  √  null
interval_max text 2147483647  √  null
est_taglife text 2147483647  √  null
codespace1 text 2147483647  √  null
idcode2 int4 10  √  null
codespace2 text 2147483647  √  null
sensor text 2147483647  √  null
slope float4 8,8  √  null
intercept float4 8,8  √  null
idcode3 int4 10  √  null
codespace3 text 2147483647  √  null
sensor2 text 2147483647  √  null
slope2 float4 8,8  √  null
intercept2 float4 8,8  √  null
eventid int4 10  √  null
tagcode text 2147483647  √  null
ptt int4 10  √  null
vr4_feed text 2147483647  √  null
taggingdate text 2147483647  √  null
animal_id int4 10  √  null
nickname text 2147483647  √  null
commonname text 2147483647  √  null
taggingtime text 2147483647  √  null
len1 text 2147483647  √  null
species text 2147483647  √  null
dlatdd float8 17,17  √  null
dlondd float8 17,17  √  null
dead_by_date text 2147483647  √  null
last_detect_date text 2147483647  √  null
seriesname text 2147483647  √  null
toppid int4 10  √  null
sex text 2147483647  √  null
len1type text 2147483647  √  null
sensor3 text 2147483647  √  null
slope3 float4 8,8  √  null
intercept3 float4 8,8  √  null
angler text 2147483647  √  null
baittype text 2147483647  √  null
deploycomment text 2147483647  √  null
fishmethod text 2147483647  √  null
fishingdepth text 2147483647  √  null
halfgirth text 2147483647  √  null
injuries text 2147483647  √  null
leadtagger text 2147483647  √  null
len2 text 2147483647  √  null
len2type text 2147483647  √  null
mass text 2147483647  √  null
masstype text 2147483647  √  null
sstprobe text 2147483647  √  null
sst text 2147483647  √  null
seastate text 2147483647  √  null
sexmaturity text 2147483647  √  null
tageventcomment text 2147483647  √  null
tagposition text 2147483647  √  null
tagteam text 2147483647  √  null
taggingvessel text 2147483647  √  null
weather text 2147483647  √  null
tag1side text 2147483647  √  null
tag2side text 2147483647  √  null
waterdepth text 2147483647  √  null
claspers text 2147483647  √  null
len3 text 2147483647  √  null
len3type text 2147483647  √  null
taglocation text 2147483647  √  null
tagtype text 2147483647  √  null

Analyzed at Wed Dec 27 13:25 PST 2017