SchemaSpy - View topp.public.argos_diag_with_lc_lat_lon

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
hit_ptt	int4	10	√	null
lc	bpchar	1	√	null
lat1	numeric	131089	√	null
lon1	numeric	131089	√	null
lat2	numeric	131089	√	null
lon2	numeric	131089	√	null
contents	text	2147483647	√	null
hit_t	timestamp	29,6	√	null
eventid	int4	10	√	null
table_schema	text	2147483647	√	null
table_name	text	2147483647	√	null
column_name	text	2147483647	√	null
species_code	int4	10	√	null
two_digit_year	int4	10	√	null
four_digit_year	int4	10	√	null
species_year_serial	int4	10	√	null
multi_tag_serial	int4	10	√	null
toppid	int4	10	√	null
ptt	int4	10	√	null
animal_name	text	2147483647	√	null
local_deployment_name	text	2147483647	√	null
deployment_date	timestamptz	35,6	√	null
tag_model	text	2147483647	√	null
tag_description	text	2147483647	√	null
testingnote	text	2147483647	√	null
ownerid	int4	10	√	null
wc_id	text	2147483647	√	null
priority	int4	10	√	null
ssm_tr	int4	10	√	null
vis_prob	int4	10	√	null
rerun	int4	10	√	null
atn_replaced	int4	10	√	null
comments	text	2147483647	√	null
contact	text	2147483647	√	null
embargountil	date	13	√	null
vis_filter	int4	10	√	null
embargolon	float4	8,8	√	null
embargolat	float4	8,8	√	null
plot_points	int4	10	√	null
plot_dashes	int4	10	√	null
plot_icon	int4	10	√	null
atn_name	text	2147483647	√	null

Analyzed at Wed Dec 27 13:25 PST 2017