Table popler_3.public.taxa_accepted_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_accepted_table_key serial 10  √  nextval('taxa_accepted_table_taxa_accepted_table_key_seq'::regclass)
taxa_original_fkey int4 10  √  null
taxa_table.taxa_table_key taxa_accepted_table_taxa_original_fkey_fkey C
sppcode varchar 100  √  null
kingdom_accepted varchar 100  √  null
subkingdom_accepted varchar 100  √  null
infrakingdom_accepted varchar 100  √  null
superdivision_accepted varchar 100  √  null
division_accepted varchar 100  √  null
superphylum_accepted varchar 100  √  null
phylum_accepted varchar 100  √  null
subphylum_accepted varchar 100  √  null
subdivision_accepted varchar 100  √  null
clss_accepted varchar 100  √  null
subclass_accepted varchar 100  √  null
ordr_accepted varchar 100  √  null
family_accepted varchar 100  √  null
genus_accepted varchar 100  √  null
species_accepted varchar 100  √  null
common_name_accepted varchar 100  √  null
authority varchar 100  √  null
taxa_accepted_db varchar 100  √  null
taxa_accepted_db_id varchar 100  √  null
taxa_accepted_db_url text 2147483647  √  null

Table contained 0 rows at Wed Aug 30 10:19 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
taxa_accepted_table_key Primary key Asc taxa_accepted_table_pkey

Close relationships  within of separation: