Table topp.wc2.locations 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
deployid text 2147483647  √  null
ptt int4 10  √  null
instr text 2147483647  √  null
date timestamptz 35,6  √  null
type text 2147483647  √  null
quality text 2147483647  √  null
latitude float8 17,17  √  null
longitude float8 17,17  √  null
error_radius int4 10  √  null
error_semi.major.axis int4 10  √  null
error_semi.minor.axis int4 10  √  null
error_ellipse.orientation int4 10  √  null
offset bool 1  √  null
offset_orientation bool 1  √  null
gpe_msd bool 1  √  null
gpe_u bool 1  √  null
count bool 1  √  null
comment text 2147483647  √  null
wc_id text 2147483647  √  null

Table contained 28,863 rows at Wed Dec 27 13:28 PST 2017