Table topp.public.tblfg_pdt
This table contains Wildlife PDT data from all available fishgroup tags.

 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
eventid int4 10  √  null
pttnumber int4 10  √  null
date date 13  √  null
time time 15,6  √  null
depth float4 8,8  √  null
mintemp float4 8,8  √  null
maxtemp float4 8,8  √  null
tkey serial 10  √  nextval('tblfg_pdt_tkey_seq'::regclass)
toppid int4 10  √  null

Table contained 734,903 rows at Wed Dec 27 13:25 PST 2017

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