SchemaSpy - Table topp.public.satellitelocation

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
datetime	timestamptz	35,6
lc	varchar	1	√	null
iq	varchar	2	√	null
lat1	float4	8,8	√	null
long1	float4	8,8	√	null
lat2	float4	8,8	√	null
long2	float4	8,8	√	null
lat	float4	8,8	√	null
long	float4	8,8	√	null
passed	varchar	1	√	null
toppid	varchar	20
tagnumber	varchar	80

Table contained 12,689 rows at Wed Dec 27 13:25 PST 2017

Indexes:

Column(s)	Type	Sort	Constraint Name
toppid + tagnumber + datetime	Primary key	Asc/Asc/Asc	satellitelocation_pkey
datetime	Performance	Asc	satellitelocation_datetime
toppid	Performance	Asc	satellitelocation_toppid
toppid + tagnumber	Performance	Asc/Asc	satellitelocation_toppid_tagnumber