Table topp.public.tblfg_tat
This table contains Wildlife time at temperature data from all available fishgroup tags. It is easy to join with a programming table (using eventid) to get the temperature value for each bin_num, but it is tricky to parse out into individual fields.

 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('tblfg_tat_tkey_seq'::regclass)
eventid int4 10  √  null
pttnumber int4 10  √  null
date date 13  √  null
time time 15,6  √  null
bin_num int4 10  √  null
fraction float4 8,8  √  null
toppid int4 10  √  null

Table contained 749,419 rows at Wed Dec 27 13:25 PST 2017

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