Table topp.public.tblmarlin_geodata_ssm
This table combines the standard SSM output with basic marlin metadata for all marlin with SSM data.

 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('tblmarlin_geodata_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 26,306 rows at Wed Dec 27 13:25 PST 2017

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