Table topp.public.tbldrifter_ssts
This table contains SST data from drifting popup tags. The data comes from the Wildlife Computers -Status.csv file. The table is updated nightly for any actively transmitting tags within the last 90 days.

 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
tkey serial 10  √  nextval('tbldrifter_ssts_tkey_seq'::regclass)
eventid int4 10  √  null
ptt int4 10  √  null
datetime timestamp 29,6  √  null
londd float8 17,17  √  null
latdd float8 17,17  √  null
sst float8 17,17  √  null
depth float8 17,17  √  null
location_quality text 2147483647  √  null

Table contained 12,291 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
tkey Primary key Asc tbldrifter_ssts_pkey