View topp.public.tm_sat_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
tagnumber text 2147483647  √  null
tagstatus text 2147483647  √  null
comments text 2147483647  √  null
taglabel text 2147483647  √  null
invoicedate text 2147483647  √  null
invoicenumber text 2147483647  √  null
tagmodel text 2147483647  √  null
tagsoft text 2147483647  √  null
tagowner text 2147483647  √  null
argos_region text 2147483647  √  null
eventid int4 10  √  null
tagcode text 2147483647  √  null
ptt int4 10  √  null
taggingdate text 2147483647  √  null
seriesname text 2147483647  √  null
commonname text 2147483647  √  null
dlondd float8 17,17  √  null
dlatdd float8 17,17  √  null
len1 text 2147483647  √  null
len1type text 2147483647  √  null
mass text 2147483647  √  null
trade_owner text 2147483647  √  null
trade_tag text 2147483647  √  null
trade_date text 2147483647  √  null
pttstatus text 2147483647  √  null
programnumber int4 10  √  null
toppid int4 10  √  null
popdate text 2147483647  √  null
poplon float8 17,17  √  null
poplat float8 17,17  √  null
prematurerelease text 2147483647  √  null
pin_broken text 2147483647  √  null
deploykey int4 10  √  null
tagmodel_num text 2147483647  √  null
rma_number text 2147483647  √  null
recdate text 2147483647  √  null
reclon float8 17,17  √  null
reclat float8 17,17  √  null
naturalmortality text 2147483647  √  null
tagging_mortality text 2147483647  √  null
geolocated text 2147483647  √  null
ssm_version text 2147483647  √  null
popup_lc text 2147483647  √  null
straight_distance int4 10  √  null
ssm_tracklen_km int4 10  √  null
ssm_tracklen_nm int4 10  √  null
modpopdate text 2147483647  √  null
modpoplon float8 17,17  √  null
modpoplat float8 17,17  √  null

Analyzed at Wed Dec 27 13:25 PST 2017