Table topp.public.argos_prv
This table contains raw Argos prv data for allactive PTTs in program 2621 and any others for which we are user-on-copy or a password has been shared with us. The table is updated nightly. It is a sourcetable for many others.

 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
pttnumber int4 10  √  null
datetime int4 10  √  null
satellite text 2147483647  √  null
contents text 2147483647  √  null

Table contained 2,857,223 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
pttnumber + datetime + satellite Performance Asc/Asc/Asc argos_prv_match_cols
pttnumber + datetime Performance Asc/Asc argos_prv_vs_satdeployments