Table topp.public.satdeployments
This is a critical table for controlling the nightly Argos download. Several fields must be populated for a specific PTT download. These are eventid, pttnumber, speciesname, and startdate. Commonly PTTs are predeployed by using temporary eventids and speciesnames. 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 serial 10  √  nextval('satdeployments_satdeploymentid_seq'::regclass)
toppid text 2147483647  √  null The basic ID number for a specific animal deployment. Matches the first 7 digits of eventid.
pttnumber int4 10  √  null
speciesname text 2147483647  √  null Matches lsdname in toppspecies. Controls naming of folders in Argos directory. The predeploy value is usually "unknown" but it can be anything.
startdate date 13  √  null The Argos data for this tagnumber and pttnumber combo is filtered by this lower date.
enddate date 13  √  null The Argos data for this tagnumber and pttnumber combo is filtered by this upper date.
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 Eventid can take on several forms in this table, but some value is necessary for the record to be active in the Argos download script. Typically we start with a predeploy eventid that omits the 2 digit species prefix. Once the tag has been deployed then a permanent eventid is assigned. It breaks down into several components. The first 2 digits are species ID. Digits 3 and 4 represent deployment year. Digits 5 - 7 count from 1 and represent individual animal deployments for the year. Digits 8 and 9 count from 0 and represent individual tags from the individual animal deployment.
las text 2147483647  √  null
tagcode varchar 50  √  null
starttime time 15,6  √  null
endtime time 15,6  √  null
est_end_date date 13  √  null

Table contained 4,646 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
satdeploymentid Primary key Asc satdeployments_pkey
pttnumber Performance Asc satdeployments_pttnumber
pttnumber + startdate Performance Asc/Asc testindexsatdeployments