Table popler_3.public.taxa_table Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
taxa_table_key serial 10  √  nextval('taxa_table_taxa_table_key_seq'::regclass)
biomass_table.taxa_biomass_fkey biomass_table_taxa_biomass_fkey_fkey C
count_table.taxa_count_fkey count_table_taxa_count_fkey_fkey C
density_table.taxa_density_fkey density_table_taxa_density_fkey_fkey C
individual_table.taxa_individual_fkey individual_table_taxa_individual_fkey_fkey C
percent_cover_table.taxa_percent_cover_fkey percent_cover_table_taxa_percent_cover_fkey_fkey C
taxa_accepted_table.taxa_original_fkey taxa_accepted_table_taxa_original_fkey_fkey C
site_in_project_taxa_key int4 10  √  null
site_in_project_table.site_in_project_key taxa_table_site_in_project_taxa_key_fkey C
sppcode varchar 100  √  null
kingdom varchar 100  √  null
subkingdom varchar 100  √  null
infrakingdom varchar 100  √  null
superdivision varchar 100  √  null
division varchar 100  √  null
subdivision varchar 100  √  null
superphylum varchar 100  √  null
phylum varchar 100  √  null
subphylum varchar 100  √  null
clss varchar 100  √  null
subclass varchar 100  √  null
ordr varchar 100  √  null
family varchar 100  √  null
genus varchar 100  √  null
species varchar 100  √  null
common_name varchar 100  √  null
authority varchar 100  √  null
metadata_taxa_key int4 10  √  null

Table contained 61,880 rows at Wed Aug 30 10:19 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
taxa_table_key Primary key Asc taxa_table_pkey

Close relationships  within of separation: