SchemaSpy - Table topp.public.tblyft

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Auto	Default
fid_	serial	10		√	nextval('tblyft_geodata_fid__seq'::regclass)
date_	text	2147483647	√		null
month_text	text	2147483647	√		null
day_	text	2147483647	√		null
year_	text	2147483647	√		null
llong	text	2147483647	√		null
delta_long	text	2147483647	√		null
llat	text	2147483647	√		null
comments	text	2147483647	√		null
tag_code	text	2147483647	√		null
toppid_txt	text	2147483647	√		null
genus_sp	text	2147483647	√		null
common_nam	text	2147483647	√		null
max_temp	text	2147483647	√		null
max_depth	text	2147483647	√		null
min_depth	text	2147483647	√		null
sst	text	2147483647	√		null
sst_min	text	2147483647	√		null
sst_max	text	2147483647	√		null
sst_median	text	2147483647	√		null
sunriseutc	text	2147483647	√		null
sunsetutc	text	2147483647	√		null
opacity	text	2147483647	√		null
low_lim_mi	text	2147483647	√		null
longitude_txt	text	2147483647	√		null
latitude_txt	text	2147483647	√		null
tag_type	text	2147483647	√		null
positiontype	text	2147483647	√		null
length	text	2147483647	√		null
age	text	2147483647	√		null
breedingst	text	2147483647	√		null
latitude	float8	17,17	√		null
longitude	float8	17,17	√		null
topp_id	int4	10	√		null
fgdkey	int4	10	√		null
month_	int4	10	√		null
length_sfl	text	2147483647	√		null

Table contained 30,367 rows at Wed Dec 27 13:25 PST 2017

Indexes:

Column(s)	Type	Sort	Constraint Name
fid_	Primary key	Asc	tblyft_geodata_pkey