Table topp.deprecated.psat_geolocation 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
akey serial 10  √  nextval('deprecated.psat_geolocation_akey_seq'::regclass)
tblsgadeployment.akey Implied Constraint R
toppid text 2147483647  √  null
tagcode text 2147483647  √  null
date text 2147483647  √  null
sslat text 2147483647  √  null
sslon text 2147483647  √  null
mv text 2147483647  √  null
lon text 2147483647  √  null
lat text 2147483647  √  null
maxdepth text 2147483647  √  null
cloudcover text 2147483647  √  null
ssttype text 2147483647  √  null
idx1 text 2147483647  √  null
idx2 text 2147483647  √  null
idx3 text 2147483647  √  null
idx4 text 2147483647  √  null
surfacetemps text 2147483647  √  null

Table contained 559 rows at Wed Dec 27 13:21 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
akey Primary key Asc psat_geolocation_pkey

Close relationships: