View topp.public.diag_satdeployments_mc
This view gathers transmitted Argos data for tags with records in the satdeployments table having valid startdate values. It includes all fields from satdeployments plus the Argos data. Joins to this table will usually be made to eventid, pttnumber or toppid.

 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
satdeploymentid int4 10  √  null
toppid text 2147483647  √  null
pttnumber int4 10  √  null
speciesname text 2147483647  √  null
startdate date 13  √  null
enddate date 13  √  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
las text 2147483647  √  null
tagcode varchar 50  √  null
starttime time 15,6  √  null
endtime time 15,6  √  null
est_end_date date 13  √  null
datetime timestamp 29,6  √  null UTC datetime for Argos record.
contents text 2147483647  √  null The date, LC and lat/lon values for an Argos record in one large field.
lc bpchar 1  √  null

Analyzed at Wed Dec 27 13:25 PST 2017