Table topp.public.argos_diag_with_lc_lat_lon_changed_rows 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 0 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
pttnumber Performance Asc changed_rows_index
pttnumber + datetime Performance Asc/Asc changed_rows_index_pttnumber_datetime