SchemaSpy - Table topp.public.toppspecies

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
speciescode	int4	10
commonname	text	2147483647	√	null
genus	text	2147483647	√	null
species	text	2147483647	√	null
taxon	text	2147483647	√	null
workgroup	text	2147483647	√	null
abbrev	text	2147483647	√	null
lsdname	text	2147483647	√	null
contact	text	2147483647	√	null
project	int4	10	√	null
commercial	int4	10	√	null
filter	text	2147483647	√	'goodWaterFailsafe'::text
comments	text	2147483647	√	null
pagename	text	2147483647	√	null

Table contained 94 rows at Wed Dec 27 13:25 PST 2017

Indexes:

Column(s)	Type	Sort	Constraint Name
speciescode	Primary key	Asc	toppspecies_pkey