Table topp.public.tblfg_ssm
This table combines the standard SSM output with basic metadata for fish with SSM data, except for ABFT, PBFT and marlin.

 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_ssm_tkey_seq'::regclass)
eventid int4 10  √  null
tagcode text 2147483647  √  null
ptt int4 10  √  null
month_ int4 10  √  null
day_ int4 10  √  null
year_ int4 10  √  null
datetime text 2147483647  √  null
seriesname text 2147483647  √  null
comments text 2147483647  √  null
version text 2147483647  √  null
lat float8 17,17  √  null
lon float8 17,17  √  null
lat025 float8 17,17  √  null
lon025 float8 17,17  √  null
lat5 float8 17,17  √  null
lon5 float8 17,17  √  null
lat975 float8 17,17  √  null
lon975 float8 17,17  √  null
mplat float8 17,17  √  null
mplon float8 17,17  √  null
lon180 float8 17,17  √  null

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

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