Table topp.public.argos_diag_with_lc_lat_lon 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
pttnumber int4 10  √  null
contents text 2147483647  √  null
lc bpchar 1  √  null
lat1 numeric 131089  √  null
lat2 numeric 131089  √  null
lon1 numeric 131089  √  null
lon2 numeric 131089  √  null
datetime timestamp 29,6  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
pttnumber + datetime Performance Asc/Asc argos_diag_btree  
pttnumber + datetime Must be unique Asc/Asc argos_diag_with_lc_lat_lon_unique These unique columns are also nullable