View topp.public.popups_diag
This view takes all Argos data from diag_satdeployments_mc and breaks it into separate fields. The name should probably be changed to reflect the fact that more than popup data is present. It joins to fishgroup and sharkgroup deploy data and is used for catching new popups. Joins to this table will usually be made to eventid or pttnumber.

 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
pttnumber int4 10  √  null
tagnumber text 2147483647  √  null
startdate date 13  √  null
enddate date 13  √  null
datetime timestamp 29,6  √  null
lc bpchar 1  √  null
lat1 text 2147483647  √  null
lon1 text 2147483647  √  null
tagdate date 13  √  null
tagcode text 2147483647  √  null
modelname text 2147483647  √  null

Analyzed at Wed Dec 27 13:25 PST 2017