Table topp.public.tblpbft_geodata_ssm
This table combines the standard SSM output with basic PBFT metadata for all PBFT 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('tblpbft_geodata_ssm_tkey_seq'::regclass)
eventid int4 10  √  null
toppid int4 10  √  null
tagcode text 2147483647  √  null
month_ int4 10  √  null
day_ int4 10  √  null
year_ int4 10  √  null
datetime text 2147483647  √  null
seriesname text 2147483647  √  null
length float8 17,17  √  null
age float8 17,17  √  null
tagtype 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
length_sfl float8 17,17  √  null
lon180 float8 17,17  √  null

Table contained 93,911 rows at Wed Dec 27 13:25 PST 2017

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