SchemaSpy - Table topp.wc.all

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
deployid	text	2147483647	√	null
platform_id.no.	int4	10	√	null
prg_no.	int4	10	√	null
latitude	float8	17,17	√	null
longitude	float8	17,17	√	null
loc_.quality	text	2147483647	√	null
loc_.date	timestamptz	35,6	√	null
loc_.type	text	2147483647	√	null
altitude	int4	10	√	null
pass	int4	10	√	null
sat_	text	2147483647	√	null
mote_id	bool	1	√	null
frequency	float8	17,17	√	null
msg_date	timestamptz	35,6	√	null
comp_	int4	10	√	null
msg	int4	10	√	null
x_...120.db	int4	10	√	null
best_level	int4	10	√	null
delta_freq.	float8	17,17	√	null
long_.1	float8	17,17	√	null
lat_.sol..1	float8	17,17	√	null
long_.2	float8	17,17	√	null
lat_.sol..2	float8	17,17	√	null
loc_.idx	int4	10	√	null
nopc	int4	10	√	null
error_radius	int4	10	√	null
semi_major.axis	int4	10	√	null
semi_minor.axis	int4	10	√	null
ellipse_orientation	int4	10	√	null
gdop	int4	10	√	null
sensor_.01	int4	10	√	null
sensor_.02	int4	10	√	null
sensor_.03	int4	10	√	null
sensor_.04	int4	10	√	null
sensor_.05	int4	10	√	null
sensor_.06	int4	10	√	null
sensor_.07	int4	10	√	null
sensor_.08	int4	10	√	null
sensor_.09	int4	10	√	null
sensor_.10	int4	10	√	null
sensor_.11	int4	10	√	null
sensor_.12	int4	10	√	null
sensor_.13	int4	10	√	null
sensor_.14	int4	10	√	null
sensor_.15	int4	10	√	null
sensor_.16	int4	10	√	null
sensor_.17	int4	10	√	null
sensor_.18	int4	10	√	null
sensor_.19	int4	10	√	null
sensor_.20	int4	10	√	null
sensor_.21	int4	10	√	null
sensor_.22	int4	10	√	null
sensor_.23	int4	10	√	null
sensor_.24	int4	10	√	null
sensor_.25	int4	10	√	null
sensor_.26	int4	10	√	null
sensor_.27	int4	10	√	null
sensor_.28	int4	10	√	null
sensor_.29	int4	10	√	null
sensor_.30	int4	10	√	null
sensor_.31	int4	10	√	null
sensor_.32	bool	1	√	null
wc_id	text	2147483647	√	null

Table contained 106,520 rows at Wed Dec 27 13:27 PST 2017