Table popler_3.public.count_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
count_table_key serial 10  √  nextval('count_table_count_table_key_seq'::regclass)
taxa_count_fkey int4 10  √  null
taxa_table.taxa_table_key count_table_taxa_count_fkey_fkey C
site_in_project_count_fkey int4 10  √  null
site_in_project_table.site_in_project_key count_table_site_in_project_count_fkey_fkey C
year numeric 131089  √  null
month numeric 131089  √  null
day numeric 131089  √  null
spatial_replication_level_1 varchar 50  √  null
spatial_replication_level_2 varchar 50  √  null
spatial_replication_level_3 varchar 50  √  null
spatial_replication_level_4 varchar 50  √  null
spatial_replication_level_5 varchar 50  √  null
treatment_type_1 varchar 200  √  null
treatment_type_2 varchar 200  √  null
treatment_type_3 varchar 200  √  null
structure_type_1 varchar 200  √  null
structure_type_2 varchar 200  √  null
structure_type_3 varchar 200  √  null
count_observation numeric 131089  √  null
covariates text 2147483647  √  null
metadata_count_key int4 10  √  null
structure_type_4 varchar 50  √  null

Table contained 3,064,791 rows at Wed Aug 30 10:19 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
count_table_key Primary key Asc count_table_pkey

Close relationships  within of separation: